Entity Framework executesqlcommand in same transaction as savechanges

Changes to a new entity with a two-level connection are not saved by Entity Framework.

This tends to happen if your database tables have a 1 - 1 relationship with each other. In your example reportsourceset expects a reportsorttypes with whatever id it is referencing. I have run into this problem when my relationship is linking two primary keys from opposite tables together.

Entity Framework - retrieve ID before 'SaveChanges' inside a transaction

The ID is generated by the database after the row is inserted to the table. You can't ask the database what that value is going to be before the row is inserted....You have two ways around this - the easiest would be to call ...SaveChanges.... Since you are inside a transaction, you can roll back in case there's a problem after you get the ID....Th...

Exception during transactions using EF's DbContext.ExecuteSqlCommand()

Think this will help:...using (var ctx = new MyDbContext()) { // begin a transaction in EF – note: this returns a DbContextTransaction object // and will open the underlying database connection if necessary using (var dbCtxTxn = ctx.Database.BeginTransaction()) { try { // use DbContext as normal - query, ...

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

Get return value from stored procedure using ExecuteSqlCommand (using Entity Framework)

I have code that looks like this:...int retval = databaseContext.Database.ExecuteSqlCommand(command, sqlParameters.ToArray()); ...Where databaseContext is of type System.Data.Entity.DbContext...I want to use the return value to know whether or not the stored procedure ran successfuly. Based on ...the documentation...ExecuteSqlCommand... should ret...

What's the difference between Entity Framework (6) transactions with single and multiple SaveChanges() calls

If you do not start a transaction, it is implicit. Meaning, all ...SaveChanges()... you perform will be available in the database immediately after the call....If you start a transaction, ...SaveChanges()... still performs the updates, but the data is not available to other connections until a ...commit... is called....You can test this yourself b...

How to ExecuteSqlCommand in Entity Framework without it being contained in a transaction

My recommendation would be to simply not use EF for this part of your code. You can freely combine EF with straight ADO.NET code or with other ORMs such as Dapper or Chain....https://github.com/docevaad/Chain/wiki/A-Chain-comparison-to-Dapper

Get the Entity Name when calling SaveChanges in Entity Framework 6.1.3

I am trying to override the ...SaveChanges()... method in my ...DbContext... class, this because I try to get the name of the entity with a row added, deleted or updated an the respective ID of the row and the action performed....I don't know how to do this....This is with logs actions purposes....Greetings in advance.

ExecuteSqlCommand fails in Entity Framework when the command text has a DDL and DML instruction

In C#, using NpgSQL to connect on a Postgres database, I'm trying to execute an unique command that have a DDL and DML instructions, however that command not work....Sample:...var m_comandoSQL = @"DROP TABLE IF EXISTS public.test_55; CREATE TABLE public.test_55 ( ds_nome VARCHAR(50) ); SELECT * FROM public.test_55;"; var m_modelo = new Modelo(); /...

Why stored procedure out parameter is not getting read by entity framework's ExecuteSqlCommand method?

I am trying to read the OUT parameters value returned by stored procedure but it throws error ...DBNULL.... Even the procedure is returning the value....Code:... int? outParam= 0; SqlParameter sqlParam= new SqlParameter("@model", user.Name+" Model"); SqlParameter sqlParamOut = new SqlParameter("out", outParam); sqlParamOut.DbType = Syst...