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