public static SimGroup GetSimGroup(
int simGroupId,
string contextName = DefaultContextName
)
{
SimGroup simGroup = null;
using (var db = new ArcheanContext(contextName))
{
simGroup = db.SimGroups.Where(sg => sg.SimGroupId == simGroupId)
.FirstOrDefault();
}
return(simGroup);
}
public static void RemoveSimGroup(
int simGroupId,
string contextName = DefaultContextName
)
{
SimGroup simGroup = new SimGroup()
{
SimGroupId = simGroupId
};
using (var db = new ArcheanContext(contextName))
{
db.SimGroups.Attach(simGroup);
db.SimGroups.Remove(simGroup);
db.SaveChanges();
}
}
public static void NoCnxn()
{
try
{
using (ArcheanContext context = new ArcheanContext())
{
// Interception/SQL logging
context.Database.Log = (string message) => { Debug.WriteLine(message); };
context.Sims.Add(new Sim {
SimType = "Honda", Description = "Fit", SimParams = "2009"
});
context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public static SimGroup SaveSimGroup(
string simGroupType,
string description,
string simgroupParams,
string contextName = DefaultContextName
)
{
SimGroup simGroup = null;
using (var db = new ArcheanContext(contextName))
{
simGroup = new SimGroup
{
SimGroupType = simGroupType,
Description = description,
SimGroupParams = simgroupParams
};
db.SimGroups.Add(simGroup);
db.SaveChanges();
}
return(simGroup);
}