Entity Framework 6 - Knowledge Base (KB)
274 results in tag: sql
Optimize Group By in LINQ to Entities
I have this query in LINQ to Entities.... var query = (from s in db.ForumStatsSet where s.LogDate >= date1 && s.LogDate <= date2 group s by new { s.Topic.topicID, s.Topic.subject, s.Topic.Forum.forumName, s...
asked by Olaj
Adding to the Where clause of an Update in LinQ-to-Entities
Let's say I have a table called Product, with three columns: Id, CustomerId, Name. Id is the primary key. The schema is outside of the control of my group, and we now have a requirement to always provide CustomerId as a parameter for all queries (selects...
asked by Joel Martinez
Join and Include in Entity Framework
I have the following query of linq to entities. The problem is that it doesn't seem to load the "Tags" relation even though i have included a thing for it. It works fine if i do not join on tags but i need to do that.... var items = from i in d...
asked by Olaj
What is datetime2?
I´ve got this in a INSERT statment to MSSQL 2008...System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
asked by Glenn
Performing Insert OR Update (upsert) on sql server compact edition
I have c# project that is using sqlserver compact edition and entity framework for data access. I have the need to insert or update a large amount of rows, 5000+ or more to the db, so if the key exists update the record if not insert it. I can not find ...
asked by RBear
Is it possible to run native sql with entity framework?
I am trying to search an XML field within a table, This is not supported with EF....Without using pure Ado.net is possible to have native SQL support with EF?
asked by user80855
SQL Server Compact Edition with Entity Framework
I try to use SQL Server Compact Edition with Entity Framework in Visual Studio 2008 SP1. Here's what I do:...1) I create a new project, of type Console Application....2) I right-click on the project, select Add->New Item....3) I choose to add a Local Data...
asked by Nitramk
Zend Framework SQL update query
How would I write this SQL the Zend Framework way?...UPDATE register SET balance = (balance + 10) WHERE added_date > 1259944184 ; ...I can't find any examples of this on Zend's website or the web....Do I need to use "...Zend_Db_Expr..."?
asked by EricP
EntityFramework Procedure or function '' expects parameter '', which was not supplied
I apologise for asking just a basic question, however I cannot find the cause of this error....I am using Entity Framework to execute a Stored Procedure, and I am passing in four parameters, however the SQL Database seems to reject them. Can anyone point ...
asked by James
Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?
How would you rate each of them in terms of:...Performance...Speed of development...Neat, intuitive, maintainable code...Flexibility...Overall...I like my SQL and so have always been a die-hard fan of ADO.NET and stored procedures but I recently had a pla...
asked by BritishDeveloper
Best pattern for storing (product) attributes in SQL Server
We are starting a new project where we need to store product and many product attributes in a database. The technology stack is MS SQL 2008 and Entity Framework 4.0 / LINQ for data access....The products (and Products Table) are pretty straightforward (a...
asked by EdH
Limiting query size with entity framework
this is a simple question (I think), but I have not been able to find a solution. I know with other types of queries, you can add a limit clause that makes the query only return up to that many results. Is this possible with an entity query?...var product...
asked by PFranchise
LINQ to Entities - Where IN clause in query
Possible Duplicates:...Linq to Entities - Sql “IN” clause...How to implement SQL “in” in Entity framework 4.0...how can I add WHERE IN statement like......SELECT * FROM myTable WHERE ID IN (1,2,3,4,5) ...in entity framework
asked by Muhammad Akhtar
Entity Framework: How to properly handle exceptions that occur due to SQL constraints
I use Entity Framework to access my SQL data. I have some constraints in the database schema and I wonder how to handle exceptions that are caused by these constraints....As example, I get the following exception in a case where two users try to add an (a...
asked by driAn
SQL Profiler not showing inserts/deletes/updates
When I run the profiler while running my application, it only seems to show SELECTs, not INSERTs or anything that changes the database. Yet my database is being updated, so those commands must be being executed. What do I have to do to get it to show upda...
asked by Cynthia
Entity Framework Connection String Trouble
I am making a little library(DLL) to manage users and their roles/privileges. The plan is to be able to add this dll to an MVC project and be able to manipulate users/roles/etc. All the data resides in a SQL db....I am using entity framework for data ac...
asked by Jason
How to quickly refresh ADO.NET Entity Data Model?
I am using ADO.NET Entity Data Model in my C# project. There is an ADO.NET Entity Data Model that is generated on the DB in my project. How do I quickly refresh the ADO.NET Entity Data Model based on DB changes? I have been deleting the model and then cre...
asked by Anton
Windows form application exception
I get application exception... at System.Windows.Forms.CurrencyManager.get_Item(Int32 index) at System.Windows.Forms.CurrencyManager.get_Current() at System.Windows.Forms.DataGridView.DataGridViewDataConnection.OnRowEnter(DataGridViewCellEventArgs...
asked by Anton
asp mvc get last insert id from savechanges()
im using poco code first . how do i get the last insert after savechanges() ?...thanks
asked by colorblack04
Concurrent access to a database with Entity Framework == EntityException
I've a MS SQL 2008 database which is accessed through LINQ for data update/retrival....My linq is accessed by WCF services in a PerCall instantiation mode for an heavy application. This application has several thread which makes calls to the service, and ...
asked by J4N
Page 1 of 14
