Database DBHelper = new Database("Sqlconnection");
1:查询一个对象,如果不存在就返回null
public object SearchByNameAndPwd(string name,string password)
{
Sql sql = Sql.Builder;
sql.Select(" top 1 * ")
.From(" book_Admin ")
.Where(" AdminName=@0 and AdminPassword=@1",name,password);
var obj = DBHelper.FirstOrDefault<BookAdmin>(sql);
return obj;
}
2:查询一个表的全部数据
public List<BookAdmin> GetAllModelList()
{
Sql sql = Sql.Builder;
sql.Select(" * ")
.From(" book_Admin");
var obj= DBHelper.Query<BookAdmin>(sql);
return obj.ToList();
}