Entity Framework Detach vs Remove

What's the difference between Entity Framework, LINQ to SQL, and ADO.NET with stored procedures?

First off, if you're starting a new project, go with Entity Framework ("EF") - it now generates much better SQL (more like Linq to SQL does) and is easier to maintain and more powerful than Linq to SQL ("L2S"). As of the release of .NET 4.0, I consider Linq to SQL to be an obsolete technology. MS has been very open about not continuing L2S develo...

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, but can't find clear explanation what difference between EF and L2E....So, my question is: Does...

Database upgrade problem with DevExpress XPO, NHibernate, and Entity Framework

I can't comment on the other ORM's, but I have used DevExpress XPO for a corporate treasury application since 2007. The schema changes a little with every release but there have also been some big schema changes over the years as well. A somewhat extended version of the default XPO upgrade mechanism has comfortably catered for all the changes....

Entity Framework .Remove() vs. .DeleteObject()

If you really want to use Deleted, you'd have to make your foreign keys nullable, but then you'd end up with orphaned records (which is one of the main reasons you shouldn't be doing that in the first place). So just use ...Remove()...ObjectContext.DeleteObject(entity)... marks the entity as Deleted in the context. (It's EntityState is Deleted afte...

Entity Framework - CreateQuery VS ExecuteFunction VS ExecuteStoreQuery VS ExecuteStoreCommand

What are the differences between following-...CreateQuery()  ExecuteFunction(), ExecuteStoreQuery() and ExecuteStoreCommand() ...As per my knowledge CreateQuery is used for Entity SQL & rest of the methods are used for sql function or stored procedure defined in DB....As per ObjectContext class meta data they are as follow:...CreateQuery():Create...

Entity Framework DbContext .Remove(obj) vs .Entry(obj).State = EntityState.Deleted

I'm using EF Code first. a simple model:... item { public int Id {set; get;},... ,ICollection<ItemImages> {set; get;} } itemImages { public int Id {set; get; }, public int ItemId {set; get; } , ... , public Item Item {set; get; } } ItemConfig:EntityTypeConfiguration<Item> { //some config statemen...

entity framework Remove vs EntityState.Deleted

What is the diff between these two statements?...Both should delete an entity.... _context.Entry(new Schoolyear { Id = schoolyearId }).State = EntityState.Deleted; _context.Schoolyears.Remove(new Schoolyear { Id = schoolyearId }); ...and for those who does not know the EF Extensions:... _context.Schoolyears.Delete(s => s.Id == schoolyearId); ...Th...

Entity Framework SaveChanges() vs. SaveChangesAsync() and Find() vs. FindAsync()

Any time that you need to do an action on a remote server, your program generates the request, sends it, then waits for a response. I will use ...SaveChanges()... and ...SaveChangesAsync()... as an example but the same applies to ...Find()... and ...FindAsync().......Say you have a list ...myList... of 100+ items that you need to add to your databa...

Entity Framework Remove vs State.Deleted

Plain and simple, is there any difference between...DbSet().Remove(x) ...to ...context.Entry(x).State = State.Deleted?...Thanks

In SQL Server, Entity Framework 6 vs. Dapper vs. stored procedures vs. requests

I have EF with LINQ with SQL Server in my project a long time....And I was searching for a way to improve a performance of my requests to DB. And I read a lot of about Dapper and Procedures, that it's faster than EF. I added Dapper to project, I added procedure.... but my tests showed strange results. EF and Dapper and stored procedures have almost...