public void TestInsert()
{
ISqlCommand cmd = new CodingCat.MsSqlTeaser.SqlCommand().AppendCommand("Select TOP 100 * From tblTest ");
IDbTable DataTable = null;
using (IDbConnector DbConnector = new CodingCat.MsSqlTeaser.DbConnector(
this.ConnectionString
).Read(cmd, out DataTable))
{
if (DataTable != null)
{
DataTable.AppendRow(
DataTable.GetEmptyRow()
.AttachValue("TextField", "TestTextField")
.AttachValue("NVarcharField", "TestNVarcharField")
.AttachValue("DateTimeField", System.DateTime.Now)
);
DbConnector.Insert(DataTable);
System.Diagnostics.Debug.WriteLine(
"LatestID: {0}, Affected: {1}", DbConnector.LatestID, DbConnector.AffectedRowCount
);
}
}
}
public void TestUpdate()
{
ISqlCommand cmd = new CodingCat.MsSqlTeaser.SqlCommand()
.AppendCommand("Select TOP 100 * From tblTest ")
.AppendCommand("Where PK = @id ");
cmd.AddParameter("@id", 5);
IDbTable DataTable = null;
using (IDbConnector DbConnector = new CodingCat.MsSqlTeaser.DbConnector(
this.ConnectionString
).Read(cmd, out DataTable))
{
if (DataTable != null && DataTable.Rows.Count > 0)
{
DataTable.FirstRow
.AttachValue("TextField", "TestTextField2")
.AttachValue("NVarcharField", "TestNVarcharField2")
.AttachValue("DateTimeField", System.DateTime.Now);
DbConnector.Update(DataTable);
System.Diagnostics.Debug.WriteLine(
"LatestID: {0}, Affected: {1}", DbConnector.LatestID, DbConnector.AffectedRowCount
);
}
}
}
public void TestDelete()
{
ISqlCommand cmd = new CodingCat.MsSqlTeaser.SqlCommand()
.AppendCommand("Delete From tblTest Where PK = @id ");
cmd.AddParameter("@id", 5);
using (IDbConnector DbConnector = new CodingCat.MsSqlTeaser.DbConnector(this.ConnectionString).Delete(cmd))
System.Diagnostics.Debug.WriteLine(
"LatestID: {0}, Affected: {1}", DbConnector.LatestID, DbConnector.AffectedRowCount
);
}
public void TestRead()
{
ISqlCommand cmd = new CodingCat.MsSqlTeaser.SqlCommand().AppendCommand("Select TOP 100 * From tblTest ");
IDbTable DataTable = null;
using (new CodingCat.MsSqlTeaser.DbConnector(this.ConnectionString).Read(cmd, out DataTable))
if (DataTable != null)
{
System.Diagnostics.Debug.WriteLine("Rows: {0}", DataTable.Rows.Count);
}
}
