public IEnumerable <T> Select <T>() where T : class
{
var sql = new SqlSelectQuery <T>();
sql = sql.Select((o) => o);
var strSql = sql.ToString();
return(null);
}
public IEnumerable <T> Select <T>(Expression <Func <T, object> > columns, Expression <Func <T, bool> > where = null) where T : class
{
var sql = new SqlSelectQuery <T>();
sql = sql.Select(columns)
.Where(where);
var strSql = (sql as ISqlQuery).ToString();
return(null);
}
public IEnumerable <T> Select <T>(string columns, string from, string where = null, string groupBy = null, string having = null, string orderBy = null, int pageIndex = 1, int pageSize = 40) where T : class
{
int rowsOffet = (pageIndex - 1) * pageSize;
var sql = new SqlSelectQuery <string>();
sql = sql.Select(columns, from)
.Where(where)
.GroupBy(groupBy)
.Having(having)
.OrderBy(orderBy)
.Skip(rowsOffet)
.Take(pageSize);
var strSql = (sql as ISqlQuery).ToString();
return(null);
}
public IEnumerable <T> Select <T>(Expression <Func <T, object> > columns, Expression <Func <T, bool> > where = null, Expression <Func <T, object> > groupBy = null, Expression <Func <T, object> > having = null, Expression <Func <T, object> > orderBy = null, int pageIndex = 1, int pageSize = 40) where T : class
{
int rowsOffet = (pageIndex - 1) * pageSize;
var sql = new SqlSelectQuery <T>();
sql = sql.Select(columns)
.Where(where)
.GroupBy(groupBy)
.Having(having)
.OrderBy(orderBy)
.Skip(rowsOffet)
.Take(pageSize);
var strSql = (sql as ISqlQuery).ToString();
return(null);
}
public T Select <T>(Expression <Func <T, object> > columns, object id) where T : class
{
var entityDef = GetEntityDefintion(typeof(T));
var pkAttributeName = entityDef.Attributes.FirstOrDefault(o => o.IsPrimaryKey == true)?.Name;
if (pkAttributeName == null)
{
pkAttributeName = entityDef.Attributes.First().Name;
}
var sql = new SqlSelectQuery <T>();
sql = sql.Select(columns)
.Where($"{pkAttributeName} == '{id.ToString()}'");
var strSql = (sql as ISqlQuery).ToString();
return(null);
}