static void Main(string[] args)
{
DemodataDbClient client = new DemodataDbClient();
Console.WriteLine("[Read people whose last initial is 'D']");
using (RecordManager <Person, PersonKeyCollection> people = client.Person()) {
IEnumerable <Person> query = people.Query(p =>
p.Last_Name.GreaterThanOrEqual("D") &&
p.Last_Name.LessThan("E"));
foreach (Person person in query)
{
Console.WriteLine("Name: {0} {1}",
person.First_Name,
person.Last_Name);
}
}
Console.WriteLine();
Console.WriteLine("[Person CRUD]");
using (RecordManager <Person, PersonKeyCollection> people = client.Person()) {
using (Transaction transaction = client.BeginTransaction()) {
Console.Write("Create person: ");
Person person = new Person();
person.ID = 0;
person.First_Name = "Ieyasu";
person.Last_Name = "Tokugawa";
people.Add(person);
people.SaveChanges();
Console.WriteLine("done");
people.Detach(person);
person = people.GetAndManage(p => p.ID == 0);
Console.WriteLine("Read person: " +
(person == null ? "not found" : person.First_Name + " " + person.Last_Name));
Console.Write("Update person: ");
person.First_Name = "Iemitsu";
people.SaveChanges();
Console.WriteLine("done");
people.Detach(person);
person = people.GetAndManage(p => p.ID == 0);
Console.WriteLine("Read person: " +
(person == null ? "not found" : person.First_Name + " " + person.Last_Name));
Console.Write("Delete person: ");
people.Remove(person);
people.SaveChanges();
Console.WriteLine("done");
people.Detach(person);
person = people.Get(p => p.ID == 0);
Console.WriteLine("Read person: " +
(person == null ? "not found" : person.First_Name + " " + person.Last_Name));
transaction.Commit();
}
}
}
public void Add()
{
//Record r = new Record(5, "I Wonder Why", "Dion and the belmonts", 121, new DateTime(1959, 1, 1));
Record r = new Record()
{
Title = "I Wonder Why", Artist = "Dion an the Belmonts", Duration = 121, ReleaseDate = 1959
};
Record added = _manager.Add(r);
Assert.AreEqual(4, added.Id);
}
public ActionResult <Record> Post([FromBody] Record value)
{
try
{
Record record = _manager.Add(value);
string uri = Url.RouteUrl(RouteData.Values) + "/" + record.Id;
return(Created(uri, record));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
