public RepositoryBase() { try { SetDBType(ConfigurationManager.AppSettings["DBType"]); _procTool = DbFactory.Instance.GetProcTools(_dbType); _DataContext = new AppDbContext(ConfigurationManager.AppSettings["Provider"]); if (_DataContext.Database.Exists()) { var objectContext = (_DataContext as IObjectContextAdapter).ObjectContext; objectContext.CommandTimeout = 1000; _Model = _DataContext.Set <T>(); } else { _DataContext = null; } } catch (Exception e) { } }
public static IEnumerable <TResult> ExecuteStoredProcedure <TResult>(this Database database, IProcTools procTool, string procCmd, IStoredProcedure procedure) { var parameters = procTool.CreateDbParametersFromProperties(procedure); var format = procTool.CreateProcCommand <TResult>(procCmd, parameters); return(database.SqlQuery <TResult>(format, parameters.ToArray())); }