public void ExecuteReader4() //嵌套Reader，连接字符串需设置MultipleActiveResultSets=true
{
List <BookCategory> bookCategories = new List <BookCategory>();
List <Book> books = new List <Data.Book>();
h.Execute("select * from bookcategories", reader =>
{
while (reader.Read())
{
var bookCategory = new BookCategory();
bookCategory.Id = reader.GetInt32(0);
bookCategory.CategoryName = reader.IsDBNull(1) ? null : reader.GetString(1);
h.Execute("select * from books where bookcategory=@id", reader2 =>
{
while (reader2.Read())
{
var book = new Book();
book.Id = reader2.GetInt32(0);
book.BookName = reader2.IsDBNull(1) ? null : reader2.GetString(1);
book.BookPages = reader2.IsDBNull(2) ? null : (int?)reader2.GetInt32(2);
book.BookCategory = reader2.IsDBNull(3) ? null : (int?)reader2.GetInt32(3);
books.Add(book);
bookCategory.Books.Add(book);
}
}, h.CreateParameter("@id", bookCategory.Id));
bookCategories.Add(bookCategory);
}
});
foreach (var bookCategory in bookCategories)
{
Console.WriteLine("类别名称：" + bookCategory.CategoryName);
}
foreach (var book in books)
{
Console.WriteLine("书名：" + book.BookName);
}
Assert.True(bookCategories.Count > 0 && books.Count > 0);
}
public void ExecuteReader3()
{
List <BookCategory> bookCategories = new List <BookCategory>();
h.Execute("select * from bookcategories", reader =>
{
while (reader.Read())
{
var bookCategory = new BookCategory();
bookCategory.Id = reader.GetInt32(0);
bookCategory.CategoryName = reader.IsDBNull(1) ? null : reader.GetString(1);
bookCategories.Add(bookCategory);
}
});
foreach (var bookCategory in bookCategories)
{
Console.WriteLine("类别名称：" + bookCategory.CategoryName);
}
Assert.True(bookCategories.Count > 0);
}