Exemplo n.º 1
0
        static void Main(string[] args)
        {
            using (var db = new BloggingContext())
            {
                var post = new Post() { Content = "jahgj", Title = "akjha" };
                var blog = new Blog { Url = "http://blogs.msdn.com/adonet" , Posts = new System.Collections.Generic.List<Post>() { post } };
                post.Blog = blog;

                db.ChangeTracker.TrackGraph(blog, (n) => n.State = Microsoft.Data.Entity.EntityState.Added);
                db.SaveChanges();

                foreach (var blog1 in db.Blogs)
                {
                    Console.WriteLine(blog1.Url);
                }
            }
        }
Exemplo n.º 2
0
        public static void Insert()
        {
            LogNewLine();

            using (_operLogger.BeginScope("{BatchId}", "Insert"))
            {
                var batchSW = LogStarted();

                using (var ctx = new BloggingContext(_dbCtxOpts))
                {
                    var operSW = new Stopwatch();

                    using (_operLogger.BeginScope("{OperId}", ".Insert1"))
                    {
                        LogStarted(operSW);

                        var user = new User
                        {
                            Name1      = "User Insert 123",
                            DateCreate = DateTime.Now,
                            Gender     = Gender.Female,
                            Id         = 3
                        };

                        var res = ctx.Insert <User>(user);

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Insert2 (with anonymous)"))
                    {
                        LogStarted(operSW);

                        var obj = new
                        {
                            Name1      = "User Insert 123",
                            DateCreate = DateTime.Now,
                            Gender     = Gender.Female
                        };

                        var res = ctx.Insert <User>(obj);
                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Insert3"))
                    {
                        LogStarted(operSW);

                        var user = new User()
                        {
                            Name1      = "User Insert 345",
                            DateCreate = DateTime.Now,
                            Gender     = Gender.Male
                        };

                        var res = ctx.Insert <User>(user);
                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Insert4 (without return identity)"))
                    {
                        LogStarted(operSW);

                        var user = new User()
                        {
                            Name1      = "User Insert 345",
                            DateCreate = DateTime.Now,
                            Gender     = Gender.Male
                        };

                        var res = ctx.Insert <User>(user, returnIdentity: false);

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Insert5 (without return identity)"))
                    {
                        LogStarted(operSW);

                        var user = new User()
                        {
                            Name1      = "User Insert 345",
                            DateCreate = DateTime.Now,
                            Gender     = Gender.Male
                        };

                        var res = ctx.Insert <User>(user, propertyKey: "User_Id");

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Insert6 (with class)"))
                    {
                        LogStarted(operSW);

                        var blog = new Blog
                        {
                            Name        = "Blog1",
                            UserId      = 2,
                            Description = "Blog1 desc",
                            DateCreate  = DateTime.Now
                        };

                        var res = ctx.Insert <Blog>(blog);
                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Insert7 (with anonymous and DbSet)"))
                    {
                        LogStarted(operSW);

                        var obj = new
                        {
                            Name1      = "User Insert 123",
                            DateCreate = DateTime.Now,
                            Gender     = Gender.Female
                        };

                        var res = ctx.Users.Insert(obj);
                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Insert8 (bulk)"))
                    {
                        LogStarted(operSW);

                        var dt = DateTime.Now;

                        var objs = new[]
                        {
                            new {
                                Name1      = "User Insert 123",
                                DateCreate = dt,
                                Gender     = Gender.Female
                            },
                            new {
                                Name1      = "User Insert 234",
                                DateCreate = dt,
                                Gender     = Gender.Male
                            },
                            new {
                                Name1      = "User Insert 345",
                                DateCreate = dt,
                                Gender     = Gender.Female
                            },
                        };

                        var res = ctx.Insert <User>(objs, 2);
                        LogElapsed(operSW, "ended", $"res = {res}");
                    }
                }

                LogElapsed(batchSW, "ended");
            }
        }
Exemplo n.º 3
0
        public static async Task SelectAsync()
        {
            LogNewLine();

            using (_operLogger.BeginScope("{BatchId}", "SelectAsync"))
            {
                var tasks = new List <Task>();

                var batchSw = LogStarted();
                var operSw  = Stopwatch.StartNew();

                using (var ctx = new BloggingContext(_dbCtxOpts))
                {
                    ctx.SetDapperMapping <User>();
                }

                LogElapsed(operSw, "set mapping");

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Select1"))
                    {
                        var sw    = LogStarted();
                        int count = 0;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var stateSw = Stopwatch.StartNew();
                            var q       = ctx.Users.Where(o => o.Id > 1 && o.Name1 == "User Insert2").OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2);
                            LogElapsed(stateSw, "created query");
                            count = (await ctx.QueryAsync(q).ConfigureAwait(false)).Count();
                        }

                        LogElapsed(sw, "ended", $"count = {count}");
                    }
                }));

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Select2 (with selector)"))
                    {
                        var sw    = LogStarted();
                        int count = 0;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var stateSw = Stopwatch.StartNew();
                            var q       = ctx.Users.Where(o => o.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2).Select(x => new { x.Id, Name = x.Name1 });
                            LogElapsed(stateSw, "created query");
                            count = (await ctx.QueryAsync(q).ConfigureAwait(false)).Count();
                        }

                        LogElapsed(sw, "ended", $"count = {count}");
                    }
                }));

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Select3"))
                    {
                        var sw    = LogStarted();
                        int count = 0;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var stateSw = Stopwatch.StartNew();
                            var q       = ctx.Users.Where(o => o.Id > 1 && o.Name1 == "User Insert2").OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2);
                            LogElapsed(stateSw, "created query");
                            count = (await ctx.QueryAsync(q).ConfigureAwait(false)).Count();
                        }

                        LogElapsed(sw, "ended", $"count = {count}");
                    }
                }));

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Select4 (with selector)"))
                    {
                        var sw    = LogStarted();
                        int count = 0;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var stateSw = Stopwatch.StartNew();
                            var q       = ctx.Users.Where(o => o.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2).Select(x => new { x.Id, Name = x.Name1 });
                            LogElapsed(stateSw, "created query");
                            var res = (await ctx.QueryAsync(q).ConfigureAwait(false)).Count();
                        }

                        LogElapsed(sw, "ended", $"count = {count}");
                    }
                }));

                await Task.WhenAll(tasks).ConfigureAwait(false);

                LogElapsed(batchSw, "ended");
            }
        }
