public void _Deletes_Typed_Record()
{
_setup.CheckSetUp();
var model = new SQLServerTable <Transaction>(_connectionStringName, _testTableName, _tablePkColumn);
var newRecord = new Transaction()
{
Amount = 100,
Comment = "I Overspent!",
Identifier = "XXX"
};
model.Insert(newRecord);
int recordPk = newRecord.TransactionId;
newRecord = model.Find <Transaction>(recordPk);
int deleted = model.Delete(newRecord.TransactionId);
newRecord = model.Find <Transaction>(recordPk);
Assert.True(deleted > 0 && newRecord == null);
}
public void _Selects_Singles_Anonymous_Record_By_PK()
{
_setup.CheckSetUp();
int qty = 100;
var newTransactions = _setup.getSkinnyTransactionSet(qty);
var model = new SQLServerTable <Transaction>(_connectionStringName, _testTableName, _tablePkColumn);
int inserted = model.BulkInsert(newTransactions);
int findRecordPk = 50;
var newRecord = model.Find <Transaction>(findRecordPk);
Assert.True(newRecord != null);
}
public void _Deletes_Anonymous_Record()
{
_setup.CheckSetUp();
var model = new SQLServerTable <Transaction>(_connectionStringName, _testTableName, _tablePkColumn);
var newRecord = new
{
Amount = 100,
Comment = "I Anonymously Overspent!",
Identifier = "YYZ" // Bah da-bah-bah-bah da bah-bah-bah-bah
};
//HACK - you can't interrogate the new record like you were doing...
var result = model.Insert(newRecord);
//WTF WHY IS THIS COMING BACK AS A DECIMAL
var recordPk = result.TransactionId;
// Retrieve the updated item from the Db:
var recordToDelete = model.Find <Transaction>(recordPk);
int deleted = model.Delete(recordToDelete.TransactionId);
recordToDelete = model.Find <Transaction>(recordPk);
Assert.True(deleted > 0 && recordToDelete == null);
}
public void _Updates_Typed_Record()
{
_setup.CheckSetUp();
var model = new SQLServerTable <Transaction>(_connectionStringName, _testTableName, _tablePkColumn);
var newRecord = new Transaction()
{
Amount = 100,
Comment = "I Overspent!",
Identifier = "XXX"
};
// Dump the new record in as an UPDATE:
model.Insert(newRecord);
int recordPk = newRecord.TransactionId;
string newValue = "I changed it!";
newRecord.Identifier = newValue;
int updated = model.Update(newRecord);
newRecord = model.Find <Transaction>(recordPk);
Assert.True(updated > 0 && newRecord.Identifier == newValue);
}
public void _Updates_Anonymous_Record()
{
_setup.CheckSetUp();
var model = new SQLServerTable <Transaction>(_connectionStringName, _testTableName, _tablePkColumn);
var newRecord = new Transaction
{
Amount = 100,
Comment = "I Anonymously Overspent!",
Identifier = "YYZ" // Bah da-bah-bah-bah da bah-bah-bah-bah da da . . .
};
var result = model.Insert(newRecord);
int recordPk = result.TransactionId;
var updateThis = new
{
Identifier = "I changed it!"
};
int updated = model.Update(updateThis, recordPk);
// Retrieve the updated item from the Db:
var updatedRecord = model.Find <Transaction>(recordPk);
Assert.True(updated > 0 && updatedRecord.Identifier == updateThis.Identifier);
}