Entity Framework 6 - Knowledge Base (KB)
79 results in tag: linq-to-sql
LINQ to SQL vs. Entity Framework
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
Performance of Linq To SQL versus Entity Framework
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
In Linq to SQL with Entity Framework, how do you compare solely Date without Time in DateTime types?
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
In ADO.NET Entity Framework, how can I start a stored procedure?
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 handle several result sets from a stored method (each from connected tables)?
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
Select specified columns and return strongly typed without loosing cast using Entity Framework.
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 can't ToString() be used in a LINQ query by Entity Framework?
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
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
What's the difference between Entity Framework and.NET 4.0's LINQ to SQL?
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ı
[extension] methods for LINQPad
Does anyone have a complete list of LINQPad extension methods and methods, such as....Dump() SubmitChanges()
asked by Bent Rasmussen
Linq to Entities vs. Linq to SQL vs. Entity Framework
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.
Stored procedures vs. LINQ queries
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
Framework for Entities Choose a new POCO without. ToList() comes 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
In Linq, what is the difference between.edmx and.dbml files?
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
In MVC/Entity Framework, here's how to remove objects: Because it was not detected in the ObjectStateManager, the object could not be destroyed.
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
Compare and contrast two things of the same kind.
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
When I attempt to edit a model in Entity Framework, I receive a "Unable to update the EntitySet since it includes a DefiningQuery..." error.
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
WHERE clause in LINQ to SQL MAX
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.
In a LINQ to SQL query, convert a datetime to a formatted text.
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
In Entity Framework, what is the difference between Select and Where?
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
