Restore and Backup with Entity Framework

Using the entity framework to add existing entities to a collection on a newly created entity

"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...

Entity Framework: LINQ to Entities only supports casting Entity Data Model primitive types

I wrote a method to allow for an Expression to be passed in for the orderby clause, but I ran into this problem....Unable to cast the type 'System.DateTime' to type 'System.IComparable'. LINQ to Entities only supports casting Entity Data Model primitive types....Basically the expression is this:...Expression<Func<K, IComparable>> orderBy ..

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

I have an entity set called ...Entities... which has a field ...Name... and a field ...Version.... I wish to return the object having the highest version for the selected ...Name.......SQL wise I'd go ...Select * from table where name = 'name' and version = (select max(version) from table ...

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

I am trying to build an MVC 5 Web application with Entity Framework 6 that works on Oracle Database , am trying to use ODAC 12c Release 3 which includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework 4.5.2; and ODP.NET, Managed Driver XML DB. As per ...http://www.oracle.com/technetwork/topics/dotnet/whats...

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 - restoring navigation property after detaching entities

My Entity Framework model (using EF 6.1 with ObjectContext), has lazy loading turned on, with various navigation properties....For example:...// Orders is a navigation property (collection), which, when first iterated, // loads the collection of Order entities from the DB var orders = Customer.Orders.ToList(); ...In my app, for performance reasons,...

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...