public DbOperation() { DbContext = new GEEDbContext(); if (DbContext == null) { throw new ArgumentNullException("Null DbContext"); } }
public MyDataAccess() { DbContext = new GEEDbContext(); if (DbContext == null) { throw new ArgumentNullException("Null DbContext"); } DbSet = DbContext.Set <T>(); }
public virtual List <T> GetDDl(string tblName, string Fname, string Code, string Cond) { using (var context = new GEEDbContext()) { //var TbName = new SqlParameter("@TbName", "Religion"); //var fname = new SqlParameter("@fname", "ReligionName"); //var code = new SqlParameter("@code", "Religion_ID"); //var cond = new SqlParameter("@cond", "ISDeleted=0"); var TbName = new SqlParameter("@TbName", tblName); var fname = new SqlParameter("@fname", Fname); var code = new SqlParameter("@code", Code); var cond = new SqlParameter("@cond", Cond); var result = context.Database .SqlQuery <T>("FillCombo @TbName, @fname, @code, @cond", TbName, fname, code, cond) .ToList(); return(result); } //using (var context = new GEEDbContext()) //{ // var TbName = new SqlParameter("@TbName", tblName); // var fname = new SqlParameter("@fname", Fname); // var code = new SqlParameter("@code", Code); // var cond = new SqlParameter("@cond", Cond); // var result = context.Database // .SqlQuery<T>("FillCombo @TbName, @fname, @code, @cond", TbName, fname, code, cond) // .ToList(); // return result; //} }