Entity Framework Core - Knowledge Base (KB)
6642 results
Does anyone have a very complete example generic repository for EF 6.1?
I have my own repository that is as follows. However this does not take into account some of the new features such as the range features. Does anyone have a repository that includes everything. I have searched for this on the net but there's nothing that...
asked by Samantha J T Star
Deleting child objects with EF6
I'm new to EF6, its a side project for me and I'm struggling to see how to delete / modify child rows. I'd normally hand crank this stuff but I'm investigation increasing productivity....I have the following providing JSON to my knockout model....public J...
asked by RubbleFord
Entity Framework child objects not populating
I have a simple model which when I run the website in the debugger the entity framework does not correctly populate the model....The model is simple:...public class Team { /// <summary> /// Constructor required for the EntityFramework to creat...
asked by Sam Holder
Error: No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'
I recently upgraded/updated Entity Framework in an old project from version 4 or 5 to version 6. Now I get this exception:...An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code...Addit...
asked by Leon Cullens
LINQ in Entity Framework 6 with large .Any()
I have a EF6 query that takes a list of ...IDs... and does a query:...public IList<Audit> AuditsByIDs(List<int> ids) { return _db.Audits .Include(p => p.User) .Where(p => ids.Any(i => i == p.Id)).ToList(); } ...It works for a ...small ...
asked by Ian Vink
Storing a complex detached object graph in EF6
I have the current scenario:...I'm using EF6 Code first, and have created a data-model something like this:...public class MainObject{ ..some properties IList<SubObject> SubObjects{get;set;} } public class SubObject{ ..some properties IList<SubSu...
asked by Øyvind Bråthen
What happens to my DbContext after I run a stored procedure that modifies my entities?
Scenario...: I have a custom ...DbContext.... I am using the ...StoreConnection... property of the underlying ...ObjectContext... to run a stored procedure that modifies several entities (which have a ...DbSet... in my custom ...DbContext...). My DbConte...
asked by Adam Modlin
Entity Framework will only set related entity property to "null" if I first get the property
Edit... This seems to occur for ...any... Entity property that references another entity in one direction. In other words, for the below example, the fact that ...Bar... overrides Equality appears to be irrelevant....Suppose I have the following classes:...
asked by Nathan
Error in installing EntityframeworkwithheirarchyId6.0.2
Hi I have a problem in installing entityframeworkwithheirarchyId how can I fix it. I installed and reinstalled few time but its not work.... Exception calling "LoadFrom" with "1" argument(s): "Could not load file or assembly ...
asked by user3269915
Why does Entity Framework 6.x not cache results?
Perhaps I am misunderstanding the caching that ...DbContext... and ...DbSet... does but I was under the impression that there was some caching that would go on. I'm seeing behavior that I wouldn't expect when I run the following code:...var ctx = CreateAC...
asked by Adam Modlin
Support for Table Valued Functions in EF6 Code First?
Is it possible to call a TVF in EF6 Code First? ...I started a new project using EF6 Database first and EF was able to import a TVF into the model and call it just fine. ...But updating the model became very time consuming and problematic with the large r...
asked by Patrick
Foreign Key Lookup Dropdownlist EF 6
I have been googling for 3 days, and can't find a usable answer, I'm hoping someone can help me....I'm starting with this EXCELLENT tutorial:...http://www.asp.net/web-forms/tutorials/data-access/model-binding/retrieving-data...I'm trying to extend this pr...
asked by user3311566
Generate ntext/nvarchar column when using Entity Framework Code First and a DBMigration
I'd like to either using the Fluent API or data annotations be able to automatically generate a database migration class for a string column as an ...ntext... rather than a fixed length string. How would I do that?...When using Entity Framework v6, with C...
asked by WiredPrairie
Set identity to the previous created column during migration
I have a project with the CodeFirst database (Entity Framework 6) and two migration steps. Database is updated automatically by using this code in Application_Start in Global.asax:...Database.SetInitializer( new MigrateDatabaseToLatestVersion<My...
asked by Starina
EF6 (code first), MVC, Unity, and a service layer without a repository
My application is using SQL Server 2012, EF6, MVC and Web API. ...It's also using a repository and assorted files such as:...DatabaseFactory.cs Disposable.cs IDatabaseFactory.cs IRepository.cs IUnitOfWork.cs RepositoryBase.cs UnitOfWork.cs ...We already u...
asked by Samantha J T Star
Using the Unity IOC to inject dbcontext into my controllers and service layer?
How can I inject my dbcontext into the service layer with the Unity IOC. In particular I want to be sure that I only have the one dbcontext and I want to ensure this is destroyed at the right time even if I am using async....My application uses EF6 and a ...
asked by Samantha J T Star
Upgrade from Entity Framework 5 to 6
After upgrading our project from using Entity Framework 5 to Entity Framework 6 (though NuGets update function) i get the following error on my generated Entities class:...Error 1 The type or namespace name 'Objects' does not exist in the namespace 'Sy...
asked by RossBille
Stored procedure working when calling exec sp and throws with EF6 on SQL Azure
I have this stored procedure...CREATE PROCEDURE [dbo].[sp_RebuildIndexes] AS BEGIN DECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FOR (SELECT '[' + IST.TABLE_SCHEMA + '].[' + IST.table_name + ']' AS [TableName] FROM INFORMATION_SCHE...
asked by JuChom
Entity Framework 6 Code First Trigger
I'm using Entity Framework 6 Code First, and would like to create a Trigger....How do I do this?...The reason I need the trigger is because a user may either edit the database directly or through a program I'm writing, and I need to make sure 2 columns in...
asked by Charles W
How to edit previously applied migration without adding another migration in EF code first
I have an applied migration using "haward" db schema....public partial class CreateCourseCategoryTable : DbMigration { public override void Up() { CreateTable( "haward.CourseCategories", c =>...
asked by Jaime Sangcap
Page 9 of 333