Exemplo n.º 4
0
        public static void SelectSync()
        {
            LogNewLine();

            using (_operLogger.BeginScope("{BatchId}", "SelectSync"))
            {
                var batchSw = LogStarted();
                var operSw  = new Stopwatch();

                using (_operLogger.BeginScope("{OperId}", ".Warmup"))
                {
                    LogStarted(operSw);

                    //warmup
                    using (var ctx = new BloggingContext(_dbCtxOpts))
                    {
                        ctx.SetDapperMapping <User>();
                        var q      = ctx.Users.Where(o => o.Id > 1 && o.Name1 == "User Insert2").OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2);
                        var result = ctx.Query(q);
                    }

                    LogElapsed(operSw, "ended", "ignore timing");
                }

                LogNewLine();
                batchSw.Restart();
                operSw.Restart();

                using (var ctx = new BloggingContext(_dbCtxOpts))
                {
                    LogElapsed(operSw, "created context");

                    using (_operLogger.BeginScope("{OperId}", ".Select1"))
                    {
                        LogStarted(operSw);

                        var q   = ctx.Users.Where(o => o.Id > 1 && o.Name1 == "User Insert2").OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2);
                        var res = ctx.Query(q);

                        LogElapsed(operSw, "ended", $"count = {res.Count()}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Select12 (with selector)"))
                    {
                        LogStarted(operSw);

                        var q   = ctx.Users.Where(o => o.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2).Select(x => new { x.Id, Name = x.Name1 });
                        var res = ctx.Query(q);

                        LogElapsed(operSw, "ended", $"count = {res.Count()}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Select13"))
                    {
                        LogStarted(operSw);

                        var q   = ctx.Users.Where(o => o.Id > 1 && o.Name1 == "User Insert2").OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2);
                        var res = ctx.Query(q);

                        LogElapsed(operSw, "ended", $"count = {res.Count()}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Select14 (with selector)"))
                    {
                        LogStarted(operSw);

                        var q   = ctx.Users.Where(o => o.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2).Select(x => new { x.Id, Name = x.Name1 });
                        var res = ctx.Query(q);

                        LogElapsed(operSw, "ended", $"count = {res.Count()}");
                    }

                    operSw.Restart();
                }

                LogElapsed(operSw, "disposed context");
                LogElapsed(batchSw, "ended");
            }
        }
