public static DbCommand LoadSqlQuery(this CustumDbContext context, string sql)
{
var cmd = context.Database.GetDbConnection().CreateCommand();
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
return(cmd);
}
public static DbCommand LoadStoredProcedure(this CustumDbContext context, string storedProcName)
{
var cmd = context.Database.GetDbConnection().CreateCommand();
cmd.CommandText = storedProcName;
cmd.CommandType = CommandType.StoredProcedure;
return(cmd);
}
public async Task <(int, ContentInfoModel)> SelectRandomContentInfoItem(CustumDbContext dbContext, int type)
{
ContentDataManager data = new ContentDataManager(dbContext);
ContentInfo info = await data.SelectRandomContentInfoItem(type);
if (info == null)
{
return(50002, null);
}
ContentInfoModel result = ContentInfoEntityMapModel.Map(info);
if (result == null)
{
return(50003, null);
}
return(0, result);
}
public HomeController(ILogger <HomeController> logger, CustumDbContext context)
{
_logger = logger;
_dbContext = context;
}
public ContentDataManager(CustumDbContext context) : base(context)
{
}
protected BaseDataManager(CustumDbContext dbContext)
{
_dbContext = dbContext;
}
