コード例 #1
0
        public async Task <int> Merge(IEnumerable <AuthorDb> authorsDb)
        {
            using (var authorsCollection = AuthorCollectionDataTable.Init(authorsDb))
            {
                var result = await Connection.ExecuteAsync(
                    "[dbo].[Author_Merge]",
                    new { authorsCollection },
                    commandType : CommandType.StoredProcedure,
                    transaction : Transaction);

                return(result);
            }
        }
コード例 #2
0
        public void Init()
        {
            // Arrange
            var authors = _fixture.CreateMany <AuthorDb>().ToList();

            // Act
            var result = AuthorCollectionDataTable.Init(authors);

            // Assert
            Assert.AreEqual(authors.Count, result.Rows.Count);

            foreach (var(author, i) in authors.Select((value, i) => (value, i)))
            {
                var items = result.Rows[i].ItemArray;

                Assert.AreEqual(4, items.Length);

                Assert.AreEqual(author.Id, items[0]);
                Assert.AreEqual(author.BookId, items[1]);
                Assert.AreEqual(author.FirstName, items[2]);
                Assert.AreEqual(author.LastName, items[3]);
            }
        }