public void Can_execute_update_using_expression()
{
using (var con = OpenDbConnection())
{
con.CreateTable<SimpleType>(true);
var obj = new SimpleType { Name = "Somename" };
con.Save(obj);
var storedObj = con.SingleById<SimpleType>(con.LastInsertId());
Assert.AreEqual(obj.Name, storedObj.Name);
obj.Id = storedObj.Id;
obj.Name = "Someothername";
con.Update(obj, q => q.Id == storedObj.Id);
var target = con.SingleById<SimpleType>(storedObj.Id);
Assert.AreEqual(obj.Name, target.Name);
}
}
public void Can_GetLastInsertedId_using_InsertParam()
{
var testObject = new SimpleType { Name = "test" };
//verify that "normal" Insert works as expected
using (var con = OpenDbConnection())
{
con.CreateTable<SimpleType>(true);
con.Save(testObject);
Assert.That(testObject.Id, Is.GreaterThan(0), "normal Insert");
}
//test with InsertParam
using (var con = OpenDbConnection())
{
con.CreateTable<SimpleType>(true);
var lastInsertId = con.Insert(testObject, selectIdentity:true);
Assert.That(lastInsertId, Is.GreaterThan(0), "with InsertParam");
}
}
public void Can_GetLastInsertedId_using_InsertParam()
{
var testObject = new SimpleType { Name = "test" };
//verify that "normal" Insert works as expected
using(var con = ConnectionString.OpenDbConnection()) {
con.CreateTable<SimpleType>(true);
con.Insert(testObject);
var normalLastInsertedId = con.GetLastInsertId();
Assert.Greater(normalLastInsertedId, 0, "normal Insert");
}
//test with InsertParam
using(var con = ConnectionString.OpenDbConnection()) {
con.CreateTable<SimpleType>(true);
con.InsertParam(testObject);
var insertParamLastInsertedId = con.GetLastInsertId();
Assert.Greater(insertParamLastInsertedId, 0, "with InsertParam");
}
}
public void Can_execute_update_only()
{
using (var con = OpenDbConnection())
{
con.CreateTable<SimpleType>(true);
var obj = new SimpleType { Name = "Somename" };
con.Save(obj);
var storedObj = con.SingleById<SimpleType>(con.LastInsertId());
Assert.AreEqual(obj.Name, storedObj.Name);
var ev = OrmLiteConfig.DialectProvider.SqlExpression<SimpleType>();
ev.Update();
ev.Where(q => q.Id == storedObj.Id);
storedObj.Name = "Someothername";
con.UpdateOnly(storedObj, ev);
var target = con.SingleById<SimpleType>(storedObj.Id);
Assert.AreEqual("Someothername", target.Name);
}
}