public YourEntity Update(string userName, YourEntity entity)
{
// Check user has rights to edit the entity (if necessary)
if (this.CanUpdate(userName, entity.ID))
{
// Gets actual entity from DB
var yourDbEntity = this.GetByID(entity.ID);
// Updates each property manually
yourDbEntity.Field1 = entity.Field1;
public string CreateTruckCategory(TruckAndCategory model)
{
try
{
using (var db = new YourEntity())
{
//extract the truck model
Truck truck = new Truck
{
//assign variables example
Title = model.Truck.Title;
};
//save truck data to db
db.Truck.Add(truck);
db.SaveChanges();
//keep track of the truck id if it is auto increment
var truckId = truck.TruckId;
//also in the same way extract and save the category model keeping track of the ID,
var categoryId = category.Id;
//the save the link table with both IDs
TruckCategory truckCategory = new TruckCategory
{
CategoryId = categoryId;
TruckId = truckId;
};
//then save this link table
db.TruckCategory.Add(truckCategory);
db.SaveChanges();
}
return("success");
}
catch (Exception e)
{
return("failure");
}
}
partial void InsertYourEntity(YourEntity entity)
{
using (DbCommand cmd = this.Connection.CreateCommand())
{
