static void Main(string[] args) { OrMapper orm = new OrMapper(); //Get some values var lst = GetListAndPrintPhotographers(orm); Console.WriteLine("------------------------------------------------------------------"); var lstc = GetListAndPrintCameras(orm); Console.WriteLine("------------------------------------------------------------------"); var lstp = GetListAndPrintPictures(orm); Console.WriteLine("------------------------------------------------------------------"); //Change some Values: lst[0].Name += " X"; lst[1].BirthDate = lst[1].BirthDate.AddDays(1); lst[2].Notes += " X"; orm.SubmitChanges(); GetListAndPrintPhotographers(orm); Console.WriteLine("------------------------------------------------------------------"); //insert a new Value: orm.Insert(new Photographer() { BirthDate = new DateTime(1968, 10, 30), Id = 0, Name = "Lol", Notes = "notes", SurName = "OMG" }); orm.SubmitChanges(); var lst2 = GetListAndPrintPhotographers(orm); Console.WriteLine("------------------------------------------------------------------"); //Delete a Value: using (var lst3 = lst2.Where(photographer => photographer.Name.Equals("Lol")).GetEnumerator()) { if (lst3.MoveNext()) { orm.Delete(lst3.Current); } } orm.SubmitChanges(); GetListAndPrintPhotographers(orm); Console.WriteLine("------------------------------------------------------------------"); Console.ReadKey(); }
private static List <Camera> GetListAndPrintCameras(OrMapper orm) { var qry = orm.GetQuery <Camera>(); var filtered = qry .Where(i => true); var lst = filtered.ToList(); foreach (var i in lst) { Console.WriteLine($"{i.Id}, {i.IsoLimitAcceptable}, {i.IsoLimitGood}, {i.Model}, {i.Notes}, {i.Producer}, {i.PurchaseDate}"); } return(lst); }
private static List <Photographer> GetListAndPrintPhotographers(OrMapper orm) { var qry = orm.GetQuery <Photographer>(); var filtered = qry .Where(i => true); var lst = filtered.ToList(); foreach (var i in lst) { Console.WriteLine($"{i.Id}, {i.Name}, {i.SurName}, {i.BirthDate}, {i.Notes}"); } return(lst); }
private static List <Picture> GetListAndPrintPictures(OrMapper orm) { var qry = orm.GetQuery <Picture>(); var filtered = qry .Where(i => true); var lst = filtered.ToList(); foreach (var i in lst) { Console.WriteLine($"{i.Id}, {i.Filename}, {i.PhotographerId}, {i.CameraId}, {i.ExifAperture}, {i.ExifExposureProg}, {i.ExifExposureTime}, {i.ExifFlash}, {i.ExifIso}, {i.IptcCaption}, {i.IptcCopyright}, {i.IptcHeadline}, {i.IptcKeywords}"); } return(lst); }
public DemoLinqProvider(OrMapper orMapper) { _orMapper = orMapper; }
public DemoLinq(OrMapper orMapper) { _expression = Expression.Constant(this); _provider = new DemoLinqProvider(orMapper); }