Exemplo n.º 5
0
        public static void Select()
        {
            var q1 = EF.CompileQuery(
                (BloggingContext ctx) =>
                ctx.Users.Where(o => o.Id > 1 && o.Name1 == "User Insert2")
                .OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2));

            LogNewLine();

            using (_operLogger.BeginScope("{BatchId}", "Select"))
            {
                var batchSW = LogStarted();

                using (var ctx = new BloggingContext(_dbCtxOpts))
                {
                    ctx.SetDapperMapping <User>();
                    var operSW = new Stopwatch();

                    using (_operLogger.BeginScope("{OperId}", ".Select1a (compiled)"))
                    {
                        LogStarted(operSW);

                        var res = q1(ctx);

                        LogElapsed(operSW, "ended", $"count = {res.Count()}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Select1"))
                    {
                        LogStarted(operSW);

                        var q = ctx.Users.Where(o => o.Id > 1 && o.Name1 == "User Insert2")
                                .OrderBy(x => x.Id).ThenByDescending(x => x.Name1).Take(2);
                        var res = ctx.Query(q);

                        LogElapsed(operSW, "ended", $"count = {res.Count()}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Select2 (with selector)"))
                    {
                        LogStarted(operSW);

                        var q = ctx.Users.Where(o => o.Id > 1).OrderBy(x => x.Id).ThenByDescending(x => x.Name1)
                                .Take(2).Select(x => new { x.Id, Name = x.Name1 });
                        var res = ctx.Query(q);

                        LogElapsed(operSW, "ended", $"count = {res.Count()}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Select3"))
                    {
                        LogStarted(operSW);

                        var q = ctx.Blogs.Where(b => b.Name == "Blog2").Join(ctx.Users, o => o.UserId, i => i.Id,
                                                                             (o, i) => new { Blog = o, User = i });

                        var res = ctx.Query(q, (Blog b, User u) =>
                        {
                            b.User = u;
                            return(new { Blog = b, User = u });
                        });

                        LogElapsed(operSW, "ended", $"count = {res.Count()}");
                    }

                    var stateSw = new Stopwatch();

                    using (_operLogger.BeginScope("{OperId}", ".Select4"))
                    {
                        LogNewLine();
                        LogStarted(operSW);

                        stateSw.Restart();

                        var q = from u in ctx.Users
                                join b in ctx.Blogs on u.Id equals b.UserId into bg
                                from b in bg.DefaultIfEmpty()
                                join p in ctx.BlogPosts on b.Id equals p.BlogId into pg
                                from p in pg.DefaultIfEmpty()
                                where u.Id == 2
                                select new
                        {
                            User = u,
                            Blog = b,
                            Post = p
                        };

                        LogElapsed(stateSw, "created query");

                        var res = ctx.Query(q, (User u, Blog b, BlogPost p) =>
                        {
                            b.User = u;

                            if (p != null)
                            {
                                p.Blog = b;
                            }

                            return(new
                            {
                                User = u,
                                Blog = b,
                                Post = p
                            });
                        });

                        stateSw.Restart();

                        var users = res.GroupBy(ug => ug.User.Id, (key, uItems) =>
                        {
                            var item        = uItems.First();
                            item.User.Blogs = uItems.GroupBy(bg => bg.Blog?.Id, (bid, bItems) =>
                            {
                                var bitem = bItems.FirstOrDefault();
                                if (bitem == null)
                                {
                                    return(null);
                                }
                                bitem.Blog.BlogPosts = bItems.Select(x => x.Post).
                                                       Where(x => x != null).ToArray();
                                return(bitem.Blog);
                            }).Where(x => x != null).ToArray();
                            return(item.User);
                        }).ToArray();

                        LogElapsed(stateSw, "processed result");
                        LogElapsed(operSW, "ended", $"count = {res.Count()}");
                    }
                }

                LogElapsed(batchSW, "ended");
            }
        }
