public void Setup() { var options = new DbContextOptionsBuilder <MyFinanceContext>() .UseInMemoryDatabase(databaseName: "MyFinanceDb") .Options; _myFinanceDbContext = new MyFinanceContext(options); _expenseRepository = new ExpenseRepository(_myFinanceDbContext); Seed(_myFinanceDbContext); }
static void Main(string[] args) { MyFinanceContext ctx = new MyFinanceContext(); //Product p1 = new Product { Name = "Tomate",Description="Rouge",Quantity=2}; //ctx.Products.Add(p1); Category c1 = new Category { Name = "Ahmeed" }; // ctx.Categories.Add(c1); // ctx.SaveChanges(); Console.WriteLine("Base crée"); Console.ReadKey(); //Console du Gestionnaire de package //generer a l'aide de Commande Enable-Migrations //Pour Ajouter Migration : Add-Migration nom-migration //exemple Add-Migration Adress // Update DataBase update DataBase selon la derniére Migration //Update DataBase TargetMigration ServiceCategory sc = new ServiceCategory(); sc.addCategory(c1); sc.Commit(); Console.WriteLine("Category Ajouter"); Console.ReadKey(); ServiceProduct sp = new ServiceProduct(); Product p1 = new Product(); p1.Name = "Delice"; p1.Quantity = 1; p1.price = 1250; p1.Category = c1; sp.AddProduct(p1); sc.Commit(); Console.WriteLine("Produit Ajouter"); Console.ReadKey(); }
private void Seed(MyFinanceContext context) { var jsonTestDataFileName = "TestData.json"; var absolutePathForDocs = Path.Combine(AppDomain.CurrentDomain.BaseDirectory + jsonTestDataFileName); var json = File.ReadAllText(absolutePathForDocs); var jObject = JObject.Parse(json); var expenses = jObject["expenses"]?.ToObject <IEnumerable <Expense> >(); foreach (var expense in expenses) { context.Expenses.Add(expense); } context.SaveChanges(); foreach (var entity in context.ChangeTracker.Entries()) { entity.State = EntityState.Detached; } }
public UnitOfWork(IDataBaseFactory dbfac) { this.dbfac = dbfac; context = dbfac.DBcontext; }
public MyFinanceContext Get() { return(dataContext ?? (dataContext = new MyFinanceContext())); }
public ProductService() { ctx = new MyFinanceContext(); }
public DataBaseFactory() { this.context = new MyFinanceContext(); }
public ProviderRepository() { ctx = new MyFinanceContext(); }
public UnitOfWork(IDatabaseFactory dbFactory) { this.dbFactory = dbFactory; dataContext = dbFactory.DataContext; }
public ServiceProduct() { ctx = new MyFinanceContext(); }
public ProductRepository() { ctx = new MyFinanceContext(); }
public ProviderService() { ctx = new MyFinanceContext(); }
public UserService() { ctx = new MyFinanceContext(); }
public CategoryRepository() { ctx = new MyFinanceContext(); }
public RepositoryBase(MyFinanceContext ctx) { this._ctx = ctx; dbset = ctx.Set <T>(); }
public CategoryService() { ctx = new MyFinanceContext(); }
public DatabaseFactory() { dataContext = new MyFinanceContext(); }
public BookService() { ctx = new MyFinanceContext(); }