public void Bug63920_Test1()
{
ReInitDb();
using (VehicleDbContext context = new VehicleDbContext())
{
context.Database.Delete();
context.Database.Initialize(true);
context.Vehicles.Add(new Car { Id = 1, Name = "Mustang", Year = 2012, CarProperty = "Car" });
context.Vehicles.Add(new Bike { Id = 101, Name = "Mountain", Year = 2011, BikeProperty = "Bike" });
context.SaveChanges();
var list = context.Vehicles.ToList();
int records = -1;
using (MySqlConnection conn = new MySqlConnection(context.Database.Connection.ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand("SELECT COUNT(*) FROM Vehicles", conn);
records = Convert.ToInt32(cmd.ExecuteScalar());
}
Assert.AreEqual(context.Vehicles.Count(), records);
}
}
public VehicleAdministrationService(VehicleDbContext context, IPropertyMappingService propertyMappingService)
{
_context = context;
_propertyMappingService = propertyMappingService;
}
public CreateModel(VehicleDbContext context, IHostingEnvironment hostingEnvironment)
{
_context = context;
_hostingEnvironment = hostingEnvironment;
}
public DeleteModel(VehicleDbContext context)
{
_context = context;
}
public VehicleManager(ILoggerFactory loggerFactory, VehicleDbContext dbContext)
{
_logger = loggerFactory.CreateLogger(typeof(VehicleManager));
_dbContext = dbContext;
}
public VehicleModelUnitOfWork(VehicleDbContext dbContext) : base(dbContext)
{
}
public EditModel(VehicleDbContext context)
{
_context = context;
}
public Repository(VehicleDbContext context)
{
this._context = context;
}
public VehiclePingRepository(VehicleDbContext context)
{
_db = context;
_dbSet = _db.Set <VehiclePing>();
}
public SearchController(VehicleDbContext context, UserManager <VehicleUser> userManager)
{
_context = context;
_userManager = userManager;
}
public VehicleService(VehicleDbContext context)
{
_context = context;
}
public EditModel(Socona.ImVehicle.Core.Data.VehicleDbContext context)
{
_context = context;
}
public CylindersController(VehicleDbContext context)
{
_context = context;
}
public static async Task SeedAsync(this VehicleDbContext context)
{
}
public CustomRolesRepository(VehicleDbContext dbContext)
{
_dbContext = dbContext;
}
public Repository(VehicleDbContext context)
{
_context = context;
_entities = context.Set <TEntity>();
}
public AppraisalRepository(VehicleDbContext vehicleDbContext) : base(vehicleDbContext)
{
}
public VehiclesController(IMapper mapper, VehicleDbContext context)
{
this.context = context;
this.mapper = mapper;
}
public CreateModel(Socona.ImVehicle.Core.Data.VehicleDbContext context, UserManager <VehicleUser> userManager)
{
_context = context;
_userManager = userManager;
}
public Repository(VehicleDbContext context)
{
_context = context;
dbSet = context.Set <T>();
}
public GenericRepository(VehicleDbContext dbContext)
{
_dbContext = dbContext;
_dbSet = _dbContext.Set <TEntity>();
}
public VehiclesController(VehicleDbContext context)
{
_context = context;
}
public VehiclesApiController(VehicleRepository repository, VehicleDbContext context)
{
_repository = repository;
_context = context;
}
public VehicleRepository(
VehicleDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public IndexModel(VehicleDbContext dbContext, IAuthorizationService authorizationService, ITownService townService)
{
_dbContext = dbContext;
_authorizationService = authorizationService;
_townService = townService;
}
public VehicleModelService(VehicleDbContext _context, IMapper _mapper)
{
context = _context;
mapper = _mapper;
}
public DetailsModel(VehicleDbContext context)
{
_context = context;
}
public VehicleModelRespository(VehicleDbContext dbContext, IMapper mapper) : base(dbContext)
{
this.mapper = mapper;
}
public VehicleRepository(VehicleDbContext vehicleDbContext) : base(vehicleDbContext)
{
}
public MakesController(VehicleDbContext context, IMapper mapper)
{
this.mapper = mapper;
this.context = context;
}
public void IdentityTest()
{
using (VehicleDbContext context = new VehicleDbContext())
{
if (context.Database.Exists()) context.Database.Delete();
context.Database.CreateIfNotExists();
// Identity as Guid
Manufacturer nissan = new Manufacturer
{
Name = "Nissan"
};
Manufacturer ford = new Manufacturer
{
Name = "Ford"
};
context.Manufacturers.Add(nissan);
context.Manufacturers.Add(ford);
// Identity as Integer
Distributor dis1 = new Distributor
{
Name = "Distributor1"
};
Distributor dis2 = new Distributor
{
Name = "Distributor2"
};
context.Distributors.Add(dis1);
context.Distributors.Add(dis2);
context.SaveChanges();
using (MySqlConnection conn = new MySqlConnection(context.Database.Connection.ConnectionString))
{
conn.Open();
// Validates Guid
MySqlCommand cmd = new MySqlCommand("SELECT * FROM Manufacturers", conn);
MySqlDataReader dr = cmd.ExecuteReader();
if (!dr.HasRows)
Assert.Fail("No records found");
while (dr.Read())
{
string name = dr.GetString(1);
switch (name)
{
case "Nissan":
Assert.AreEqual(dr.GetGuid(0), nissan.ManufacturerId);
Assert.AreEqual(dr.GetGuid(2), nissan.GroupIdentifier);
break;
case "Ford":
Assert.AreEqual(dr.GetGuid(0), ford.ManufacturerId);
Assert.AreEqual(dr.GetGuid(2), ford.GroupIdentifier);
break;
default:
Assert.Fail();
break;
}
}
dr.Close();
// Validates Integer
cmd = new MySqlCommand("SELECT * FROM Distributors", conn);
dr = cmd.ExecuteReader();
if (!dr.HasRows)
Assert.Fail("No records found");
while (dr.Read())
{
string name = dr.GetString(1);
switch (name)
{
case "Distributor1":
Assert.AreEqual(dr.GetInt32(0), dis1.DistributorId);
break;
case "Distributor2":
Assert.AreEqual(dr.GetInt32(0), dis2.DistributorId);
break;
default:
Assert.Fail();
break;
}
}
dr.Close();
}
}
}
public IndexModel(VehicleDbContext context)
{
_context = context;
}
