public async Task InsertSingleProductsEf6(int interactions, Ef6Context ef6Context) { var listCustomers = new ListTests().ObtenirListProductsAleatoire(interactions, null); ef6Context.Products.AddRange(listCustomers); await ef6Context.SaveChangesAsync(); }
public void Save(IPlayer player) { using (var context = new Ef6Context()) { context.Players.Add(player as Player); context.SaveChanges(); } }
public QueriesController( DotNetCoreContext dotNetCoreContext, Ef6Context ef6Context, CustomersWhereAddressCountryAndProductsCount customersWhereAddressCountryAndProductsCount) { _dotNetCoreContext = dotNetCoreContext; _ef6Context = ef6Context; _customersWhereAddressCountryAndProductsCount = customersWhereAddressCountryAndProductsCount; }
public SinglesInserts5() { var optionsBuilder = new DbContextOptionsBuilder <DotNetCoreContext>(); optionsBuilder.UseSqlServer(connectionStrings); _efCoreContext = new DotNetCoreContext(optionsBuilder.Options); _sqlConnection = new SqlConnection(connectionStrings); _adoServiceBenchmarkDotNet = new SinglesInsertsBenchmarkDotNet(); _ef6Context = new Ef6Context(); }
public void Delete(int id) { using (var context = new Ef6Context()) { try { var result = context.Players.Where(p => p.Identity.Id == id).SingleOrDefault(); context.Players.Remove(result); context.SaveChanges(); } catch (NullReferenceException e) { throw new ArgumentException(e.Message + $" Player with {id} was not found"); } } }
public void Update(IPlayer player) { using (var context = new Ef6Context()) { try { var oldPlayer = context.Players.Where(p => p.Id == player.Id).SingleOrDefault(); oldPlayer = (Player)player; context.Players.Add(oldPlayer); context.SaveChanges(); } catch (ArgumentException e) { throw new ArgumentException(e + " Player was not found"); } } }
public IEnumerable <IPlayer> FindAll() { var players = new List <ApiQueryPlayerResult>(); using (var context = new Ef6Context()) { players = context.Players .Include(i => i.Identity) .Include(s => s.Scores) .Select(p => new ApiQueryPlayerResult { Id = p.Id, Name = p.Identity.Name, Scores = p.Scores } ).ToList(); } return(players); }
public IPlayer FindOne(int id) { using (var context = new Ef6Context()) { try { return(context.Players.Where(p => p.Id == id) .Include(s => s.Scores) .Select(p => new ApiQueryPlayerResult { Id = p.Id, Name = p.Identity.Name, Scores = p.Scores } ) as Player); } catch (NullReferenceException e) { throw new ArgumentException(e.Message + $" Player with {id} was not found"); } } }
public Ef6Service(ConsoleHelper consoleHelper, Ef6Context ef6Context, ResultService resultService) { _consoleHelper = consoleHelper; _ef6Context = ef6Context; _resultService = resultService; }
public async Task SelectSingleProductsEf6(int take, Ef6Context ef6Context) { var rr = await ef6Context.Products.Take(take).ToListEf6Async(); }
public Querie2Controller(DotNetCoreContext dotNetCoreContext, Ef6Context ef6Context) { _dotNetCoreContext = dotNetCoreContext; _ef6Context = ef6Context; }