unit testing with effort for entity framework 6 with computed values

Question

Using effort EF6 with code first does not populate computed values. I have a datetime field (FechaCreacion) that is computed. How can I emulate it in Effort, so It is populated with DateTime.Now after savingChanges() ?

This post Using Effort (EF Testing Tool) with Computed Column is DB First instead of Code First as my example, but seems unanswered too.

EffortConnection connection = (EffortConnection)DbConnectionFactory.CreateTransient();

using (var c = new ControlConfigContext(connection))
{
    c.Database.CreateIfNotExists();

    CambioRepositoryTestLoadData.Load(c);

    string direccionMac = "FFFF";
    var repo = new CambioRepository(c);
    var primerConcesionarioTerminal = repo.GetPrimerConcesionarioTerminal(direccionMac);


    Assert.AreEqual("terminal1", primerConcesionarioTerminal.Terminal);
}

This value is computed in SQLServer as GetDate()

this.Property(t => t.FechaCreacion).HasColumnName("FechaCreacion").HasDatabaseGeneratedOption(DatabaseGeneratedOption.Computed);

In sql server works well, but when using Effort in unit testing, the field gets empty date value.

score 0 · Answer 1 · answered Jan 16 '17 at 11:50

0

This would seem like an issue with Effort. I have opened an issue on their github site: https://github.com/tamasflamich/effort/issues/62

answered Jan 16 '17 at 11:50

Robert Jørgensgaard Engdahl

3,234
22
34

score 0 · Answer 2 · edited Mar 10 '19 at 15:50

0

This issue is fixed with the latest update.

You have to set the global EntityFrameworkEffortManager.UseDefaultForNotNullable flag as true.

edited Mar 10 '19 at 15:50

tomerpacific

4,704
13
34
52

answered Mar 10 '19 at 14:55

garo cm

61
5

unit testing with effort for entity framework 6 with computed values

2 Answers2