Entity Framework Tutorial - Knowledge Base (KB)
1255 results for: in tag: entity-framework
In Entity Framework, why isn't lazy loading working for a one-to-zero-or-one navigation property?
Consider ...Person... and ...Address... classes defined as...class Person { public int PersonId { get; set; } public virtual Address Address { get; set; } } class Address { public int PersonId { get; set; } public virtual Person Person { get; set...
asked by Mike
Change name of Identity Column for all Entities
I am in the process of creating a domain model and would like to have a "BaseEntity" class with an "Id" property (and some other audit tracking stuff). The Id property is the primary key and each Entity in my Domain Model will inherit from the BaseEntity...
asked by lafferrs
What is the correct use of IDatabaseInitializer in EF?
I have a custom DatabaseInitialiser which is below.../// <summary> /// Implements the IDatabaseInitializer to provide a custom database initialisation for the context. /// </summary> /// <typeparam name="TContext">TContext is the DbContext</typeparam> pub...
asked by ashutosh raina
Entity Framework 6 Unable to retrive metadata
I am using EF 6 pre-3....Product model:...namespace ProductStore.Models { public class Product { [ScaffoldColumn(false)] public int Id { get; set; } [Required] public string Name { get; set; } public decimal...
asked by Alvin
EntityFramework.Extended Update not working - can't convert DynamicProxy
I am using Entity Framework 6 and tried to use EntityFramework.Extended to do some batch updates:...db.TicketOrderItems .Where(i => !i.IsDeleted && !i.Order.IsCompleted && i.Order.OrderDate < margin) .Update(i => new TicketOrderItem { IsDeleted = true...
asked by ChrFin
Multi-tenancy and connection pool using EF 6
We have developed a multi-tenant application using EF 4.3 Code First Model, where each tenant will have their own separate database. Since, we are expecting bit high number of tenants, we want to maintain the connection pool across tenants. ...In order to...
asked by Hitesh
Entity Framework and Migration with multiple schemas in a single Context
I am developing a multi-tenant application with Entity Framework Code First. Each tenant will have a different schema in the database, but the application will have a single Context and model for all tenants. ...The Entity Framwork 6 is able to use multi...
asked by Bruno Albano de Souza
Entity Framework 6 Custom Relationship Convention
I have read ...this... documentation about convention in Entity Framework 6. But it does not contain convention for Relationship. ...Suppose I have following model:...[TablePrefix("mst")] public class Guru { public int Id { get; set; } public int...
asked by Niyoko Yuliawan
Is there an planned release date for Entity Framework 6?
My question says it all, but here's some background:...Due to various constraints I'm stuck on .NET 4.0 until at least July 2014. However, I'm tasked with converting our DAL to use Entity Framework for help with scalability and performance. Currently we...
asked by Kim
How do I remove underscore of foreign key fields in code first by convention
I've got multiple classes (including TPT) in my project. Each POCO has a ...BaseClass..., which has a ...GUID... (called ...GlobalKey...) as primary key....First I used ...DataAnnotations... to create correct foreign keys. But then I've got problems synch...
asked by Andreas Geier
Connecting to SQL Server with EF6
Up to EF5, in order to connect to SQL Server 2012, all I needed to to is specify a connection string that looks something like this:...Data Source=.\SqlExpress;Initial Catalog=MyDatabase;Integrated security=True;MultipleActiveResultSets=True ...This metho...
asked by Goran
Error "Failed to set database initializer of type MyNamespace.MyCustomInitializer, MyAssembly" could not load MyContext type
I'm creating a web app using .NET4.5 with Entity Framework 6 alpha3 that uses a new SQL Compact database. The database does not yet exist....I have the following code in a web form:...public IQueryable<Job> listJobs_GetData() { var db = new Journalist...
asked by Mark Shaw
EntityFramework 6 RC1 Include on Many-to-Many property fails
I have a many-to-many relationship between Agents and AgentGroups (psuedocode, abbreviated)....public class Agent { public virtual List<AgentGroup> AgentGroups { get; set; } } public class AgentGroup { public virtual List<Agent> Agents { get; ...
asked by Celeste
How to change the naming convention of Many-to-Many table relationships?
How can I go about changing the naming convention of the auto-generated many-to-many table?...Assume I have two classes:...public class User { public int UserId { get; set; } public virtual List<Role> Roles { get; set; } } public class Role { ...
asked by Nathan A
EF6 alpha Async Await on an Entity Stored Procedure / Function Import?
I'd like to apply the new async await functionality to Stored Procedures / Function Imports imported in my Entity model, but have as yet been unable to with the EF6 alpha....Is it yet possible in EF6 alpha2 (or the nightly build as of 20211) to call any o...
asked by blueFish
Error deploying to SQL Azure using EF 6 alpha3 Code First and Migrations creating __MigrationHistory table
I'm using EF 6 alpha 3 code first. When I try to create the database on SQL Azure running the Update-Database command I get the following error:...Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered ...
asked by Bruno Moscão
BreezeJS and Entity Framework 6.0.1
I'm trying to create a Breeze Web API controller and I'm wondering if it is possible with the default MVC/Web API project template that comes with Visual Studio 2013. Updating everything through the Nuget packet manager installs Entity Framework 6.0.1. ...
asked by mdega
Unable to cast Anonymous Type from 'System.Linq.IQueryable' to 'System.Data.Entity.Core.Objects.ObjectQuery'
The following query was working well with EF5 but gives me error with EF6. I use DbContext and CodeFirst....Error raised with EF6:...Unable to cast the type 'System.Linq.IQueryable...1[[<>f__AnonymousType5...4[[System.Int32, mscorlib, Version=4.0.0.0, Cul...
asked by Dan
How can I map tables using fluent API in ASP.NET MVC 5, Entity Framework 6?
I am trying to create a one to one relationship using C# in Entity Framework 6 using ASP.NET MVC 5 with built-in user authentication....I am able to make tables and connections with the defaults that Entity Framework creates. But when I try to use fluent ...
asked by Bob
Upgrade EF 4 EDMX to EF 6
My application is using a database first EDMX in EF 4. I would like to upgrade everything to EF 6. After getting EF 6 with NuGet I had to make a lot of changes to my classes that are using my EF model, because namespaces have been changed in EF 6. Then I ...
asked by SolarX
Page 1 of 63