public void TestDefaultUpdate() { var instance = GetRandomPerson(); var dapper = new DapperObject <Person>(); Assert.AreEqual(dapper.Update(instance, i => i.Id), $"UPDATE PESSOA SET NAME='{instance.Name.Replace("'", "''")}', AGE={instance.Age} WHERE ID={instance.Id}"); }
public void TestInsert() { var dapper = new DapperObject <Person>(); var instance = GetRandomPerson(); var insert = dapper.Insert(instance); Assert.AreEqual(insert, $"INSERT INTO PESSOA (ID, NAME, AGE) VALUES ({instance.Id}, '{instance.Name}', {instance.Age})"); }
public void TestComplexSelect() { var dapper = new DapperObject <Person>(); var instance = GetRandomPerson(); Assert.AreEqual( dapper.Select(p => p.Age == instance.Age && p.Name == instance.Name && p.Id == instance.Id), $"SELECT * FROM PESSOA WHERE NAME='{instance.Name}' AND AGE={instance.Age} AND ID={instance.Id}"); }
public void TestDelete() { var dapper = new DapperObject <Person>(); var instance = GetRandomPerson(); var sql = dapper.Delete(new Person { Id = instance.Id }, i => i.Id); Assert.AreEqual($"DELETE FROM PESSOA WHERE ID={instance.Id}", sql); }
public void TestComplexUpdate() { var instance = GetRandomPerson(); var oldInstance = new Bogus.Faker <Person>() .RuleFor(i => i.Id, f => instance.Id) .RuleFor(i => i.Name, f => instance.Name) .RuleFor(i => i.Age, f => f.Random.Number(10, 40)) .Generate(); var dapper = new DapperObject <Person>(); var update = dapper.Update(instance, oldInstance, i => i.Id); Assert.AreEqual($"UPDATE PESSOA SET AGE={instance.Age} WHERE ID={instance.Id}", update); }
public static string GetInsertSql <T>(this T model, DapperObjectOptions options = null) { var dapperObject = new DapperObject <T>(options); return(dapperObject.Insert(model)); }
public void TestDefaultSelect() { var dapper = new DapperObject <Person>(); Assert.AreEqual(dapper.Select(), "SELECT * FROM PESSOA"); }