protected override void Run(IDbConnection db) { if (this.IsFirstRun) { db.CreateTable <SampleOrderLine>(true); } db.Insert(SampleOrderLine.Create(userId, this.Iteration, 1)); }
protected override void Run(IDbConnection db) { if (this.IsFirstRun) { db.CreateTable <SampleOrderLine>(true); 20.Times(i => db.Insert(SampleOrderLine.Create(userId, i, 1))); } var rows = db.Select <SampleOrderLine>(); }
protected override void Run(IDbCommand dbCmd) { if (this.IsFirstRun) { dbCmd.CreateTable <SampleOrderLine>(true); dbCmd.Insert(SampleOrderLine.Create(userId, this.Iteration, 1)); } var row = dbCmd.Select <SampleOrderLine>(); }
public void Can_insert_and_select_from_OrderLineData() { using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open()) { db.CreateTable <SampleOrderLine>(true); var orderIds = new[] { 1, 2, 3, 4, 5 }.ToList(); orderIds.ForEach(x => db.Insert( SampleOrderLine.Create(Guid.NewGuid(), x, 1))); var rows = db.Select <SampleOrderLine>(); Assert.That(rows, Has.Count.EqualTo(orderIds.Count)); } }
public void Can_insert_and_select_from_OrderLineData() { using (var dbConn = ConnectionString.OpenDbConnection()) using (var dbCmd = dbConn.CreateCommand()) { dbCmd.CreateTable <SampleOrderLine>(true); var orderIds = new[] { 1, 2, 3, 4, 5 }.ToList(); orderIds.ForEach(x => dbCmd.Insert( SampleOrderLine.Create(Guid.NewGuid(), x, 1))); var rows = dbCmd.Select <SampleOrderLine>(); Assert.That(rows, Has.Count.EqualTo(orderIds.Count)); } }