Esempio n. 1
0
        private static void Main(string[] args)
        {
            var test = new User();

            test.UserName = "******";

            // lite database with migration cant use both in the same system so mssql or lite db
            using (var rep = new LiteRepository())
            {
                var users = rep.Get <User>().Where(x =>
                                                   (x.Role.Name.EndsWith("admin") &&
                                                    x.UserName.Contains("alen")) ||
                                                   x.Address.Any(a => (a.AddressName.StartsWith("test") || a.AddressName.Contains("mt")) && a.Id > 0)
                                                   ).LoadChildren();


                foreach (User user in users.Execute())
                {
                    user.UserName  = "******";
                    user.Role.Name = "Administrator 2";
                    user.Address.First().AddressName = "Changed";
                    // now we could do rep.Save(user); but will choose to save the whole list later insetad
                }
                var sql = users.ParsedLinqToSql;
                var us  = users.Execute().Clone().ClearAllIdsHierarchy();
                users.Save();

                Console.WriteLine(users.ToJson());
                //Console.ReadLine();
            }

            // Mssql with migration
            //using (var rep = new Repository())
            //{
            //    var users = rep.Get<User>().Where(x =>
            //        (x.Role.Name.EndsWith("admin") &&
            //         x.UserName.Contains("alen")) ||
            //        x.Address.Any(a => (a.AddressName.StartsWith("test") || a.AddressName.Contains("mt")) && a.Id > 0)
            //    ).LoadChildren();


            //    foreach (User user in users.Execute())
            //    {
            //        user.UserName = "******";
            //        user.Role.Name = "Administrator 1";
            //        user.Address.First().AddressName = "Changed";
            //        // now we could do rep.Save(user); but will choose to save the whole list later insetad
            //    }
            //    var sql = users.ParsedLinqToSql;
            //    var us = users.Execute().Clone().ClearAllIdsHierarchy();
            //    users.Save();

            //    Console.WriteLine(users.ToJson());
            //    Console.ReadLine();
            //}
        }
Esempio n. 2
0
 // GET api/values/5
 public Toy Get(int id)
 {
     return(repository.Get(id));
 }