Exemplo n.º 6
0
        public static async Task UpdateAsync()
        {
            LogNewLine();

            using (_operLogger.BeginScope("{BatchId}", "UpdateAsync"))
            {
                var tasks = new List <Task>();

                var batchSw = LogStarted();
                var operSw  = Stopwatch.StartNew();

                using (var ctx = new BloggingContext(_dbCtxOpts))
                {
                    ctx.SetDapperMapping <User>();
                }

                LogElapsed(operSw, "set mapping");

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Update1"))
                    {
                        var sw = LogStarted();
                        int res;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var obj = new
                            {
                                Gender = Gender.Male,
                                Id     = 2,
                                Name1  = "test2"
                            };

                            var id   = 3;
                            var name = "teste";
                            res      = await ctx.UpdateAsync <User>(obj, x => x.Id == id && x.Name1 == name).ConfigureAwait(false);
                        }

                        LogElapsed(sw, "ended", $"res = {res}");
                    }
                }));

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Update2"))
                    {
                        var sw = LogStarted();
                        int res;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var obj = new
                            {
                                Gender = Gender.Male,
                                Id     = 2,
                                Name1  = "teste"
                            };

                            var id   = 3;
                            var name = "test2";
                            res      = await ctx.UpdateAsync <User>(obj, x => x.Id == id && x.Name1 == name).ConfigureAwait(false);
                        }

                        LogElapsed(sw, "ended", $"res = {res}");
                    }
                }));

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Update3 (bulk)"))
                    {
                        var sw = LogStarted();
                        int res;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var objs = new[]
                            {
                                new
                                {
                                    Gender = Gender.Male,
                                    Id     = 8,
                                    Name1  = "User Insert83"
                                },
                                new
                                {
                                    Gender = Gender.Female,
                                    Id     = 9,
                                    Name1  = "User Insert93"
                                },
                                new
                                {
                                    Gender = Gender.Female,
                                    Id     = 10,
                                    Name1  = "User Insert103"
                                }
                            };

                            res = await ctx.UpdateAsync <User>(objs, 2);
                        }

                        LogElapsed(sw, "ended", $"res = {res}");
                    }
                }));

                await Task.WhenAll(tasks).ConfigureAwait(false);

                LogElapsed(batchSw, "ended");
            }
        }
