EFConcurrencyModeTest

EFConcurrencyModeTest helps you write unit tests (for e.g. NUnit) that test whether optimistic concurrency for Entity Framework is enabled in your EDMX files.

When using Entity Framework, the ConcurrencyMode attribute for properties mapped to rowversion (a.k.a. timestamp) database columns, should be set to ConcurrencyMode.Fixed, to enable optimistic concurrency.

Unfortunately, due to a bug in the Entity Framework tools, you have to do this manually. EFConcurrencyModeTest helps you write the tests needed to make sure that you have done so.

PM> Install-Package EFConcurrencyModeTest

F# Example

This example shows how a simple NUnit test using EFConcurrencyModeTest looks in F#:

 1: 
 2: 
 3: 
 4: 
 5: 
 6: 
 7: 
 8: 
 9: 
10: 
11: 

open EFConcurrencyModeTest
open NUnit.Framework
open System.Reflection

type TestDbConcurrencyMode () =
    [<Test>]
    static member ConcurrencyModes () =
        let cmt = ConcurrencyModeTester()
        let asm = Assembly.GetAssembly(typeof<MyDatabaseEntitiesType>)
        let result = cmt.BadConcurrencyModes(asm, "MyEdmxFileNameWithoutExtension")
        Assert.IsEmpty(result, cmt.FormatBadConcurrencyModes result)

C# Example

This example shows the same NUnit test in C#:

using EFConcurrencyModeTest;
using NUnit.Framework;
using System.Reflection;

public class TestDbConcurrencyMode
{
    [Test]
    static void ConcurrencyModes()
    {
        var cmt = new ConcurrencyModeTester();
        var asm = Assembly.GetAssembly(typeof(MyDatabaseEntitiesType));
        var result = cmt.BadConcurrencyModes(asm, "MyEdmxFileNameWithoutExtension");
        Assert.IsEmpty(result, cmt.FormatBadConcurrencyModes(result));
    }
}

Documentation

The above examples show just about all you have to know about the usage of EFConcurrencyModeTest. There are a few additional variants of the BadConcurrencyModes function which are documented in the API Reference.

Fixing faulty concurrency modes

Bad concurrency modes can be fixed automatically by the FixEFConcurrencyModes utility. See this blog post for usage examples.

Copyright

The library is available under Public Domain license, which allows modification and redistribution for both commercial and non-commercial purposes. For more information see the License file in the GitHub repository.

• EFConcurrencyModeTest
• Home page
• Get Library via NuGet
• Source Code on GitHub
• License
• Release Notes
• Documentation
• API Reference