public virtual IEnumerable <T> Find(Expression <Func <T, bool> > predicate) { IEnumerable <T> items = null; // extract the dynamic sql query and parameters from predicate QueryResult result = DynamicQuery.GetDynamicQuery(_tableName, predicate); using (IDbConnection cn = Connection) { cn.Open(); var x = (object)result.Param; SqlParameter param = new SqlParameter(); param.ParameterName = "@Login"; param.Value = "ads"; items = cn.Query <T>(result.Sql, (object)result.Param); } return(items); }
public static T Insert <T>(this IDbConnection cnn, string tableName, dynamic param) { IEnumerable <T> result = SqlMapper.Query <T>(cnn, DynamicQuery.GetInsertQuery(tableName, param), param); return(result.First()); }
public static void Update(this IDbConnection cnn, string tableName, dynamic param) { SqlMapper.Execute(cnn, DynamicQuery.GetUpdateQuery(tableName, param), param); }