private static void InsertAutoIncrementColumnTest()
{
var db = CreateDatabase();
var x = db.ExecuteCommand("Delete from IdentityTable");
OutputTestResult("Query: Delete IdentityTable", true);
Int32 pk = 0;
for (int i = 0; i < 3; i++)
{
var sp = new identitytableInsert();
sp.NVarCharColumn = "NVarChar";
var x1 = sp.ExecuteNonQuery();
pk = sp.IntColumn;
OutputTestResult("IdentityTable.Insert", x1 == 1);
}
var t = new identitytable();
var r = t.SelectByPrimaryKey(pk);
r.NVarCharColumn = "New NVarChar2";
var x2 = t.Update(r);
OutputTestResult("IdentityTable.Update", x2 == 1);
var x3 = t.Delete(r);
OutputTestResult("IdentityTable.Delete", x3 == 1);
}
public identitytableInsert CreateInsertStoredProcedure(Record record)
{
var sp = new identitytableInsert();
if (record == null)
{
return(sp);
}
sp.IntColumn = record.IntColumn;
sp.TimestampColumn = record.TimestampColumn;
sp.NVarCharColumn = record.NVarCharColumn;
return(sp);
}
public identitytableInsert CreateInsertStoredProcedure(Record record)
{
var sp = new identitytableInsert();
((IDatabaseContext)sp).TransactionKey = this.TransactionKey;
if (record == null)
{
return(sp);
}
sp.IntColumn = record.IntColumn;
sp.TimestampColumn = record.TimestampColumn;
sp.NVarCharColumn = record.NVarCharColumn;
return(sp);
}