public static void AddAlarmZone(ZoneGuardConfigContext context, AlarmZoneDAL alarmZone, AlarmZoneThingDAL[] alarmZoneThings)
{
context.AlarmZone.Add(alarmZone);
context.SaveChanges();
foreach (AlarmZoneThingDAL sensor in alarmZoneThings)
{
sensor.AlarmZone = alarmZone;
context.AlarmZoneThing.Add(sensor);
}
context.SaveChanges();
}
public static ConfigAlarmZone CreateConfigAlarmZoneFromDAL(AlarmZoneDAL zone)
{
Dictionary <string, string> parameters = new Dictionary <string, string>();
ConfigAlarmZone alarmZoneConfig = null;
//foreach (ThingParameterDAL tpc in thing.Parameters)
{
parameters[ConfigCore.PARAMETER_NAME] = zone.Name;
parameters[ConfigCore.PARAMETER_CONFIG_CLASS] = "ConfigAlarmZone";
//parameters[PARAMETER_THING_CLASS] = zone.Name;
}
//string configClassName = parameters[PARAMETER_CONFIG_CLASS];
//Type cls = Assembly.GetExecutingAssembly().GetType("HomeManager2.Shared.Config." + configClassName);
alarmZoneConfig = new ConfigAlarmZone(parameters);
return(alarmZoneConfig);
}
private AlarmZoneDAL AddAlarmZone(ZoneGuardConfigContext context, String name, String description, String[] sensors)
{
AlarmZoneDAL alarmZone = null;
List <AlarmZoneThingDAL> alarmZoneSensors = new List <AlarmZoneThingDAL>();
DateTime timestamp = DateTime.UtcNow;
alarmZone = new AlarmZoneDAL {
Name = name, Description = description, Enabled = 1, Timestamp = timestamp
};
foreach (String sensorName in sensors)
{
ThingDAL curSensor = context.Thing.Where <ThingDAL>(n => n.ThingType == ThingType.Sensor).Where <ThingDAL>(n => n.Name == sensorName).FirstOrDefault <ThingDAL>();
alarmZoneSensors.Add(new AlarmZoneThingDAL {
Enabled = 1, Thing = curSensor, Timestamp = timestamp
});
}
;
DbInitializer.AddAlarmZone(context, alarmZone, alarmZoneSensors.ToArray());
return(alarmZone);
}
private void originalloadTestConfigData()
{
ZoneGuardConfigContextFactory factory = new ZoneGuardConfigContextFactory();
Guid serverNodeGuid = new Guid("5c7a6580-45fc-4402-9ebe-07de9884f5b0");
using (ZoneGuardConfigContext context = factory.CreateDbContext())
{
/*
* NodeDAL node = null;
*
* if (!context.Node.Any())
* {
* node = new NodeDAL { UniqueIdentifier = serverNodeGuid, Name = "Server" };
* context.Node.Add(node);
*
* context.SaveChanges();
* }
* else
* {
* node = context.Node.Where<NodeDAL>(n => n.UniqueIdentifier == serverNodeGuid).FirstOrDefault<NodeDAL>();
* }
*
*/
// Look for any students.
SensorDAL thing = null;
if (!context.Thing.Any())
{
// ThingParameterDAL paramCategory = new ThingParameterDAL { Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow };
// ThingParameterDAL paramConfigClass = new ThingParameterDAL { Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow };
// ThingParameterDAL paramThingClass= new ThingParameterDAL { Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow };
List <SensorDAL> sensorsPerimeter = new List <SensorDAL>();
//List<String> sensorsPerimeter = new List<String>();
List <SensorDAL> sensorsHighRisk = new List <SensorDAL>();
String topicOffset = "test/";
SensorParameterDAL[] thingParameters;
thing = new SensorDAL {
Name = "OfficeWindow1", Description = "Window in Office", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
sensorsHighRisk.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "OfficeWindow1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "officewindow1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
*
* Sensor 2
*
* ************/
thing = new SensorDAL {
Name = "LivingroomWindow1", Description = "First Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "LivingroomWindow1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "livingroomwindow1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
thing = AddThing(context, "LivingroomWindow2", "Second Window in Livingroom", ThingType.Sensor, new Dictionary <string, string> {
{ "category", "sensor" },
{ "config_class", "ConfigSensor" },
{ "thing_class", "SensorMQTT" },
{ "name", "LivingroomWindow2" },
{ "topic", topicOffset + "livingroomwindow2/state" }
});
sensorsPerimeter.Add(thing);
/*
* thing = new ThingDAL { Name = "LivingroomWindow2", Description = "Second Window in Livingroom", ThingType = ThingType.Sensor, Timestamp = DateTime.UtcNow };
* sensorsPerimeter.Add(thing);
* thingParameters = new ThingParameterDAL[]
* {
* new ThingParameterDAL{Name="category", Value="sensor", Timestamp=DateTime.UtcNow},
* new ThingParameterDAL{Name="config_class", Value="ConfigSensor", Timestamp=DateTime.UtcNow },
* new ThingParameterDAL{Name="thing_class", Value="SensorMQTT", Timestamp=DateTime.UtcNow },
* new ThingParameterDAL{Name="name", Value = "LivingroomWindow2", Timestamp=DateTime.UtcNow },
* new ThingParameterDAL{Name="topic", Value = topicOffset + "livingroomwindow2/state", Timestamp=DateTime.UtcNow }
* };
* DbInitializer.AddThing(context, thing, thingParameters);
*/
thing = new SensorDAL {
Name = "LivingroomWindow3", Description = "Third Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "LivingroomWindow3", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "livingroomwindow3/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
*
* LivingroomDoor1
*
* ************/
thing = new SensorDAL {
Name = "LivingroomDoor1", Description = "Terracedoor in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
sensorsHighRisk.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "LivingroomDoor1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "livingroomdoor1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
*
* FrederikWindow1
*
* ************/
thing = new SensorDAL {
Name = "FrederikWindow1", Description = "Window (Frederik)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "FrederikWindow1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "frederikwindow1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
* CecilieWindow1
* ************/
thing = new SensorDAL {
Name = "CecilieWindow1", Description = "Window (Cecilie)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
sensorsHighRisk.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "CecilieWindow1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "ceciliewindow1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
* SofieWindow1
* ************/
thing = new SensorDAL {
Name = "SofieWindow1", Description = "Window (Sofie)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
sensorsHighRisk.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "SofieWindow1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "sofiewindow1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
* BedroomWindow1
* ************/
thing = new SensorDAL {
Name = "BedroomWindow1", Description = "Window (Bedroom)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
sensorsHighRisk.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "BedroomWindow1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "bedroomwindow1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
* BackentranceWindow1
* ************/
thing = new SensorDAL {
Name = "BackentranceWindow1", Description = "Window (Backentrance)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
sensorsHighRisk.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "BackentranceWindow1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "backentrancewindow1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
* BackentranceDoor1
* ************/
thing = new SensorDAL {
Name = "BackentranceDoor1", Description = "Door (Backentrance)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
sensorsHighRisk.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "BackentranceDoor1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "backentrancedoor1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
* BathroomWindow1
* ************/
thing = new SensorDAL {
Name = "BathroomWindow1", Description = "Window (Bathroom)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "BathroomWindow1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "bathroomwindow1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
/* ***********
* EntranceDoor1
* ************/
thing = new SensorDAL {
Name = "EntranceDoor1", Description = "Window (Entrancedoor)", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensorsPerimeter.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "category", Value = "sensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "config_class", Value = "ConfigSensor", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "thing_class", Value = "SensorMQTT", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "name", Value = "EntranceDoor1", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "frontentrancedoor1/state", Timestamp = DateTime.UtcNow
}
};
DbInitializer.AddThing(context, thing, thingParameters);
AlarmZoneDAL alarmZonePerimeter = new AlarmZoneDAL {
Name = "Perimeter", Description = "", Enabled = 1, Timestamp = DateTime.UtcNow
};
List <AlarmZoneThingDAL> alarmZoneSensors = new List <AlarmZoneThingDAL>();
foreach (SensorDAL sensor in sensorsPerimeter)
{
alarmZoneSensors.Add(new AlarmZoneThingDAL {
Enabled = 1, Thing = sensor, Timestamp = DateTime.UtcNow
});
}
;
DbInitializer.AddAlarmZone(context, alarmZonePerimeter, alarmZoneSensors.ToArray());
AlarmZoneDAL alarmZoneHighRisk = new AlarmZoneDAL {
Name = "High Risk", Description = "", Enabled = 1, Timestamp = DateTime.UtcNow
};
alarmZoneSensors = new List <AlarmZoneThingDAL>();
foreach (SensorDAL sensor in sensorsHighRisk)
{
alarmZoneSensors.Add(new AlarmZoneThingDAL {
Enabled = 1, Thing = sensor, Timestamp = DateTime.UtcNow
});
}
;
DbInitializer.AddAlarmZone(context, alarmZoneHighRisk, alarmZoneSensors.ToArray());
}
}
}
private void InitializeConfigData_NA(ZoneGuardConfigContext context)
{
SensorDAL thing = null;
if (!context.Sensor.Any())
{
List <SensorDAL> sensors = new List <SensorDAL>();
String topicOffset = "test/";
SensorParameterDAL[] thingParameters;
thing = new SensorDAL {
Name = "OfficeWindow1", Description = "Window in Office", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensors.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "topic", Value = "test/officewindows1/state", Timestamp = DateTime.UtcNow
}
//new ConfigThingParameter{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow}
};
AddThing(context, thing, thingParameters);
/* ***********
*
* Sensor 2
*
* ************/
thing = new SensorDAL {
Name = "LivingroomWindow1", Description = "First Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensors.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "livingroomwindows1/state", Timestamp = DateTime.UtcNow
},
new SensorParameterDAL {
Name = "a_value", Value = "Some value", Timestamp = DateTime.UtcNow
}
//new ConfigThingParameter{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow}
};
AddThing(context, thing, thingParameters);
thing = new SensorDAL {
Name = "Livingroom2", Description = "Second Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensors.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "livingroomwindows2/state", Timestamp = DateTime.UtcNow
}
//new ConfigThingParameter{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow}
};
AddThing(context, thing, thingParameters);
thing = new SensorDAL {
Name = "Livingroom3", Description = "Third Window in Livingroom", ThingType = ThingType.Sensor /*, Node = node*/, Timestamp = DateTime.UtcNow
};
sensors.Add(thing);
thingParameters = new SensorParameterDAL[]
{
new SensorParameterDAL {
Name = "topic", Value = topicOffset + "livingroomwindows3/state", Timestamp = DateTime.UtcNow
}
//new ConfigThingParameter{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow}
};
AddThing(context, thing, thingParameters);
AlarmZoneDAL alarmZone = null;
alarmZone = new AlarmZoneDAL {
Name = "Perimeter", Description = "", Enabled = 1, Timestamp = DateTime.UtcNow
};
List <AlarmZoneThingDAL> alarmZoneSensors = new List <AlarmZoneThingDAL>();
foreach (SensorDAL sensor in sensors)
{
alarmZoneSensors.Add(new AlarmZoneThingDAL {
Enabled = 1, Thing = sensor, Timestamp = DateTime.UtcNow
});
}
;
AddAlarmZone(context, alarmZone, alarmZoneSensors.ToArray());
}
SensorStateLogDAL ssl = null;
thing = context.Thing.Where(s => s.Id == 2).First <SensorDAL>();
ssl = new SensorStateLogDAL {
Triggered = 1, Sensor = thing, CreatedTimestamp = DateTime.UtcNow.AddHours(-1)
};
AddSensorStateLog(context, ssl);
ssl = new SensorStateLogDAL {
Triggered = 0, Sensor = thing, CreatedTimestamp = DateTime.UtcNow.AddHours(-1).AddMinutes(1)
};
AddSensorStateLog(context, ssl);
return; // DB has been seeded
//}
/*
*
* DETTE VIRKER
* var things = new ConfigThing[]
* {
* new ConfigThing{Name="Sensor 1", ThingType=ThingType.Sensor, Timestamp=DateTime.UtcNow},
* new ConfigThing{Name="Sensor 2", ThingType=ThingType.Sensor, Timestamp=DateTime.UtcNow},
* new ConfigThing{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow}
* };
* foreach (ConfigThing s in things)
* {
* context.Thing.Add(s);
* context.SaveChanges();
* int id = s.ID;
* Console.WriteLine("Id is {0}", id);
* }
* context.SaveChanges();
* IEnumerable<ConfigThing> things1 = context.Thing.AsEnumerable<ConfigThing>();
* int count = things.Count<ConfigThing>();
*/
/*
* var things = new ConfigThingParameter[]
* {
* new ConfigThingParameter{ThingId=1, Name="Topic", Key="test/officewindow1/state", Timestamp=DateTime.UtcNow},
* new ConfigThing{Name="Sensor 2", ThingType=ThingType.Sensor, Timestamp=DateTime.UtcNow},
* new ConfigThing{Name="Action 1", ThingType=ThingType.Action, Timestamp=DateTime.UtcNow}
* };Ø/
*
* /*
*
* var courses = new Course[]
* {
* new Course{CourseID=1050,Title="Chemistry",Credits=3},
* new Course{CourseID=4022,Title="Microeconomics",Credits=3},
* new Course{CourseID=4041,Title="Macroeconomics",Credits=3},
* new Course{CourseID=1045,Title="Calculus",Credits=4},
* new Course{CourseID=3141,Title="Trigonometry",Credits=4},
* new Course{CourseID=2021,Title="Composition",Credits=3},
* new Course{CourseID=2042,Title="Literature",Credits=4}
* };
* foreach (Course c in courses)
* {
* context.Course.Add(c);
* }
* context.SaveChanges();
*
* var enrollments = new Enrollment[]
* {
* new Enrollment{StudentID=1,CourseID=1050,Grade=Grade.A},
* new Enrollment{StudentID=1,CourseID=4022,Grade=Grade.C},
* new Enrollment{StudentID=1,CourseID=4041,Grade=Grade.B},
* new Enrollment{StudentID=2,CourseID=1045,Grade=Grade.B},
* new Enrollment{StudentID=2,CourseID=3141,Grade=Grade.F},
* new Enrollment{StudentID=2,CourseID=2021,Grade=Grade.F},
* new Enrollment{StudentID=3,CourseID=1050},
* new Enrollment{StudentID=4,CourseID=1050},
* new Enrollment{StudentID=4,CourseID=4022,Grade=Grade.F},
* new Enrollment{StudentID=5,CourseID=4041,Grade=Grade.C},
* new Enrollment{StudentID=6,CourseID=1045},
* new Enrollment{StudentID=7,CourseID=3141,Grade=Grade.A},
* };
* foreach (Enrollment e in enrollments)
* {
* context.Enrollment.Add(e);
* }
* context.SaveChanges();
*/
}
