public async virtual Task <TestAllFieldTypesNullable> Create(TestAllFieldTypesNullable item)
{
this.Context.Set <TestAllFieldTypesNullable>().Add(item);
await this.Context.SaveChangesAsync();
this.Context.Entry(item).State = EntityState.Detached;
return(item);
}
public void Migrate()
{
var personItem1 = new Person();
personItem1.SetProperties(1, "A");
this.context.People.Add(personItem1);
var rowVersionCheckItem1 = new RowVersionCheck();
rowVersionCheckItem1.SetProperties(1, "A", Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"));
this.context.RowVersionChecks.Add(rowVersionCheckItem1);
var selfReferenceItem1 = new SelfReference();
selfReferenceItem1.SetProperties(1, 1, 1);
this.context.SelfReferences.Add(selfReferenceItem1);
var tableItem1 = new Table();
tableItem1.SetProperties(1, "A");
this.context.Tables.Add(tableItem1);
var testAllFieldTypeItem1 = new TestAllFieldType();
testAllFieldTypeItem1.SetProperties(1, BitConverter.GetBytes(1), true, "A", DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTimeOffset.Parse("1/1/1987 12:00:00 AM"), 1m, 1m, BitConverter.GetBytes(1), 1m, "A", "A", 1m, "A", 1m, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1m, "A", TimeSpan.Parse("0"), BitConverter.GetBytes(1), 1, Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"), BitConverter.GetBytes(1), "A", "A", 1);
this.context.TestAllFieldTypes.Add(testAllFieldTypeItem1);
var testAllFieldTypesNullableItem1 = new TestAllFieldTypesNullable();
testAllFieldTypesNullableItem1.SetProperties(1, BitConverter.GetBytes(1), true, "A", DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTimeOffset.Parse("1/1/1987 12:00:00 AM"), 1m, 1m, BitConverter.GetBytes(1), 1m, "A", "A", 1m, "A", 1m, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1m, "A", TimeSpan.Parse("0"), BitConverter.GetBytes(1), 1, Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"), BitConverter.GetBytes(1), "A", "A", 1);
this.context.TestAllFieldTypesNullables.Add(testAllFieldTypesNullableItem1);
var timestampCheckItem1 = new TimestampCheck();
timestampCheckItem1.SetProperties(1, "A", BitConverter.GetBytes(1));
this.context.TimestampChecks.Add(timestampCheckItem1);
this.context.SaveChanges();
var schemaAPersonItem1 = new SchemaAPerson();
schemaAPersonItem1.SetProperties(1, "A");
this.context.SchemaAPersons.Add(schemaAPersonItem1);
this.context.SaveChanges();
var schemaBPersonItem1 = new SchemaBPerson();
schemaBPersonItem1.SetProperties(1, "A");
this.context.SchemaBPersons.Add(schemaBPersonItem1);
var personRefItem1 = new PersonRef();
personRefItem1.SetProperties(1, 1, 1);
this.context.PersonRefs.Add(personRefItem1);
this.context.SaveChanges();
}
public virtual async Task Migrate()
{
var columnSameAsFKTableItem1 = new ColumnSameAsFKTable();
columnSameAsFKTableItem1.SetProperties(1, 1, 1);
this.Context.ColumnSameAsFKTables.Add(columnSameAsFKTableItem1);
var includedColumnTestItem1 = new IncludedColumnTest();
includedColumnTestItem1.SetProperties(1, "A", "A");
this.Context.IncludedColumnTests.Add(includedColumnTestItem1);
var personItem1 = new Person();
personItem1.SetProperties(1, "A");
this.Context.People.Add(personItem1);
var rowVersionCheckItem1 = new RowVersionCheck();
rowVersionCheckItem1.SetProperties(1, "A", Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"));
this.Context.RowVersionChecks.Add(rowVersionCheckItem1);
var selfReferenceItem1 = new SelfReference();
selfReferenceItem1.SetProperties(1, 1, 1);
this.Context.SelfReferences.Add(selfReferenceItem1);
var tableItem1 = new Table();
tableItem1.SetProperties(1, "A");
this.Context.Tables.Add(tableItem1);
var testAllFieldTypeItem1 = new TestAllFieldType();
testAllFieldTypeItem1.SetProperties(1, 1, BitConverter.GetBytes(1), true, "A", DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTimeOffset.Parse("1/1/1987 12:00:00 AM"), 1m, 1, BitConverter.GetBytes(1), 1m, "A", "A", 1m, "A", 1m, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1m, "A", TimeSpan.Parse("01:00:00"), BitConverter.GetBytes(1), 1, Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"), BitConverter.GetBytes(1), "A", "A");
this.Context.TestAllFieldTypes.Add(testAllFieldTypeItem1);
var testAllFieldTypesNullableItem1 = new TestAllFieldTypesNullable();
testAllFieldTypesNullableItem1.SetProperties(1, 1, BitConverter.GetBytes(1), true, "A", DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTime.Parse("1/1/1987 12:00:00 AM"), DateTimeOffset.Parse("1/1/1987 12:00:00 AM"), 1m, 1, BitConverter.GetBytes(1), 1m, "A", "A", 1m, "A", 1m, DateTime.Parse("1/1/1987 12:00:00 AM"), 1, 1m, "A", TimeSpan.Parse("01:00:00"), BitConverter.GetBytes(1), 1, Guid.Parse("8420cdcf-d595-ef65-66e7-dff9f98764da"), BitConverter.GetBytes(1), "A", "A");
this.Context.TestAllFieldTypesNullables.Add(testAllFieldTypesNullableItem1);
var timestampCheckItem1 = new TimestampCheck();
timestampCheckItem1.SetProperties(1, "A", BitConverter.GetBytes(1));
this.Context.TimestampChecks.Add(timestampCheckItem1);
var vPersonItem1 = new VPerson();
vPersonItem1.SetProperties(1, "A");
this.Context.VPersons.Add(vPersonItem1);
await this.Context.SaveChangesAsync();
}
public async void Create()
{
Mock <ILogger <TestAllFieldTypesNullableRepository> > loggerMoc = TestAllFieldTypesNullableRepositoryMoc.GetLoggerMoc();
ApplicationDbContext context = TestAllFieldTypesNullableRepositoryMoc.GetContext();
var repository = new TestAllFieldTypesNullableRepository(loggerMoc.Object, context);
var entity = new TestAllFieldTypesNullable();
await repository.Create(entity);
var record = await context.Set <TestAllFieldTypesNullable>().FirstOrDefaultAsync();
record.Should().NotBeNull();
}
public async virtual Task Delete(
int id)
{
TestAllFieldTypesNullable record = await this.GetById(id);
if (record == null)
{
return;
}
else
{
this.Context.Set <TestAllFieldTypesNullable>().Remove(record);
await this.Context.SaveChangesAsync();
}
}
public async virtual Task Update(TestAllFieldTypesNullable item)
{
var entity = this.Context.Set <TestAllFieldTypesNullable>().Local.FirstOrDefault(x => x.Id == item.Id);
if (entity == null)
{
this.Context.Set <TestAllFieldTypesNullable>().Attach(item);
}
else
{
this.Context.Entry(entity).CurrentValues.SetValues(item);
}
await this.Context.SaveChangesAsync();
}
public async void Create()
{
Mock <ILogger <TestAllFieldTypesNullableRepository> > loggerMoc = TestAllFieldTypesNullableRepositoryMoc.GetLoggerMoc();
ApplicationDbContext context = TestAllFieldTypesNullableRepositoryMoc.GetContext();
var repository = new TestAllFieldTypesNullableRepository(loggerMoc.Object, context);
var entity = new TestAllFieldTypesNullable();
entity.SetProperties(default(int), 2, BitConverter.GetBytes(2), true, "B", DateTime.Parse("1/1/1988 12:00:00 AM"), DateTime.Parse("1/1/1988 12:00:00 AM"), DateTime.Parse("1/1/1988 12:00:00 AM"), DateTimeOffset.Parse("1/1/1988 12:00:00 AM"), 2m, 2, BitConverter.GetBytes(2), 2m, "B", "B", 2m, "B", 2m, DateTime.Parse("1/1/1988 12:00:00 AM"), 2, 2m, "B", TimeSpan.Parse("02:00:00"), BitConverter.GetBytes(2), 2, Guid.Parse("3842cac4-b9a0-8223-0dcc-509a6f75849b"), BitConverter.GetBytes(2), "B", "B");
await repository.Create(entity);
var records = await context.Set <TestAllFieldTypesNullable>().ToListAsync();
records.Count.Should().Be(2);
}
public async void Get()
{
Mock <ILogger <TestAllFieldTypesNullableRepository> > loggerMoc = TestAllFieldTypesNullableRepositoryMoc.GetLoggerMoc();
ApplicationDbContext context = TestAllFieldTypesNullableRepositoryMoc.GetContext();
var repository = new TestAllFieldTypesNullableRepository(loggerMoc.Object, context);
TestAllFieldTypesNullable entity = new TestAllFieldTypesNullable();
context.Set <TestAllFieldTypesNullable>().Add(entity);
await context.SaveChangesAsync();
var record = await repository.Get(entity.Id);
record.Should().NotBeNull();
}
public async void Delete()
{
Mock <ILogger <TestAllFieldTypesNullableRepository> > loggerMoc = TestAllFieldTypesNullableRepositoryMoc.GetLoggerMoc();
ApplicationDbContext context = TestAllFieldTypesNullableRepositoryMoc.GetContext();
var repository = new TestAllFieldTypesNullableRepository(loggerMoc.Object, context);
TestAllFieldTypesNullable entity = new TestAllFieldTypesNullable();
context.Set <TestAllFieldTypesNullable>().Add(entity);
await context.SaveChangesAsync();
await repository.Delete(entity.Id);
TestAllFieldTypesNullable modifiedRecord = await context.Set <TestAllFieldTypesNullable>().FirstOrDefaultAsync();
modifiedRecord.Should().BeNull();
}
public async void Update_Entity_Is_Not_Tracked()
{
Mock <ILogger <TestAllFieldTypesNullableRepository> > loggerMoc = TestAllFieldTypesNullableRepositoryMoc.GetLoggerMoc();
ApplicationDbContext context = TestAllFieldTypesNullableRepositoryMoc.GetContext();
var repository = new TestAllFieldTypesNullableRepository(loggerMoc.Object, context);
TestAllFieldTypesNullable entity = new TestAllFieldTypesNullable();
context.Set <TestAllFieldTypesNullable>().Add(entity);
await context.SaveChangesAsync();
await repository.Update(new TestAllFieldTypesNullable());
var modifiedRecord = context.Set <TestAllFieldTypesNullable>().FirstOrDefaultAsync();
modifiedRecord.Should().NotBeNull();
}