示例#1
0
        public async virtual Task <IncludedColumnTest> Create(IncludedColumnTest item)
        {
            this.Context.Set <IncludedColumnTest>().Add(item);
            await this.Context.SaveChangesAsync();

            this.Context.Entry(item).State = EntityState.Detached;
            return(item);
        }
示例#2
0
        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 <IncludedColumnTestRepository> > loggerMoc = IncludedColumnTestRepositoryMoc.GetLoggerMoc();
            ApplicationDbContext context = IncludedColumnTestRepositoryMoc.GetContext();
            var repository = new IncludedColumnTestRepository(loggerMoc.Object, context);

            var entity = new IncludedColumnTest();
            await repository.Create(entity);

            var record = await context.Set <IncludedColumnTest>().FirstOrDefaultAsync();

            record.Should().NotBeNull();
        }
示例#4
0
        public async void Create()
        {
            Mock <ILogger <IncludedColumnTestRepository> > loggerMoc = IncludedColumnTestRepositoryMoc.GetLoggerMoc();
            ApplicationDbContext context = IncludedColumnTestRepositoryMoc.GetContext();
            var repository = new IncludedColumnTestRepository(loggerMoc.Object, context);

            var entity = new IncludedColumnTest();

            entity.SetProperties(default(int), "B", "B");
            await repository.Create(entity);

            var records = await context.Set <IncludedColumnTest>().ToListAsync();

            records.Count.Should().Be(2);
        }
        public async void Get()
        {
            Mock <ILogger <IncludedColumnTestRepository> > loggerMoc = IncludedColumnTestRepositoryMoc.GetLoggerMoc();
            ApplicationDbContext context = IncludedColumnTestRepositoryMoc.GetContext();
            var repository = new IncludedColumnTestRepository(loggerMoc.Object, context);

            IncludedColumnTest entity = new IncludedColumnTest();

            context.Set <IncludedColumnTest>().Add(entity);
            await context.SaveChangesAsync();

            var record = await repository.Get(entity.Id);

            record.Should().NotBeNull();
        }
示例#6
0
        public async virtual Task Delete(
            int id)
        {
            IncludedColumnTest record = await this.GetById(id);

            if (record == null)
            {
                return;
            }
            else
            {
                this.Context.Set <IncludedColumnTest>().Remove(record);
                await this.Context.SaveChangesAsync();
            }
        }
示例#7
0
        public async virtual Task Update(IncludedColumnTest item)
        {
            var entity = this.Context.Set <IncludedColumnTest>().Local.FirstOrDefault(x => x.Id == item.Id);

            if (entity == null)
            {
                this.Context.Set <IncludedColumnTest>().Attach(item);
            }
            else
            {
                this.Context.Entry(entity).CurrentValues.SetValues(item);
            }

            await this.Context.SaveChangesAsync();
        }
        public async void Delete()
        {
            Mock <ILogger <IncludedColumnTestRepository> > loggerMoc = IncludedColumnTestRepositoryMoc.GetLoggerMoc();
            ApplicationDbContext context = IncludedColumnTestRepositoryMoc.GetContext();
            var repository            = new IncludedColumnTestRepository(loggerMoc.Object, context);
            IncludedColumnTest entity = new IncludedColumnTest();

            context.Set <IncludedColumnTest>().Add(entity);
            await context.SaveChangesAsync();

            await repository.Delete(entity.Id);

            IncludedColumnTest modifiedRecord = await context.Set <IncludedColumnTest>().FirstOrDefaultAsync();

            modifiedRecord.Should().BeNull();
        }
        public async void Update_Entity_Is_Not_Tracked()
        {
            Mock <ILogger <IncludedColumnTestRepository> > loggerMoc = IncludedColumnTestRepositoryMoc.GetLoggerMoc();
            ApplicationDbContext context = IncludedColumnTestRepositoryMoc.GetContext();
            var repository            = new IncludedColumnTestRepository(loggerMoc.Object, context);
            IncludedColumnTest entity = new IncludedColumnTest();

            context.Set <IncludedColumnTest>().Add(entity);
            await context.SaveChangesAsync();

            await repository.Update(new IncludedColumnTest());

            var modifiedRecord = context.Set <IncludedColumnTest>().FirstOrDefaultAsync();

            modifiedRecord.Should().NotBeNull();
        }
示例#10
0
        public async void Update_Entity_Is_Not_Tracked()
        {
            Mock <ILogger <IncludedColumnTestRepository> > loggerMoc = IncludedColumnTestRepositoryMoc.GetLoggerMoc();
            ApplicationDbContext context = IncludedColumnTestRepositoryMoc.GetContext();
            var repository            = new IncludedColumnTestRepository(loggerMoc.Object, context);
            IncludedColumnTest entity = new IncludedColumnTest();

            entity.SetProperties(default(int), "B", "B");
            context.Set <IncludedColumnTest>().Add(entity);
            await context.SaveChangesAsync();

            context.Entry(entity).State = EntityState.Detached;

            await repository.Update(entity);

            var records = await context.Set <IncludedColumnTest>().ToListAsync();

            records.Count.Should().Be(2);
        }