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); }