public void IdentityCanInsert() { using (var table = new FirebirdTestTable(Processor, null, "bogus int")) { Processor.Process(new CreateColumnExpression() { TableName = table.Name, Column = { Name = "id", IsIdentity = true, Type = DbType.Int64, IsPrimaryKey = true } }); InsertDataExpression insert = new InsertDataExpression() { TableName = table.Name }; Model.ExplicitDataDefinition item = new Model.ExplicitDataDefinition(new DataValue("BOGUS", 0)); insert.Rows.Add(item); Processor.Process(insert); using (DataSet ds = Processor.ReadTableData(String.Empty, table.Name)) { ds.Tables.Count.ShouldBe(1); ds.Tables[0].Rows.Count.ShouldBe(1); ds.Tables[0].Rows[0]["BOGUS"].ShouldBe(0); ds.Tables[0].Rows[0]["id"].ShouldBe(1); } } }
public void IdentityCanInsertMultiple() { using (var table = new FirebirdTestTable(Processor, null, "bogus int")) { Processor.Process(new CreateColumnExpression() { TableName = table.Name, Column = { Name = "id", IsIdentity = true, Type = DbType.Int64, IsPrimaryKey = true } }); InsertDataExpression insert = new InsertDataExpression() { TableName = table.Name }; Model.ExplicitDataDefinition item = new Model.ExplicitDataDefinition(new DataValue("BOGUS", 0)); insert.Rows.Add(item); //Process 5 times = insert 5 times Processor.Process(insert); Processor.Process(insert); Processor.Process(insert); Processor.Process(insert); Processor.Process(insert); using (DataSet ds = Processor.ReadTableData(String.Empty, table.Name)) { ds.Tables.Count.ShouldBe(1); ds.Tables[0].Rows.Count.ShouldBe(5); ds.Tables[0].Rows[0]["BOGUS"].ShouldBe(0); ds.Tables[0].Rows[0]["id"].ShouldBe(1); ds.Tables[0].Rows[1]["id"].ShouldBe(2); ds.Tables[0].Rows[2]["id"].ShouldBe(3); ds.Tables[0].Rows[3]["id"].ShouldBe(4); ds.Tables[0].Rows[4]["id"].ShouldBe(5); } } }