This page displays how the LINQ to SQL runtime generates SQL statements in order to
interact with the DBMS. This demo will help you to better understand, how LINQ to SQL
works. The SQL genetated by the
DataContext instance
is displayed in the in a TEXTAREA HTML element. The Log property of the DataContext class specifies what SQL
query or command should be written to the destination. This demo has been adapted from demos provided by
Matt Berseth.
|
ID
|
Name
|
Category
|
Quantity
|
Price
|
Stock
|
Supplier
|
| 1 |
Chai |
Beverages |
10 boxes x 20 bags |
$18.00 |
39 |
Exotic Liquids |
| 2 |
Chang |
Beverages |
24 - 12 oz bottles |
$19.00 |
17 |
Exotic Liquids |
| 3 |
Aniseed Syrup |
Condiments |
12 - 550 ml bottles |
$10.00 |
13 |
Exotic Liquids |
| 4 |
Chef Anton's Cajun Seasoning |
Condiments |
48 - 6 oz jars |
$22.00 |
53 |
New Orleans Cajun Delights |
| 5 |
Chef Anton's Gumbo Mix |
Condiments |
36 boxes |
$21.35 |
0 |
New Orleans Cajun Delights |
| 6 |
Grandma's Boysenberry Spread |
Condiments |
12 - 8 oz jars |
$25.00 |
120 |
Grandma Kelly's Homestead |
| 7 |
Uncle Bob's Organic Dried Pears |
Produce |
12 - 1 lb pkgs. |
$30.00 |
15 |
Grandma Kelly's Homestead |
| 8 |
Northwoods Cranberry Sauce |
Condiments |
12 - 12 oz jars |
$40.00 |
6 |
Grandma Kelly's Homestead |
| 9 |
Mishi Kobe Niku |
Meat/Poultry |
18 - 500 g pkgs. |
$97.00 |
29 |
Tokyo Traders |
| 10 |
Ikura |
Seafood |
12 - 200 ml jars |
$31.00 |
31 |
Tokyo Traders |