Example Pass_001

Example Pass_001

Read All Data to List<CategoryEntry>

SqlCommand cmd = new SqlCommand("select * from Categories", Connection);
var Categories = nTinyPass<CategoryEntry>.QueryAll(cmd.ExecuteReader());
foreach(var category in Categories)
{
  Debug.Print($"{category}");
}

   class CategoryEntry
  {
     public int CategoryID { get; set; }
     public string CategoryName { get; set; }
     public string Description { get; set; }
     public byte[] Picture { get; set; }
     public override string ToString()
     {
       return $"CategoryEntry (CategoryID={CategoryID} CategoryName='{CategoryName}'  Description='{Description}  Picture Size={Picture?.Length}";
     }
}

**輸出結果**

CategoryEntry (CategoryID=1 CategoryName='Beverages'  Description='Soft drinks, coffees, teas, beers, and ales'  Picture Size=10746
CategoryEntry (CategoryID=2 CategoryName='Condiments'  Description='Sweet and savory sauces, relishes, spreads, and seasonings'  Picture Size=10746
CategoryEntry (CategoryID=3 CategoryName='Confections'  Description='Desserts, candies, and sweet breads'  Picture Size=10746
CategoryEntry (CategoryID=4 CategoryName='Dairy Products'  Description='Cheeses'  Picture Size=10746
CategoryEntry (CategoryID=5 CategoryName='Grains/Cereals'  Description='Breads, crackers, pasta, and cereal'  Picture Size=10746
CategoryEntry (CategoryID=6 CategoryName='Meat/Poultry'  Description='Prepared meats'  Picture Size=10746
CategoryEntry (CategoryID=7 CategoryName='Produce'  Description='Dried fruit and bean curd'  Picture Size=10746
CategoryEntry (CategoryID=8 CategoryName='Seafood'  Description='Seaweed and fish'  Picture Size=10746

• 測試來源 Mocrosoft Northwind Sample Database