Esempio n. 1
0
        public void CreateRestaurantAsync_Success()
        {
            var restaurantToCreate = new Restaurant()
            {
                Name = "Cool Cones", Address = "123 milkshake way", City = "Chocoburgh"
            };
            var sut    = new RestaurantDataManager(DbContext);
            var result = sut.CreateRestaurantAsync(restaurantToCreate).Result;

            Assert.IsTrue(result.Id > 0);
            Assert.AreEqual(result.Name, "Cool Cones");
            using (var reader = this.ExecuteReader("select * from Restaurant where Id=@Id", System.Data.CommandType.Text,
                                                   new System.Data.SqlClient.SqlParameter()
            {
                ParameterName = "Id", SqlDbType = System.Data.SqlDbType.Int, Value = result.Id
            }))
            {
                reader.Read();
                var actualName = reader.GetValue(reader.GetOrdinal("Name"));
                var actualCity = reader.GetValue(reader.GetOrdinal("City"));
                Assert.AreEqual(restaurantToCreate.Name, actualName);
                Assert.AreEqual(restaurantToCreate.City, actualCity);
            }
        }