public List <Category> SelectAll() { using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString())) { return(cn.Query <Category>("CategorySelectAll", commandType: CommandType.StoredProcedure).ToList()); } }
public List <SubcategoryView> GetByViewCategoryId(int categoryId) { using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString())) { DynamicParameters p = new DynamicParameters(); p.Add("@CategoryID", categoryId); return(cn.Query <SubcategoryView>("SubcategoryViewByCategory", p, commandType: CommandType.StoredProcedure).ToList()); } }
public void Delete(int CategoryId) { using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString())) { DynamicParameters p = new DynamicParameters(); p.Add("@CategoryID", CategoryId); cn.Execute("CategoryDelete", p, commandType: CommandType.StoredProcedure); } }
public void Insert(string CategoryName) { using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString())) { DynamicParameters p = new DynamicParameters(); p.Add("@CategoryName", CategoryName); cn.Execute("CategoryInsert", p, commandType: CommandType.StoredProcedure); } }
public Category Select(int categoryId) { using (SqlConnection cn = new SqlConnection(DatabaseSettings.GetConnectionString())) { DynamicParameters p = new DynamicParameters(); p.Add("@CategoryID", categoryId); return(cn.Query <Category>("CategorySelect", p, commandType: CommandType.StoredProcedure).FirstOrDefault()); } }
public static DbContextOptionsBuilder <AppDbContext> UseOsDependentDbProvider( this DbContextOptionsBuilder <AppDbContext> builder, DatabaseSettings dbSettings) { if (builder == null) { throw new ArgumentNullException(nameof(builder)); } if (dbSettings == null) { throw new ArgumentNullException(nameof(dbSettings)); } var conStr = dbSettings.GetConnectionString(); return(dbSettings.ShouldUseSqlServer() ? builder.UseSqlServer(conStr, opts => opts.MigrationsAssembly(DB_MIGRATIONS_ASSEMBLY_NAME)) : builder.UseSqlite(conStr, opts => opts.MigrationsAssembly(DB_MIGRATIONS_ASSEMBLY_NAME))); }