public void Insert_value_success()
{
var query = Prepare.SqlQuery();
var result = query.Execute("insert into author (name, description) values (@name, @description)", SqlHelper.Parameters.Get("@name", "Isaac"), SqlHelper.Parameters.Get("@description", "sci-fi"));
Assert.True(result);
}
public void GetFirst_not_null_value_match()
{
var query = Prepare.SqlQuery();
var result = query.GetFirst <AuthorObj>("select Id, name from author where Id > 5");
Assert.NotNull(result);
Assert.Equal(6, result.Id);
}
public void GetList_not_null_count()
{
var query = Prepare.SqlQuery();
var result = query.GetList <AuthorObj>("select Id, name from author where Id >= 3 and Id <= 12");
Assert.NotNull(result);
Assert.Equal(10, result.Count);
}
