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