Is transaction scope available in Entity framework 6.0

Updating models from database in Entity Framework 6.0

I'm developing a Web API Service (in Visual Studio 2013), and I've added, in my solution, ADO.NET Entity Data Model (Database First)....All the tables I've included, are correctly created in my edmx diagram....Then I've made some changes: I've added two new columns in the source database, and I've removed one column. So, when I try to update model ...

Entity Framework 6.0 in MVC 5 project not working

My current setup:...VS1013-Solution...MvcProject (MVC5)...FrameworkProject (ClassLibrary) - BaseController, BaseViewModel, ets....EntitiesProject (ClassLibrary) - The edmx only as .cs file...EntitiesProjectIO (ClassLibrary) - InBetweenLayer to fetch get/set data in the underlying database...I added references to 'EntitiesProjectIO' to my 'MvcProjec...

create non clustered index on primary key entity framework 6.0

I am aware of ...this..., which states that it is not possible to create a primary key with non clustered index via code first. Is this still the case?...Ideally, I would like to specify via EntityTypeConfiguration, that my primary key (Guid) has a non-clustered index and there is another column (int) with a clustered index.

Entity Framework 6, Transaction Scope, Context and SaveChanges

Question pertains to transaction scope and ...context.SaveChanges().... If I'm processing a million records with a ...foreach..., and I save after every, let's say, 1000 records by calling ...context.SaveChanges()... inside a transaction scope and something fails after 10 000 have been processed and ...SaveChanges()... called, will already saved da...

Entity Framework 6.0 Raw Sql to View Model

Firstly i am using EF v6.0. I have this function below;...public List<UserProgressViewModel> GetUserProgresses(int userId) { return Context.Database.SqlQuery<UserProgressViewModel>( "SELECT Puzzles.Name AS PuzzleName, UserProgresses.Minute, " + "UserProgresses.Session FROM UserProgresses " + "INNER JOIN Puzzles ON Puzzles.Id = UserProgr...

DbContext global scope vs method level scope

If there is a class which works as a data access layer, and provides the functionality of CRUD operations for entities, Which version is the best practice when considering performance & Multi threaded environment (i.e methods of this class are called by multiple threads simultaneously . .). . ....Version 1:...DbContext created at class level, share...

Upgrading .net entity framework to EF Core seems that base and OnModelCreating are not available

I have been upgrading from .net 4.6 application to .net core 2.1.x and some of these objects and methods are just not available....Examples: ...Issues with ...:base("name=mydbentities")...OnModelCreating(DbModelBuilder modelBuilder)...base:(nameOrConnectionString)...From the old .net code base are 2 partial classes...public partial class OpsCentra...

Why am I getting duplicate ID columns when using Table Per Hierarchy in Entity Framework Core?

I am trying to use "table per hierarchy" to model a variety of account types in my database using EF Core (2.1) and I am having a problem where I am getting additional foreign key columns added for the derived types. I have seen ...this... question/answer but I don't think it is the same as my situation....Here are my account classes:...public abst...

Dotnet Core 3.1 Entity Framework - Issues with entity.SetTableName not currently available

Unfortunately I have found myself doing a full ground up rebuild with my code as the solution was taking 5 minutes to build. I decided to take the opportunity to move to dotnet core 3.1....However, I have found that the option ....SetTableName... is not available as part of "entity"....I am using it as part of setting shadow properties in the DbCon...

Using Entity Framework Core 3.1 with UseInMemoryDatabase option in ServiceProvider ( Scoped lifetime )

I have migrated a web application project from .NET Core 2.1 to 3.1 (also EF Core from 2.1.1 to 3.1.0)....After the migration, some unit tests are not working anymore, throwing duplicate keys db exception. ...I simulated the problem and realize that EF core with option ...UseInMemoryDatabase... is behaving differently in 3.1, it does not clean up t...