Exemplo n.º 7
0
        public static void Update()
        {
            LogNewLine();

            using (_operLogger.BeginScope("{BatchId}", "Update"))
            {
                var batchSW = LogStarted();

                using (var ctx = new BloggingContext(_dbCtxOpts))
                {
                    var operSW = new Stopwatch();

                    using (_operLogger.BeginScope("{OperId}", ".Update1 (with anonymous)"))
                    {
                        LogStarted(operSW);

                        var obj = new
                        {
                            Gender = Gender.Male,
                            Id     = 2,
                            Name1  = "test2"
                        };

                        var id  = 3;
                        var res = ctx.Update <User>(obj, x => x.Id == id && x.Name1 == "teste");

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Update2 (with anonymous)"))
                    {
                        LogStarted(operSW);

                        var obj = new
                        {
                            Gender = Gender.Male,
                            Id     = 2
                        };

                        var res = ctx.Update <User>(obj);
                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Update3 (with query)"))
                    {
                        LogStarted(operSW);

                        var res = ctx.Update <User>(new
                        {
                            Gender = Gender.Female
                        }, o => o.Id == 1);

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Update4 (with complex query)"))
                    {
                        LogStarted(operSW);

                        var name = "teste";

                        var res = ctx.Update <User>(new
                        {
                            Gender = Gender.Female
                        }, o => o.Id == 1 && (o.Name1 == name || o.DateCreate > DateTime.Now));

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Update5 (with complex query)"))
                    {
                        LogStarted(operSW);

                        var name = "teste";

                        var res = ctx.Update <User>(new
                        {
                            Gender = Gender.Female
                        }, o => o.Id == 1 && (o.Name1 == name || o.DateCreate > DateTime.Now));

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Update6 (with DbSet)"))
                    {
                        LogStarted(operSW);

                        var name = "teste";

                        var res = ctx.Users.Update(new
                        {
                            Gender = Gender.Female
                        }, o => o.Id == 1 && (o.Name1 == name || o.DateCreate > DateTime.Now));

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }

                    LogNewLine();

                    using (_operLogger.BeginScope("{OperId}", ".Update7 (bulk)"))
                    {
                        LogStarted(operSW);

                        var objs = new[]
                        {
                            new
                            {
                                Gender = Gender.Male,
                                Id     = 8,
                                Name1  = "User Insert8"
                            },
                            new
                            {
                                Gender = Gender.Female,
                                Id     = 9,
                                Name1  = "User Insert9"
                            },
                            new
                            {
                                Gender = Gender.Female,
                                Id     = 10,
                                Name1  = "User Insert10"
                            }
                        };

                        var res = ctx.Update <User>(objs);

                        LogElapsed(operSW, "ended", $"res = {res}");
                    }
                }

                LogElapsed(batchSW, "ended");
            }
        }
Exemplo n.º 8
0
        public static async Task InsertAsync()
        {
            LogNewLine();

            using (_operLogger.BeginScope("{BatchId}", "InsertAsync"))
            {
                var tasks = new List <Task>();

                var batchSw = LogStarted();
                var operSw  = Stopwatch.StartNew();

                using (var ctx = new BloggingContext(_dbCtxOpts))
                {
                    ctx.SetDapperMapping <User>();
                }

                LogElapsed(operSw, "set mapping");

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Insert1"))
                    {
                        var sw = LogStarted();
                        decimal?res;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var u = new User
                            {
                                Name1      = "User Insert 123",
                                DateCreate = DateTime.Now,
                                Gender     = Gender.Female,
                                Id         = 3
                            };

                            res = await ctx.InsertAsync <User>(u).ConfigureAwait(false);
                        }

                        LogElapsed(sw, "ended", $"res = {res}");
                    }
                }));

                tasks.Add(Task.Run(async() =>
                {
                    using (_operLogger.BeginScope("{OperId}", ".Insert2"))
                    {
                        var sw = LogStarted();
                        int res;

                        using (var ctx = new BloggingContext(_dbCtxOpts))
                        {
                            var dt = DateTime.Now;

                            var objs = new[]
                            {
                                new {
                                    Name1      = "User Insert 123",
                                    DateCreate = dt,
                                    Gender     = Gender.Female
                                },
                                new {
                                    Name1      = "User Insert 234",
                                    DateCreate = dt,
                                    Gender     = Gender.Male
                                },
                                new {
                                    Name1      = "User Insert 345",
                                    DateCreate = dt,
                                    Gender     = Gender.Female
                                },
                            };

                            res = await ctx.InsertAsync <User>(objs, 2).ConfigureAwait(false);
                        }

                        LogElapsed(sw, "ended", $"res = {res}");
                    }
                }));

                await Task.WhenAll(tasks).ConfigureAwait(false);

                LogElapsed(batchSw, "ended");
            }
        }