public HttpResponseMessage Read()
{
using (var dbContext = new PersonContext())
{
return this.Request.CreateResponse(HttpStatusCode.OK, dbContext.Persons.ToList());
}
}
public void DannEinHansPeterGeborenAm_SollInDerDatenbankGespeichertSein_(string firstName, string lastName, string birthdate)
{
using (var context = new PersonContext())
{
var found = context.Persons.Any(x => x.FirstName == firstName && x.LastName == lastName && x.BirthDate == birthdate);
Assert.IsTrue(found, "Person was not found in database.");
}
}
private static void CreateDataBase()
{
using (var context = new PersonContext())
{
if (context.Database.Exists())
{
context.Database.Delete();
}
context.Database.Create();
}
}
public static void List()
{
Services.Providers.Message("Cars:");
using (var c = new CarContext()) {
foreach (var car in c.Cars) Services.Providers.Message(null, "Key: {0}; Model: {1}", car.Key, car.Model);
}
Services.Providers.Message("Persons:");
using (var c = new PersonContext()) {
foreach (var p in c.Persons) Services.Providers.Message(null, "Key: {0}; Name: {1}; City: {2}", p.Key, p.Name, p.City);
}
}
public HttpResponseMessage Read(int id)
{
using (var dbContext = new PersonContext())
{
var result = dbContext.Persons.FirstOrDefault(p => p.Id == id);
if (result == null)
{
this.Request.CreateErrorResponse(HttpStatusCode.NotFound, "requested person not found!");
}
return this.Request.CreateResponse(HttpStatusCode.OK, result);
}
}
public HttpResponseMessage Create(Person person)
{
if (person == null)
{
return this.Request.CreateErrorResponse(HttpStatusCode.NoContent, "Invalid object!");
}
using (var dbContext = new PersonContext())
{
dbContext.Persons.Add(person);
dbContext.SaveChanges();
}
return this.Request.CreateResponse(HttpStatusCode.OK, person);
}
public static void Fill()
{
using (var p = new PersonContext()) {
p.Persons.Add(new Person { City="Basel", Name="David" });
p.Persons.Add(new Person { City="Basel", Name="Bettina" });
p.Persons.Add(new Person { City="Basel", Name="Sergio" });
p.Persons.Add(new Person { City="Thun", Name="Kim" });
p.SaveChanges();
}
Services.Providers.Message("Persons Filled.");
using (var c = new CarContext()) {
c.Cars.Add(new Car { Model = "Audi" });
c.Cars.Add(new Car { Model = "BMW" });
c.Cars.Add(new Car { Model = "Mercedes" });
c.Cars.Add(new Car { Model = "Fiat" });
c.SaveChanges();
}
Services.Providers.Message("Cars filled.");
}
public HomeController(PersonContext db)
{
_db = db;
}
public HttpResponseMessage Update(Person person)
{
if (person == null)
{
return this.Request.CreateErrorResponse(HttpStatusCode.NoContent, "requested person is invalid!");
}
using (var dbContext = new PersonContext())
{
var personToUpdate = dbContext.Persons.SingleOrDefault(p => p.Id == person.Id);
if (personToUpdate == null)
{
return this.Request.CreateErrorResponse(HttpStatusCode.NotFound, "requested person not found!");
}
Mapper.CreateMap<Person, Person>();
Mapper.Map(person, personToUpdate);
dbContext.SaveChanges();
return this.Request.CreateResponse(HttpStatusCode.OK, personToUpdate);
}
}
public MyRepository(PersonContext context)
{
_context = context;
}
public PersonController(ILogger <PersonController> logger, PersonContext context, RutValidator rutValidator)
{
_logger = logger;
_context = context;
_rutValidator = rutValidator;
}
public HttpResponseMessage Delete(int id)
{
using (var dbContext = new PersonContext())
{
var person = dbContext.Persons.FirstOrDefault(p => p.Id == id);
if (person == null)
{
return this.Request.CreateErrorResponse(HttpStatusCode.NotFound, "requested person not found!");
}
dbContext.Persons.Remove(person);
dbContext.SaveChanges();
return this.Request.CreateResponse(HttpStatusCode.OK);
}
}
public HttpResponseMessage Seed()
{
using (var dbContext = new PersonContext())
{
dbContext.Seed();
dbContext.SaveChanges();
return this.Request.CreateResponse(HttpStatusCode.OK, dbContext.Persons.ToList());
}
}
public HomeController(PersonContext db)
{
this.db = db;
}
public PersonaController(PersonContext context)
{
_context = context;
}
public static void Run()
{
// Ensure database is created and has a person in it
using (var context = new PersonContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.People.Add(new Person { FirstName = "John", LastName = "Doe" });
context.SaveChanges();
}
using (var context = new PersonContext())
{
// Fetch a person from database and change phone number
var person = context.People.Single(p => p.PersonId == 1);
person.PhoneNumber = "555-555-5555";
// Change the persons name in the database (will cause a concurrency conflict)
context.Database.ExecuteSqlCommand("UPDATE dbo.People SET FirstName = 'Jane' WHERE PersonId = 1");
try
{
// Attempt to save changes to the database
context.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
foreach (var entry in ex.Entries)
{
if (entry.Entity is Person)
{
// Using a NoTracking query means we get the entity but it is not tracked by the context
// and will not be merged with existing entities in the context.
var databaseEntity = context.People.AsNoTracking().Single(p => p.PersonId == ((Person)entry.Entity).PersonId);
var databaseEntry = context.Entry(databaseEntity);
foreach (var property in entry.Metadata.GetProperties())
{
var proposedValue = entry.Property(property.Name).CurrentValue;
var originalValue = entry.Property(property.Name).OriginalValue;
var databaseValue = databaseEntry.Property(property.Name).CurrentValue;
// TODO: Logic to decide which value should be written to database
// entry.Property(property.Name).CurrentValue = <value to be saved>;
// Update original values to
entry.Property(property.Name).OriginalValue = databaseEntry.Property(property.Name).CurrentValue;
}
}
else
{
throw new NotSupportedException("Don't know how to handle concurrency conflicts for " + entry.Metadata.Name);
}
}
// Retry the save operation
context.SaveChanges();
}
}
}
public HomeController(PersonContext db)
{
this.db = db;
}
public PersonRepository(PersonContext context) : base(context)
{
_context = context;
}
public void Setup()
{
file = Path.GetTempFileName();
context = new PersonContext(file);
}
public AddressesController(PersonContext context)
{
_context = context;
}
