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(); } } }
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(); } } }