public static List <TSelectModel> Select2Model <TSelectModel>(IProvider provider, string sql) where TSelectModel : class, new() { List <TSelectModel> ResultList = new List <TSelectModel>(); LinqConextClass context = new LinqConextClass(provider); try { context.Open(); DataContext dataContext = context.Context; IEnumerable collections = dataContext.ExecuteQuery((new TSelectModel()).GetType(), sql); foreach (var item in collections) { TSelectModel temp = item as TSelectModel; ResultList.Add(temp); } } catch (Exception exp) { throw exp; } finally { context.Close(); } return(ResultList); }
protected List <T> ConextRun(string sql) { List <T> ResultList = new List <T>(); LinqConextClass context = new LinqConextClass(this.Provider); try { context.Open(); DataContext dataContext = context.Context; IEnumerable collections = dataContext.ExecuteQuery((new T()).GetType(), sql); foreach (var item in collections) { T temp = item as T; ResultList.Add(temp); } } catch (Exception exp) { throw exp; } finally { context.Close(); } return(ResultList); }
protected int ContextExec(string sql) { LinqConextClass context = new LinqConextClass(this.Provider); try { context.Open(); DataContext dataContext = context.Context; int x = dataContext.ExecuteCommand(sql); return(x); } catch (Exception exp) { return(-1); throw exp; } finally { context.Close(); } return(-1); }