zzz projects Entity Framework 6 EF 6
Home EF Core 5 Articles Knowledge Base Online Examples
  • Home
  • EF Core 5
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

79 results for: 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...
.net entity-framework linq-to-sql
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...
entity-framework linq-to-sql performance stored-procedures
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...
.net c# database entity-framework linq-to-sql
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 ...
.net c# entity-framework linq-to-sql
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 ...
entity-framework linq-to-entities linq-to-sql
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...
asp.net-mvc entity-framework inheritance linq linq-to-sql
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() == ...
c# entity-framework linq linq-to-sql
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...
ado.net entity-framework linq-to-entities linq-to-sql sql
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...
.net .net-4.0 entity-framework linq-to-sql
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()
.net c# entity-framework linqpad linq-to-sql
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, ...
ado.net entity-framework linq-to-entities linq-to-sql
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...
.net entity-framework linq linq-to-sql sql-server
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...
entity-framework linq linq-to-entities linq-to-sql
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?
entity-framework linq linq-to-entities linq-to-sql
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...
.net asp.net-mvc c# entity-framework linq-to-sql
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 ...
asp.net-mvc entity-framework linq-to-sql
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...
asp.net-mvc entity-framework exception linq-to-sql
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 ...
entity-framework linq linq-to-entities linq-to-sql
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...
entity-framework linq linq-to-sql
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...?
.net c# entity-framework linq linq-to-sql
asked by Anish

Page 1 of 4
  • 1
  • 2
  • 3
  • 4
  • »

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

Try for free now