Пример #1
0
        public ActionResult Index()
        {
            var db       = new FeedPostContext("DefaultConnectionString");
            var allUsers = from p in db.Posts select p.UserId;

            return(View());
        }
Пример #2
0
        public void TestMethod1()
        {
            using (var db = new FeedPostContext()) {
                int newUserid = (new Random()).Next(0, 1000000000);
                var post      = new FeedPost()
                {
                    Id = 123, UserId = newUserid
                };
                db.Posts.Add(post);
                db.SaveChanges();

                var query = from p in db.Posts
                            where p.UserId == newUserid
                            select p;

                Assert.AreEqual(query.Count(), 1);

                Console.WriteLine("All posts in the database:");
                foreach (var item in query)
                {
                    Console.WriteLine(item.UserId);
                }

                Console.WriteLine("Press any key to exit...");
            }
        }