public async void InitLocalMySQL() { if (this.Database.CreateIfNotExists()) { //Setup base datas to load EntityGeneratorFakerTyper <User> generatorUser = new EntityGeneratorFakerTyper <User>(); List <User> users = generatorUser.GenerateListItems() as List <User>; EntityGeneratorFakerTyper <Address> generatorAddress = new EntityGeneratorFakerTyper <Address>(); foreach (var item in users) { item.Addresses = generatorAddress.GenerateListItems() as List <Address>; } MySQLManager <User> managerClass1 = new MySQLManager <User>(DataConnectionResource.LOCALMYSQL); await managerClass1.Insert(users); } }
public async void InitLocalSQL() { if (this.Database.CreateIfNotExists()) { #region Users EntityGeneratorFakerTyper <User> generatorUser = new EntityGeneratorFakerTyper <User>(); List <User> users = generatorUser.GenerateListItems(100, 5, 4) as List <User>; EntityGeneratorFakerTyper <Address> generatorAddress = new EntityGeneratorFakerTyper <Address>(); List <Address> addresses = generatorAddress.GenerateListItems(100, 5) as List <Address>; EntityGeneratorFakerTyper <Country> generatorCountry = new EntityGeneratorFakerTyper <Country>(); List <Country> countries = generatorCountry.GenerateListItems(1, 1) as List <Country>; SQLManager <User> managerUser = new SQLManager <User>(DataConnectionResource.LOCALMSSQLSERVER); await managerUser.Insert(users); SQLManager <Address> managerAddress = new SQLManager <Address>(DataConnectionResource.LOCALMSSQLSERVER); await managerAddress.Insert(addresses); SQLManager <Country> managerCountry = new SQLManager <Country>(DataConnectionResource.LOCALMSSQLSERVER); await managerCountry.Insert(countries); #region Links List <UsersToAddresses> usersToAddresses = new List <UsersToAddresses>(); for (int i = 0; i < 10; i++) { UsersToAddresses temp = new UsersToAddresses(); temp.UserId = Faker.RandomNumber.Next(0, users.Count); temp.AddressId = Faker.RandomNumber.Next(0, addresses.Count); usersToAddresses.Add(temp); } SQLManager <UsersToAddresses> managerUsersToAddresses = new SQLManager <UsersToAddresses>(DataConnectionResource.LOCALMSSQLSERVER); await managerUsersToAddresses.Insert(usersToAddresses); #endregion #endregion } }