public void StartUp()
{
using (ShipmentContext context = new ShipmentContext())
{
context.Database.CreateIfNotExists();
}
}
public static void Init(IServiceProvider serviceProvider)
{
using (var context = new ShipmentContext(
serviceProvider.GetRequiredService <
DbContextOptions <ShipmentContext> >()))
{
context.Database.EnsureCreated();
AddMockData(context);
}
}
private List <object> WalkObject(Object Input, ShipmentContext context, SqlCeResultSet resultSet)
{
bool firstOccurrence;
gen.GetId(Input, out firstOccurrence);
if (!firstOccurrence)
{
return(null);
}
CachedTableInfo metadata = new CachedTableInfo(Input.GetType().Name, context, resultSet);
List <string> processedFields = new List <string>();
List <object> keys = new List <object>();
SqlCeUpdatableRecord r = resultSet.CreateRecord();
// Match the database with memory object.
for (int i = 0; i < resultSet.FieldCount; i++)
{
if (!metadata.IsFieldKey(r.GetName(i)))
{
string fieldName = resultSet.GetName(i);
PropertyInfo fi = Input.GetType().GetProperty(fieldName);
if (fi != null)
{
r[i] = fi.GetValue(Input, null);
processedFields.Add(fieldName);
}
else
{
throw new InvalidOperationException(string.Format("Field {0} was not found in the class {1}",
fi.Name, Input.GetType().Name));
}
}
}
resultSet.Insert(r, DbInsertOptions.PositionOnInsertedRow);
foreach (var item in metadata.Keys)
{
keys.Add(r[item.Name]);
}
// keys now contain assigned autoincrement fields.
return(keys);
}
public static void AddMockData(ShipmentContext context)
{
if (context.Shipments.Any())
{
return; // DB has been seeded.
}
var shipment = new Shipment()
{
Orders = GenerateOrders(),
DeliveryDate = DateTime.Now.AddDays(20),
Departure = "Abisko",
Destination = "Greenland",
ShipmentDate = DateTime.Now,
};
context.Shipments.Add(shipment);
var shipment2 = new Shipment()
{
Orders = GenerateOrders(),
DeliveryDate = DateTime.Now.AddDays(20),
Departure = "Bremen",
Destination = "New York",
ShipmentDate = DateTime.Now,
};
context.Shipments.Add(shipment2);
var shipment3 = new Shipment()
{
Orders = GenerateOrders(),
DeliveryDate = DateTime.Now.AddDays(5),
Departure = "Copenhagen",
Destination = "London",
ShipmentDate = DateTime.Now,
};
context.Shipments.Add(shipment3);
context.SaveChanges();
}
public void Walk_Simple_Object()
{
Shipment shipment = GetTestShipment();
using (SqlCeConnection conn = new SqlCeConnection(@"Data Source=c:\temp\shipments.sdf"))
using (ShipmentContext c = new ShipmentContext())
{
conn.Open();
using (SqlCeCommand cmd = new SqlCeCommand("Shipments", conn))
{
cmd.CommandType = System.Data.CommandType.TableDirect;
using (SqlCeResultSet rs = cmd.ExecuteResultSet(ResultSetOptions.Scrollable | ResultSetOptions.Updatable))
{
List <object> keys = WalkObject(shipment, c, rs);
}
}
c.Shipments.Any(t => t.Description == "test shipment").Should().Be(true);
}
}
public UnitOfWork(ShipmentContext shipmentContext)
{
this._shipmentContext = shipmentContext;
}
public AddressesController(ShipmentContext context)
{
_context = context;
}
public DetailsController(ShipmentContext context)
{
_context = context;
}
public ShipmentService(ShipmentContext dbContext)
{
_dbContext = dbContext;
}
public ContainersController(ShipmentContext context)
{
_context = context;
}
public RoutesController(ShipmentContext context)
{
_context = context;
}
public DriverRepository(ShipmentContext shipmentContext) : base(shipmentContext)
{
}
public ShipmentsController(ShipmentContext context)
{
_context = context;
}
public CachedTableInfo(string Table, ShipmentContext context, SqlCeResultSet data)
{
_table = Table;
_context = context;
_data = data;
}
public BaseRepository(ShipmentContext _shipmentContext)
{
shipmentContext = _shipmentContext;
this.dbSet = shipmentContext.Set <T>();
}
public MessagesController(ShipmentContext context)
{
_context = context;
}
