Entity Framework Core - Knowledge Base (KB)
6642 results
Does System.Data.Sqlite support Entity Framework 6?
I looked around, and it was not clear if you could use it in EF6. I've found a compatible version on a blog (...here...) but I'd rather use the official one if possible. Is it compatible or not? ...Thanks!
asked by It'sNotALie.
How can I configure Entity Framework to automatically trim values retrieved for specific columns mapped to char(N) fields?
I'm working with a third-party database in which all text values are stored as ...char(n).... Some of these text values are primary keys, whereas others are just normal human-readable text. For the latter, I want retrieved values to be automatically trimm...
asked by Sam
How can set a default value constraint with Entity Framework 6 Code First?
In a legacy app, most string properties can't be null and need to have a default value of string.empty....I know it's possible to do this with migrations, but I'm looking for a way to do this using the fluent configuration interface:... protected overr...
asked by ECC-Dan
WPF and EF6 mark model entity as having chnages
Background:... I have a wpf 4.5 application that is built with MVVM (MVVM-Light) and Enitity Framework 6 db first. ...I have several viewmodels that have a list/details set up with a list of objects in a listbox and a details grid that displays and allow...
asked by J King
How to integrate ASP.NET Identity tables in an existing database
Using Asp.net 4.5 and VS 2013, I would like to know how to integrate Asp.Net Identity Tables with an existing database....So basically I would like to have db tables for Identity and my own tables in the same db....I know Asp.Net Identity use Code First a...
asked by GibboK
EF6 executing a long running stored procedure gets timeout errors
I recently upgraded my project from EF5 to EF6. In this project I have an Azure Worker Role that runs periodically, and kicks off a stored procedure on SQL Azure that updates a bunch of database information, and takes on average 1.5 hours to execute. When...
asked by CodeGrue
How to avoid Lazy Loading when accessing foreign key ID property through navigation property?
I'm in the process of converting a project from NHibernate to Entity Framework 6....Given this simple model: ...public class User { public int ID { get; set; } public string FullName { get; set; } public virtual Organization Organization { get...
asked by ECC-Dan
Issue loading child entity of a parent entity. Unidirectional mapping and 1 to 0..1 relationship with a Shared primary Key?
When I try to load child entity of parent entity it loads with default values. If i try to load explicitly it throws exception ...Multiplicity constraint violated.... The role 'Association_Customer_Target' of the relationship 'CodeFirstNamespace.Associati...
asked by Mady
EF6 Code First : Entity with multiple relationships
I am creating a new database using EF code-first which contain the following classes: ...Address, Contact, Account, Customer (a sub-class of Account), and SalesOrder. ...The Address class is the one giving me problems at the moment, it can have no foreig...
asked by David Grogan
Code-first: Mapping entities to existing database tables
I am using Entity Framework 6 code-first with an existing database, but having problems mapping my entities to the database tables....Normally, I would use database-first approach and have my entity and context code generated, but using the designer has b...
asked by Dave New
Can calling ToList on a DbSet cause caching?
I was using the following code to repopulate an ...ObservableCollection<T>... on change notification from a ...SqlDependency...:...var set = _dbContext.Set<T>().ToList(); this.AddRange(set); ...In this scenario, the ...OnChange... event fires correctly, b...
asked by ProfK
Dynamic MySQL database connection for Entity Framework 6
I wish to pass a dynamic connection string to the entity framework context. I have over 150 schemas which are identical (one per account) and I would like to select the connection as such:...ApplicationDbContext db = new ApplicationDbContext("dbName"); ..
asked by francisco.preller
What is the difference between IdentityDbContext and IdentityDbContext<ApplicationUser> in MVC5
On what basis should one decide to use ...IdentityDbContext... versus ...IdentityDbContext<ApplicationUser>... in an ASP.NET MVC5 application?...What benefits do we get by using ...IdentityDbContext<ApplicationUser>... instead of the non-generic ...Identi...
asked by Sandeep Kumar
Configure multiple database Entity Framework 6
In my solution I have 2 projects that use Entity Framework 6. Each points to a different database, both using the same data provide - SQL Server. A third project in my solution needs to use both databases. My problem is how to configure those context. I t...
asked by Motty
EF6 and multiple configurations (SQL Server and SQL Server Compact)
Update:... Problem solved, see end of this question....The problem...:...We are trying to use Entity Framework 6 and code-based configuration in a scenario were we have use both a SQL Server and SQL Server CE in the same ...AppDomain.......This quite simp...
asked by Henrik Carlsson
Code First Mapping to Database Views
I have been asked to map the ASP.NET Identity classes to existing database Views for read operations, using Stored Procedures for CRUD. There are a number of StackOverflow Questions stating that ...is possible to map to views..., also ...this question...,...
asked by pwdst
Entity framework 6 connecting multiple database implemention advice
I am a novice when it comes to entity framework.I usually use ado.net because is faster than any ORM and the repetitive code can be easily generated....Now I have decided to give EF6 a go again and gain some experience in EF...Scenario....Need to migrate ...
asked by user9969
How to register a custom EF Code First migration operation for scaffolding?
I have ...class SetIdentitySeedOperation: MigrationOperation..., which sets the identity value for the specified table. To wire it up, I use a custom ...SqlServerMigrationSqlGenerator..., so if I manually write ....AddOperation(new SetIdentitySeedOperatio...
asked by chase
IsRowVersion can only be configured for Byte array properties
I recently upgraded from EntityFramework 5 to 6 via the NuGet updater. Everything seemed to go well and I built and executed my application. When I tried to retrieve the first entity from the database, I received this error:...The property 'UpdatedDate' i...
asked by Sparafusile
EntityDeploySplit error - Microsoft.Data.Entity.Build.Tasks.dll missing
After a clean Windows reformat and installing Visual Studio 2013, trying to build a project with database-first Entity Framework edmx files yields the following error:...The "EntityDeploySplit" task could not be loaded from the assembly C:\Program Files...
asked by Brandon Linton
Page 5 of 333