Entity Framework 6 - Knowledge Base (KB)
79 results in tag: linq-to-sql
Entity Framework vs LINQ to SQL
Now that .NET v3.5 SP1 has been released (along with VS2008 SP1), we now have access to the .NET entity framework....My question is this. When trying to decide between using the Entity Framework and LINQ to SQL as an ORM, what's the difference?...The way...
asked by Chris Roberts
Linq To Sql vs Entity Framework Performance
I have been searching for recent performance benchmarks that compare L2S and EF and couldnt find any that tested calling stored procedures using the released version of EF. So, I ran some of my own tests and found some interesting results....Do these resu...
asked by Vyrotek
How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
Is there a way to compare two ...DateTime... variables in ...Linq2Sql... but to disregard the Time part....The app stores items in the DB and adds a published date. I want to keep the exact time but still be able to pull by the date itself....I want to co...
asked by Sruly
How do I run a stored procedure in ADO.NET Entity Framework?
How to use stored procedure in ADO.NET Entity Framework?...My Table : MyCustomer...Columns: CustomerID PK int Name nvarchar(50) SurName nvarchar(50) ...My stored procedure...ALTER procedure [dbo].[proc_MyCustomerAdd] (@Name ...
asked by Penguen
Can Entity Framework deal with multiple result sets (each from joined tables) from a stored procedure?
In Linq to SQL, I can't find an easy way to deal with multiple result sets returned by a stored procedure where each result set is from table joins. Each result set does not map directly to a table. (can't change this behavior). For now, it seems using a ...
asked by Tony_Henrich
Entity Framework - Select specific columns and return strongly typed without losing cast
I'm trying to do something similar to ...this post... where I don't pull back all columns from a particular entity, however my framework makes use of inheritence and I lose scope of the entity type after it's been cast to an anonymous type. ...The structu...
asked by XVargas
Why would Entity Framework not be able to use ToString() in a LINQ statement?
This ...works... in LINQ-to-SQL:...var customersTest = from c in db.Customers select new { Id = c.Id, Addresses = from a in db.Addresses where c.Id.ToString() == ...
asked by Edward Tanguay
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
What is the difference between Entity Framework and LINQ to SQL by .NET 4.0?
I was checking ...2nd edition of Professional ASP.NET MVC... and realized EF replaced LINQ to SQL. I am familiar to LINQ to SQL from the first book but I know nothing about EF. Anyway while reading the code, it seems like nothing has changed except the na...
asked by Ufuk Hacıoğulları
LINQPad [extension] methods
Does anyone have a complete list of LINQPad extension methods and methods, such as....Dump() SubmitChanges()
asked by Bent Rasmussen
Entity Framework vs Linq to Entities vs Linq to SQL
I read a lot of articles about how to work with a database in WPF .Net 4 application. As I understood, the main two technologies are:...Linq to SQL (L2S)...Entity Framework (EF)...but sometimes I also can see mention of Linq to Entities (L2E) technology, ...
asked by Mike B.
LINQ queries vs Stored procedures
What are the pros and cons of using linq queries(along with an ORM like EF or linq2sql) VS. Stored Procedures(SQL server 2008) to query and update a data model? Performance? Speed? Etc...
asked by stephen776
Entity Framework Select new POCO without .ToList() first
I'm creating an application with a service layer (WCF Website) and a Silverlight 4 Client. RIA Services are not an option, so we create intermediary classes to pass back and forth. For the purpose of this question let's assume I'm passing back and forth...
asked by Jacob
What is difference between .edmx and .dbml file in linq?
What is difference between .edmx and .dbml file in linq?In VS 2008 which datasource is best choice where edmx or dbml?Any problem will arise using edmx file in VS 2008?Can i use edmx in VS-2008?
asked by user649802
How to delete objects in MVC/Entity Framework: The object cannot be deleted because it was not found in the ObjectStateManager
I get an error message when trying to delete a user and associated objects. The error message is ...The object cannot be deleted because it was not found in the ObjectStateManager....CONTROLLER...[Authorize, HttpPost] public ActionResult DeleteUser(s...
asked by Prabhu
Find differences between two entities of the same type
I'm working on an mvc3 web app. When the user updates something, I want to compare the old data to the new one the user is inputing and for each field that is different add those to a log to create an activity log....Right now this is what my save action ...
asked by LanFeusT
Why am I getting a "Unable to update the EntitySet because it has a DefiningQuery..." exception when trying to update a model in Entity Framework?
While updating with the help of LINQ to SQL using Entity Framework, an exception is thrown....System.Data.UpdateException: Unable to update the EntitySet 't_emp' because it has a DefiningQuery and no <UpdateFunction> element exists in the <Modificatio...
asked by Thomas Mathew
LINQ to SQL MAX in WHERE clause
I am new to Linq so as expected I have encountered difficulties. What I am trying to achieve is this:...SELECT id, name, password FROM users u WHERE u.id = (SELECT MAX(u1.id) FROM users u1); ...My Linq is:...var dbUsers = from u in context.Users ...
asked by Michael H.
Convert datetime to a formatted string inside a LINQ to SQL query
I know that LINQ to SQL does not convert ...DateTime... to ...string... since there is no ...ToString()... in SQL. But how can I convert the ...DateTime... into a formatted string?...This is the line in the following query that needs help:...StartDate = s...
asked by kandroid
Difference between Select and Where in Entity Framework
What is the difference between ....Select()... and ....Where()... in Entity Framework? Eg ...return ContextSet().Select(x=> x.FirstName == "John") ...vs...ContextSet().Where(x=> x.FirstName == "John") ...When should I use ....Select... vs ....Where...?
asked by Anish
Page 1 of 4
