Firebird 2.5 + EF6, how to set transaction to wait

MVC 3 : The MSDTC transaction manager was unable to pull the transaction from the source

I am using MVC 3 with Entities, now I have used the below line of codes from my controller... using (var scope = new TransactionScope()) { _myRepository.DeleteFM1(id); _myRepository.DeleteFM2(id, name); scope.Complete(); } ...and inside my ...DeleteFM2... method which happens to be my metho...

SQLite EF6 programmatically set connection string at runtime

I try to migrate form EF 3.5 to 6 (with SQLite as database). We can not set the connection string in the app config file (this works without problems with ef6). We have to set connection string programmatically at runtime (after user has selected the SQLite file)....Here is our app.config...<?xml version="1.0" encoding="utf-8"?> <configuration> <...

How to set a Property unique in EF6 code first

I have this class: ...public class BSC { public int BSCId { get; set; } public string BSCName { get; set; } } ...and the config class: ...public class BSCConfig :EntityTypeConfiguration<BSC> { public BSCConfig() { Property(m => m.BSCName).HasMaxLength(50).HasColumnName("Category").IsRequired(); } } ...I want to make th...

Set EF6 Code First strings fluently to nvarchar(max)

I'm building an EF6 code first model using the fluent API. My understanding is, by default, strings will be ...nvarchar(max)..., which (to be blunt) is dumb for a default. So I added the following convention code to set max default length to 255 characters:...modelBuilder.Properties<string>() .Configure(p => p.HasMaxLength(255)); ...Then I crea...

Nested Transaction Behavior in EF6

I'm currently using TransactionScope to manage transactions in my data layer, but I've been running into issues with nested transactions and async whereby the connection seems to close during the nested transaction or the transaction is promoted to MSDTC. I've not found the exact problem but after reading around it looks like this scenario isn't ..

New embedded Firebird, code first, EF6 project results in SerializationException

I'm trying to set up Firebird with EF6 as an embedded server for a simple app I'm writing but haven't been able to get it to work. I have a CLI project which is the app and the DAL project which is the DB. I added the NuGet packages to both and created a DbContext with a simple entity, and created an initial migration successfully, but when trying ...

EF6 Nested Transactions

I have a command service class, which utilises the unit of work pattern, with various methods to update a database (SQL Azure, in this case) via entity framework....The command service gets instantiated with a reference to an instance of a dbcontext, whose lifetime is managed by my DI framework of choice....Some of the command service class' method...

Firebird .NET Provider 5.0.0 and EF6

I have been trying to create Entity Data Model of Firebird database, but i can't get past this error: ...I have installed:...DDEX provider 3.0.2.0 ...Firebird .NET Provider 5.0.0.0 (tried both installing it with .msi from Firebird's official site and manually adding refrence to project and installing it from NuGet)...EntityFramework.Firebird(from...

Running stored procedure in a SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

I setup a ...DbContext... where I have this code:...base.Database.ExecuteSqlCommand("SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;"); ...in the context constructor. I execute a stored procedure like this:...return base.Database.ExecuteSqlCommand("EXEC mystoredprocedure"); ...but I'm getting a deadlock because this executes in a read committed c...

How to delay transaction open in EF6?

We use ASP.Net MVC + Autofac + EF6. DbContext is wrapped by UnitOfWork. We create it for each http request via Autofac. We also open transaction for whole http request in UnitOfWork constructor....The problem is that not all http requests have to be wrapped in to the transaction. Some of them even don't have requests to DB....We'd like to delay tra...