Entity Framework 6 - Knowledge Base (KB)
274 results in tag: sql
Group Optimization In LINQ to Entities, by
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
In LinQ-to-Entities, adding to the Where clause of an Update
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
Entity Framework Join and Include
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 exactly 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
Using sql server compact edition to insert OR update (upsert).
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 feasible to use entity framework with native SQL?
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
Entity Framework for SQL Server Compact Edition
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
SQL update query in Zend Framework
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 The argument " is missing from the procedure or function ".
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
What's the difference between Entity Framework, LINQ to SQL, and 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
The best SQL Server storage pattern for (product) characteristics
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
Using the entity framework to limit query size
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
Where IN clause in LINQ to Entities 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 appropriately handle SQL constraint-related errors
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
Inserts/deletes/updates are not visible in SQL Profiler.
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
Problems with Entity Framework Connection Strings
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 can I update the ADO.NET Entity Data Model quickly?
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
Exception in a Windows form application
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
Savechanges returns the latest insert id to asp mvc ()
im using poco code first . how do i get the last insert after savechanges() ?...thanks
asked by colorblack04
Entity Framework provides concurrent database access == 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
