Entity Framework Paging

Adding existing entities to a collection on a newly built object using the entity framework

"Attach" is not allowed because you haven't saved the order yet. Calling "Add" tells Entity Framework that you want to insert a new contact. So you are left with only one option. You need to load the contact....Here's the fastest way to do that:...OrderDetails context = new OrderDetails(); Contact contact = context.GetObjectByKey(new EntityKey("Ord...

LINQ to Entities only supports casting in the Entity Framework. basic kinds in the Entity Data Model

I know this is old, but I was looking to accomplish the exact same thing as the OP and didn't want to use the ...Func<IQueryable<T>, IOrderedQueryable<T>>... in my dictionary. Mostly because I would have to implement both an ...OrderBy... and ...OrderByDescending... delegate....I ended up creating an extension method for IQueryable called ...Object...

Select * from Entities where Id = (select max(Id) from Entities) in Entity Framework

I think from a simplicity point of view, this should be same result but faster as does not require two round trips through EF to sql server, you always want to execute query as few times as possible for latency, as the Id field is primary key and indexed, should be performant...using(var db = new DataContext()) { var maxEntity = db.Entities.OrderBy...

Dynamically query entities from Entity Framework for association to primary Entity

We've had an in-depth discussion about how to get the ...metadata... out of the ...DbContext.... Here are a few links to get you started. And I'll add some specific comments. ...How I can read EF DbContext metadata programmatically?...A short summary (but you should check in there for more): ...using (var db = new MyDbContext()) { var objectC...

Entity Framework 6 Batch Updates and AuditLog using Entity Framework Extended

You should enable the Auditor...var auditConfiguration = AuditConfiguration.Default; auditConfiguration.IncludeRelationships = true; auditConfiguration.LoadRelationships = true; auditConfiguration.DefaultAuditable = true; ...just add it to place where your app is initialized, Global.asax.cs for example...edited...Far as I know you can't get old val...

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

Just to complement, i've tried everything but in my case it was solved by setting the "...defaultConnectionFactory...", like this:...<entityFramework> <defaultConnectionFactory type="Oracle.ManagedDataAccess.EntityFramework.OracleConnectionFactory, Oracle.ManagedDataAccess.EntityFramework"> </defaultConnectionFactory> <providers> <provider invari...

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

You need to install the SQL Server Compact Toolbox on the new dev machine, it installs the DDEX provider for you. (You may have to go to the About screen in the Toolbox and clikc the DDEX install button, then restart VS)

Entity Framework - Updating entity with added/modified child and grandchild entities

Yes, you have to do that....When you do all the work inside a ...DbContext... scope it takes care to track al the changes happening in the entities, and you have to do nothing to let the DbContext know whathas changed....But, in multi-layered applications, when you move the entities between layers they cannot be kept inside a ...DbContext... scope,...

ADO.NET Entity Framework - Oracle with Entity Framework 6

You have to install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio. ... You can download it from ...Oracle... web site.

Entity Framework 6 vs Entity Framework Core Raw Sql

I have done the 'fromsql' off of the context directly when it is a single table, but I realize this is not what you want but it builds on it....var blogs = context.Blogs .FromSql("SELECT * FROM dbo.Blogs") .ToList(); ...However in a case like yours it is complex and a joining of multiple tables and CTEs. I would suggest you create a custom...