Mercurial > pub > bltoolkit

comparison Tools/Templates.VB/DataModel.generated.vb @ 0:f990fcb411a9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Копия текущей версии из github
author cin
date Thu, 27 Mar 2014 21:46:09 +0400
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f990fcb411a9
1 '---------------------------------------------------------------------------------------------------
2 ' <auto-generated>
3 ' This code was generated by BLToolkit template for T4.
4 ' Changes to this file may cause incorrect behavior and will be lost if the code is regenerated.
5 ' </auto-generated>
6 '---------------------------------------------------------------------------------------------------
7 Imports System
8 Imports System.Collections.Generic
9 Imports System.Linq
10 Imports System.Linq.Expressions
11 Imports System.Reflection
12 Imports System.Runtime.Serialization
13 Imports System.Text
14
15 Imports BLToolkit.Common
16 Imports BLToolkit.Data
17 Imports BLToolkit.Data.DataProvider
18 Imports BLToolkit.Data.Linq
19 Imports BLToolkit.Data.Sql
20 Imports BLToolkit.Data.Sql.SqlProvider
21 Imports BLToolkit.DataAccess
22 Imports BLToolkit.Mapping
23
24 Namespace Templates.VB
25
26 Public Partial Class DataModel
27 Inherits DbManager
28
29 Public ReadOnly Property AlphabeticalListOfProducts() As Table(Of AlphabeticalListOfProducts)
30 Get
31 Return Me.GetTable(Of AlphabeticalListOfProducts)()
32 End Get
33 End Property
34
35 Public ReadOnly Property Categories() As Table(Of Categories)
36 Get
37 Return Me.GetTable(Of Categories)()
38 End Get
39 End Property
40
41 Public ReadOnly Property CategorySalesFor1997() As Table(Of CategorySalesFor1997)
42 Get
43 Return Me.GetTable(Of CategorySalesFor1997)()
44 End Get
45 End Property
46
47 Public ReadOnly Property CurrentProductList() As Table(Of CurrentProductList)
48 Get
49 Return Me.GetTable(Of CurrentProductList)()
50 End Get
51 End Property
52
53 Public ReadOnly Property CustomerAndSuppliersByCity() As Table(Of CustomerAndSuppliersByCity)
54 Get
55 Return Me.GetTable(Of CustomerAndSuppliersByCity)()
56 End Get
57 End Property
58
59 Public ReadOnly Property CustomerCustomerDemo() As Table(Of CustomerCustomerDemo)
60 Get
61 Return Me.GetTable(Of CustomerCustomerDemo)()
62 End Get
63 End Property
64
65 Public ReadOnly Property CustomerDemographics() As Table(Of CustomerDemographics)
66 Get
67 Return Me.GetTable(Of CustomerDemographics)()
68 End Get
69 End Property
70
71 Public ReadOnly Property Customers() As Table(Of Customers)
72 Get
73 Return Me.GetTable(Of Customers)()
74 End Get
75 End Property
76
77 Public ReadOnly Property Employees() As Table(Of Employees)
78 Get
79 Return Me.GetTable(Of Employees)()
80 End Get
81 End Property
82
83 Public ReadOnly Property EmployeeTerritories() As Table(Of EmployeeTerritories)
84 Get
85 Return Me.GetTable(Of EmployeeTerritories)()
86 End Get
87 End Property
88
89 Public ReadOnly Property Invoices() As Table(Of Invoices)
90 Get
91 Return Me.GetTable(Of Invoices)()
92 End Get
93 End Property
94
95 Public ReadOnly Property OrderDetails() As Table(Of OrderDetails)
96 Get
97 Return Me.GetTable(Of OrderDetails)()
98 End Get
99 End Property
100
101 Public ReadOnly Property OrderDetailsExtended() As Table(Of OrderDetailsExtended)
102 Get
103 Return Me.GetTable(Of OrderDetailsExtended)()
104 End Get
105 End Property
106
107 Public ReadOnly Property OrderSubtotals() As Table(Of OrderSubtotals)
108 Get
109 Return Me.GetTable(Of OrderSubtotals)()
110 End Get
111 End Property
112
113 Public ReadOnly Property Orders() As Table(Of Orders)
114 Get
115 Return Me.GetTable(Of Orders)()
116 End Get
117 End Property
118
119 Public ReadOnly Property OrdersQry() As Table(Of OrdersQry)
120 Get
121 Return Me.GetTable(Of OrdersQry)()
122 End Get
123 End Property
124
125 Public ReadOnly Property ProductSalesFor1997() As Table(Of ProductSalesFor1997)
126 Get
127 Return Me.GetTable(Of ProductSalesFor1997)()
128 End Get
129 End Property
130
131 Public ReadOnly Property Products() As Table(Of Products)
132 Get
133 Return Me.GetTable(Of Products)()
134 End Get
135 End Property
136
137 Public ReadOnly Property ProductsAboveAveragePrice() As Table(Of ProductsAboveAveragePrice)
138 Get
139 Return Me.GetTable(Of ProductsAboveAveragePrice)()
140 End Get
141 End Property
142
143 Public ReadOnly Property ProductsByCategory() As Table(Of ProductsByCategory)
144 Get
145 Return Me.GetTable(Of ProductsByCategory)()
146 End Get
147 End Property
148
149 Public ReadOnly Property QuarterlyOrders() As Table(Of QuarterlyOrders)
150 Get
151 Return Me.GetTable(Of QuarterlyOrders)()
152 End Get
153 End Property
154
155 Public ReadOnly Property Region() As Table(Of Region)
156 Get
157 Return Me.GetTable(Of Region)()
158 End Get
159 End Property
160
161 Public ReadOnly Property SalesByCategory() As Table(Of SalesByCategory)
162 Get
163 Return Me.GetTable(Of SalesByCategory)()
164 End Get
165 End Property
166
167 Public ReadOnly Property SalesTotalsByAmount() As Table(Of SalesTotalsByAmount)
168 Get
169 Return Me.GetTable(Of SalesTotalsByAmount)()
170 End Get
171 End Property
172
173 Public ReadOnly Property Shippers() As Table(Of Shippers)
174 Get
175 Return Me.GetTable(Of Shippers)()
176 End Get
177 End Property
178
179 Public ReadOnly Property SummaryOfSalesByQuarter() As Table(Of SummaryOfSalesByQuarter)
180 Get
181 Return Me.GetTable(Of SummaryOfSalesByQuarter)()
182 End Get
183 End Property
184
185 Public ReadOnly Property SummaryOfSalesByYear() As Table(Of SummaryOfSalesByYear)
186 Get
187 Return Me.GetTable(Of SummaryOfSalesByYear)()
188 End Get
189 End Property
190
191 Public ReadOnly Property Suppliers() As Table(Of Suppliers)
192 Get
193 Return Me.GetTable(Of Suppliers)()
194 End Get
195 End Property
196
197 Public ReadOnly Property Territories() As Table(Of Territories)
198 Get
199 Return Me.GetTable(Of Territories)()
200 End Get
201 End Property
202
203 End Class
204
205 'View
206 <Serializable(), DataContract()> _
207 <TableName(Name:="Alphabetical list of products")> _
208 Partial Public Class AlphabeticalListOfProducts
209 Inherits EntityBase(Of AlphabeticalListOfProducts)
210
211 <DataMember()> _
212 Public ProductID As Integer
213
214 <DataMember()> _
215 Public ProductName As String
216
217 <Nullable(), DataMember()> _
218 Public SupplierID As Integer?
219
220 <Nullable(), DataMember()> _
221 Public CategoryID As Integer?
222
223 <Nullable(), DataMember()> _
224 Public QuantityPerUnit As String
225
226 <Nullable(), DataMember()> _
227 Public UnitPrice As Decimal?
228
229 <Nullable(), DataMember()> _
230 Public UnitsInStock As Short?
231
232 <Nullable(), DataMember()> _
233 Public UnitsOnOrder As Short?
234
235 <Nullable(), DataMember()> _
236 Public ReorderLevel As Short?
237
238 <DataMember()> _
239 Public Discontinued As Boolean
240
241 <DataMember()> _
242 Public CategoryName As String
243 End Class
244
245 <Serializable(), DataContract()> _
246 <TableName(Name:="Categories")> _
247 Partial Public Class Categories
248 Inherits EntityBase(Of Categories)
249
250 <Identity(), PrimaryKey(1), DataMember()> _
251 Public CategoryID As Integer
252
253 <DataMember()> _
254 Public CategoryName As String
255
256 <Nullable(), DataMember()> _
257 Public Description As String
258
259 <Nullable(), DataMember()> _
260 Public Picture As Byte()
261
262 ' FK_Products_Categories_BackReference
263 <Association(ThisKey:="CategoryID", OtherKey:="CategoryID")> _
264 Public Productss As IEnumerable(Of Products)
265 End Class
266
267 'View
268 <Serializable(), DataContract()> _
269 <TableName(Name:="Category Sales for 1997")> _
270 Partial Public Class CategorySalesFor1997
271 Inherits EntityBase(Of CategorySalesFor1997)
272
273 <DataMember()> _
274 Public CategoryName As String
275
276 <Nullable(), DataMember()> _
277 Public CategorySales As Decimal?
278 End Class
279
280 'View
281 <Serializable(), DataContract()> _
282 <TableName(Name:="Current Product List")> _
283 Partial Public Class CurrentProductList
284 Inherits EntityBase(Of CurrentProductList)
285
286 <Identity(), DataMember()> _
287 Public ProductID As Integer
288
289 <DataMember()> _
290 Public ProductName As String
291 End Class
292
293 'View
294 <Serializable(), DataContract()> _
295 <TableName(Name:="Customer and Suppliers by City")> _
296 Partial Public Class CustomerAndSuppliersByCity
297 Inherits EntityBase(Of CustomerAndSuppliersByCity)
298
299 <Nullable(), DataMember()> _
300 Public City As String
301
302 <DataMember()> _
303 Public CompanyName As String
304
305 <Nullable(), DataMember()> _
306 Public ContactName As String
307
308 <DataMember()> _
309 Public Relationship As String
310 End Class
311
312 <Serializable(), DataContract()> _
313 <TableName(Name:="CustomerCustomerDemo")> _
314 Partial Public Class CustomerCustomerDemo
315 Inherits EntityBase(Of CustomerCustomerDemo)
316
317 <PrimaryKey(1), DataMember()> _
318 Public CustomerID As String
319
320 <PrimaryKey(2), DataMember()> _
321 Public CustomerTypeID As String
322
323 ' FK_CustomerCustomerDemo
324 <Association(ThisKey:="CustomerTypeID", OtherKey:="CustomerTypeID")> _
325 Public FK_CustomerCustomerDemo As IEnumerable(Of CustomerDemographics)
326
327 ' FK_CustomerCustomerDemo_Customers
328 <Association(ThisKey:="CustomerID", OtherKey:="CustomerID")> _
329 Public Customers As IEnumerable(Of Customers)
330 End Class
331
332 <Serializable(), DataContract()> _
333 <TableName(Name:="CustomerDemographics")> _
334 Partial Public Class CustomerDemographics
335 Inherits EntityBase(Of CustomerDemographics)
336
337 <PrimaryKey(1), DataMember()> _
338 Public CustomerTypeID As String
339
340 <Nullable(), DataMember()> _
341 Public CustomerDesc As String
342
343 ' FK_CustomerCustomerDemo_BackReference
344 <Association(ThisKey:="CustomerTypeID", OtherKey:="CustomerTypeID")> _
345 Public CustomerCustomerDemos As IEnumerable(Of CustomerCustomerDemo)
346 End Class
347
348 <Serializable(), DataContract()> _
349 <TableName(Name:="Customers")> _
350 Partial Public Class Customers
351 Inherits EntityBase(Of Customers)
352
353 <PrimaryKey(1), DataMember()> _
354 Public CustomerID As String
355
356 <DataMember()> _
357 Public CompanyName As String
358
359 <Nullable(), DataMember()> _
360 Public ContactName As String
361
362 <Nullable(), DataMember()> _
363 Public ContactTitle As String
364
365 <Nullable(), DataMember()> _
366 Public Address As String
367
368 <Nullable(), DataMember()> _
369 Public City As String
370
371 <Nullable(), DataMember()> _
372 Public Region As String
373
374 <Nullable(), DataMember()> _
375 Public PostalCode As String
376
377 <Nullable(), DataMember()> _
378 Public Country As String
379
380 <Nullable(), DataMember()> _
381 Public Phone As String
382
383 <Nullable(), DataMember()> _
384 Public Fax As String
385
386 ' FK_Orders_Customers_BackReference
387 <Association(ThisKey:="CustomerID", OtherKey:="CustomerID")> _
388 Public Orderss As IEnumerable(Of Orders)
389
390 ' FK_CustomerCustomerDemo_Customers_BackReference
391 <Association(ThisKey:="CustomerID", OtherKey:="CustomerID")> _
392 Public CustomerCustomerDemos As IEnumerable(Of CustomerCustomerDemo)
393 End Class
394
395 <Serializable(), DataContract()> _
396 <TableName(Name:="Employees")> _
397 Partial Public Class Employees
398 Inherits EntityBase(Of Employees)
399
400 <Identity(), PrimaryKey(1), DataMember()> _
401 Public EmployeeID As Integer
402
403 <DataMember()> _
404 Public LastName As String
405
406 <DataMember()> _
407 Public FirstName As String
408
409 <Nullable(), DataMember()> _
410 Public Title As String
411
412 <Nullable(), DataMember()> _
413 Public TitleOfCourtesy As String
414
415 <Nullable(), DataMember()> _
416 Public BirthDate As DateTime?
417
418 <Nullable(), DataMember()> _
419 Public HireDate As DateTime?
420
421 <Nullable(), DataMember()> _
422 Public Address As String
423
424 <Nullable(), DataMember()> _
425 Public City As String
426
427 <Nullable(), DataMember()> _
428 Public Region As String
429
430 <Nullable(), DataMember()> _
431 Public PostalCode As String
432
433 <Nullable(), DataMember()> _
434 Public Country As String
435
436 <Nullable(), DataMember()> _
437 Public HomePhone As String
438
439 <Nullable(), DataMember()> _
440 Public Extension As String
441
442 <Nullable(), DataMember()> _
443 Public Photo As Byte()
444
445 <Nullable(), DataMember()> _
446 Public Notes As String
447
448 <Nullable(), DataMember()> _
449 Public ReportsTo As Integer?
450
451 <Nullable(), DataMember()> _
452 Public PhotoPath As String
453
454 ' FK_Employees_Employees
455 <Association(ThisKey:="ReportsTo", OtherKey:="EmployeeID")> _
456 Public ReportsToEmployee As IEnumerable(Of Employees)
457
458 ' FK_Orders_Employees_BackReference
459 <Association(ThisKey:="EmployeeID", OtherKey:="EmployeeID")> _
460 Public Orderss As IEnumerable(Of Orders)
461
462 ' FK_EmployeeTerritories_Employees_BackReference
463 <Association(ThisKey:="EmployeeID", OtherKey:="EmployeeID")> _
464 Public EmployeeTerritoriess As IEnumerable(Of EmployeeTerritories)
465
466 ' FK_Employees_Employees_BackReference
467 <Association(ThisKey:="EmployeeID", OtherKey:="ReportsTo")> _
468 Public FK_Employees_Employees_BackReference As IEnumerable(Of Employees)
469 End Class
470
471 <Serializable(), DataContract()> _
472 <TableName(Name:="EmployeeTerritories")> _
473 Partial Public Class EmployeeTerritories
474 Inherits EntityBase(Of EmployeeTerritories)
475
476 <PrimaryKey(1), DataMember()> _
477 Public EmployeeID As Integer
478
479 <PrimaryKey(2), DataMember()> _
480 Public TerritoryID As String
481
482 ' FK_EmployeeTerritories_Employees
483 <Association(ThisKey:="EmployeeID", OtherKey:="EmployeeID")> _
484 Public Employees As IEnumerable(Of Employees)
485
486 ' FK_EmployeeTerritories_Territories
487 <Association(ThisKey:="TerritoryID", OtherKey:="TerritoryID")> _
488 Public Territories As IEnumerable(Of Territories)
489 End Class
490
491 'View
492 <Serializable(), DataContract()> _
493 <TableName(Name:="Invoices")> _
494 Partial Public Class Invoices
495 Inherits EntityBase(Of Invoices)
496
497 <Nullable(), DataMember()> _
498 Public ShipName As String
499
500 <Nullable(), DataMember()> _
501 Public ShipAddress As String
502
503 <Nullable(), DataMember()> _
504 Public ShipCity As String
505
506 <Nullable(), DataMember()> _
507 Public ShipRegion As String
508
509 <Nullable(), DataMember()> _
510 Public ShipPostalCode As String
511
512 <Nullable(), DataMember()> _
513 Public ShipCountry As String
514
515 <Nullable(), DataMember()> _
516 Public CustomerID As String
517
518 <DataMember()> _
519 Public CustomerName As String
520
521 <Nullable(), DataMember()> _
522 Public Address As String
523
524 <Nullable(), DataMember()> _
525 Public City As String
526
527 <Nullable(), DataMember()> _
528 Public Region As String
529
530 <Nullable(), DataMember()> _
531 Public PostalCode As String
532
533 <Nullable(), DataMember()> _
534 Public Country As String
535
536 <DataMember()> _
537 Public Salesperson As String
538
539 <DataMember()> _
540 Public OrderID As Integer
541
542 <Nullable(), DataMember()> _
543 Public OrderDate As DateTime?
544
545 <Nullable(), DataMember()> _
546 Public RequiredDate As DateTime?
547
548 <Nullable(), DataMember()> _
549 Public ShippedDate As DateTime?
550
551 <DataMember()> _
552 Public ShipperName As String
553
554 <DataMember()> _
555 Public ProductID As Integer
556
557 <DataMember()> _
558 Public ProductName As String
559
560 <DataMember()> _
561 Public UnitPrice As Decimal
562
563 <DataMember()> _
564 Public Quantity As Short
565
566 <DataMember()> _
567 Public Discount As Single
568
569 <Nullable(), DataMember()> _
570 Public ExtendedPrice As Decimal?
571
572 <Nullable(), DataMember()> _
573 Public Freight As Decimal?
574 End Class
575
576 <Serializable(), DataContract()> _
577 <TableName(Name:="Order Details")> _
578 Partial Public Class OrderDetails
579 Inherits EntityBase(Of OrderDetails)
580
581 <PrimaryKey(1), DataMember()> _
582 Public OrderID As Integer
583
584 <PrimaryKey(2), DataMember()> _
585 Public ProductID As Integer
586
587 <DataMember()> _
588 Public UnitPrice As Decimal
589
590 <DataMember()> _
591 Public Quantity As Short
592
593 <DataMember()> _
594 Public Discount As Single
595
596 ' FK_Order_Details_Orders
597 <Association(ThisKey:="OrderID", OtherKey:="OrderID")> _
598 Public OrderDetailsOrders As IEnumerable(Of Orders)
599
600 ' FK_Order_Details_Products
601 <Association(ThisKey:="ProductID", OtherKey:="ProductID")> _
602 Public OrderDetailsProducts As IEnumerable(Of Products)
603 End Class
604
605 'View
606 <Serializable(), DataContract()> _
607 <TableName(Name:="Order Details Extended")> _
608 Partial Public Class OrderDetailsExtended
609 Inherits EntityBase(Of OrderDetailsExtended)
610
611 <DataMember()> _
612 Public OrderID As Integer
613
614 <DataMember()> _
615 Public ProductID As Integer
616
617 <DataMember()> _
618 Public ProductName As String
619
620 <DataMember()> _
621 Public UnitPrice As Decimal
622
623 <DataMember()> _
624 Public Quantity As Short
625
626 <DataMember()> _
627 Public Discount As Single
628
629 <Nullable(), DataMember()> _
630 Public ExtendedPrice As Decimal?
631 End Class
632
633 'View
634 <Serializable(), DataContract()> _
635 <TableName(Name:="Order Subtotals")> _
636 Partial Public Class OrderSubtotals
637 Inherits EntityBase(Of OrderSubtotals)
638
639 <DataMember()> _
640 Public OrderID As Integer
641
642 <Nullable(), DataMember()> _
643 Public Subtotal As Decimal?
644 End Class
645
646 <Serializable(), DataContract()> _
647 <TableName(Name:="Orders")> _
648 Partial Public Class Orders
649 Inherits EntityBase(Of Orders)
650
651 <Identity(), PrimaryKey(1), DataMember()> _
652 Public OrderID As Integer
653
654 <Nullable(), DataMember()> _
655 Public CustomerID As String
656
657 <Nullable(), DataMember()> _
658 Public EmployeeID As Integer?
659
660 <Nullable(), DataMember()> _
661 Public OrderDate As DateTime?
662
663 <Nullable(), DataMember()> _
664 Public RequiredDate As DateTime?
665
666 <Nullable(), DataMember()> _
667 Public ShippedDate As DateTime?
668
669 <Nullable(), DataMember()> _
670 Public ShipVia As Integer?
671
672 <Nullable(), DataMember()> _
673 Public Freight As Decimal?
674
675 <Nullable(), DataMember()> _
676 Public ShipName As String
677
678 <Nullable(), DataMember()> _
679 Public ShipAddress As String
680
681 <Nullable(), DataMember()> _
682 Public ShipCity As String
683
684 <Nullable(), DataMember()> _
685 Public ShipRegion As String
686
687 <Nullable(), DataMember()> _
688 Public ShipPostalCode As String
689
690 <Nullable(), DataMember()> _
691 Public ShipCountry As String
692
693 ' FK_Orders_Customers
694 <Association(ThisKey:="CustomerID", OtherKey:="CustomerID")> _
695 Public Customers As IEnumerable(Of Customers)
696
697 ' FK_Orders_Employees
698 <Association(ThisKey:="EmployeeID", OtherKey:="EmployeeID")> _
699 Public Employees As IEnumerable(Of Employees)
700
701 ' FK_Orders_Shippers
702 <Association(ThisKey:="ShipVia", OtherKey:="ShipperID")> _
703 Public Shippers As IEnumerable(Of Shippers)
704
705 ' FK_Order_Details_Orders_BackReference
706 <Association(ThisKey:="OrderID", OtherKey:="OrderID")> _
707 Public OrderDetailss As IEnumerable(Of OrderDetails)
708 End Class
709
710 'View
711 <Serializable(), DataContract()> _
712 <TableName(Name:="Orders Qry")> _
713 Partial Public Class OrdersQry
714 Inherits EntityBase(Of OrdersQry)
715
716 <DataMember()> _
717 Public OrderID As Integer
718
719 <Nullable(), DataMember()> _
720 Public CustomerID As String
721
722 <Nullable(), DataMember()> _
723 Public EmployeeID As Integer?
724
725 <Nullable(), DataMember()> _
726 Public OrderDate As DateTime?
727
728 <Nullable(), DataMember()> _
729 Public RequiredDate As DateTime?
730
731 <Nullable(), DataMember()> _
732 Public ShippedDate As DateTime?
733
734 <Nullable(), DataMember()> _
735 Public ShipVia As Integer?
736
737 <Nullable(), DataMember()> _
738 Public Freight As Decimal?
739
740 <Nullable(), DataMember()> _
741 Public ShipName As String
742
743 <Nullable(), DataMember()> _
744 Public ShipAddress As String
745
746 <Nullable(), DataMember()> _
747 Public ShipCity As String
748
749 <Nullable(), DataMember()> _
750 Public ShipRegion As String
751
752 <Nullable(), DataMember()> _
753 Public ShipPostalCode As String
754
755 <Nullable(), DataMember()> _
756 Public ShipCountry As String
757
758 <DataMember()> _
759 Public CompanyName As String
760
761 <Nullable(), DataMember()> _
762 Public Address As String
763
764 <Nullable(), DataMember()> _
765 Public City As String
766
767 <Nullable(), DataMember()> _
768 Public Region As String
769
770 <Nullable(), DataMember()> _
771 Public PostalCode As String
772
773 <Nullable(), DataMember()> _
774 Public Country As String
775 End Class
776
777 'View
778 <Serializable(), DataContract()> _
779 <TableName(Name:="Product Sales for 1997")> _
780 Partial Public Class ProductSalesFor1997
781 Inherits EntityBase(Of ProductSalesFor1997)
782
783 <DataMember()> _
784 Public CategoryName As String
785
786 <DataMember()> _
787 Public ProductName As String
788
789 <Nullable(), DataMember()> _
790 Public ProductSales As Decimal?
791 End Class
792
793 <Serializable(), DataContract()> _
794 <TableName(Name:="Products")> _
795 Partial Public Class Products
796 Inherits EntityBase(Of Products)
797
798 <Identity(), PrimaryKey(1), DataMember()> _
799 Public ProductID As Integer
800
801 <DataMember()> _
802 Public ProductName As String
803
804 <Nullable(), DataMember()> _
805 Public SupplierID As Integer?
806
807 <Nullable(), DataMember()> _
808 Public CategoryID As Integer?
809
810 <Nullable(), DataMember()> _
811 Public QuantityPerUnit As String
812
813 <Nullable(), DataMember()> _
814 Public UnitPrice As Decimal?
815
816 <Nullable(), DataMember()> _
817 Public UnitsInStock As Short?
818
819 <Nullable(), DataMember()> _
820 Public UnitsOnOrder As Short?
821
822 <Nullable(), DataMember()> _
823 Public ReorderLevel As Short?
824
825 <DataMember()> _
826 Public Discontinued As Boolean
827
828 ' FK_Products_Categories
829 <Association(ThisKey:="CategoryID", OtherKey:="CategoryID")> _
830 Public Categories As IEnumerable(Of Categories)
831
832 ' FK_Products_Suppliers
833 <Association(ThisKey:="SupplierID", OtherKey:="SupplierID")> _
834 Public Suppliers As IEnumerable(Of Suppliers)
835
836 ' FK_Order_Details_Products_BackReference
837 <Association(ThisKey:="ProductID", OtherKey:="ProductID")> _
838 Public OrderDetailss As IEnumerable(Of OrderDetails)
839 End Class
840
841 'View
842 <Serializable(), DataContract()> _
843 <TableName(Name:="Products Above Average Price")> _
844 Partial Public Class ProductsAboveAveragePrice
845 Inherits EntityBase(Of ProductsAboveAveragePrice)
846
847 <DataMember()> _
848 Public ProductName As String
849
850 <Nullable(), DataMember()> _
851 Public UnitPrice As Decimal?
852 End Class
853
854 'View
855 <Serializable(), DataContract()> _
856 <TableName(Name:="Products by Category")> _
857 Partial Public Class ProductsByCategory
858 Inherits EntityBase(Of ProductsByCategory)
859
860 <DataMember()> _
861 Public CategoryName As String
862
863 <DataMember()> _
864 Public ProductName As String
865
866 <Nullable(), DataMember()> _
867 Public QuantityPerUnit As String
868
869 <Nullable(), DataMember()> _
870 Public UnitsInStock As Short?
871
872 <DataMember()> _
873 Public Discontinued As Boolean
874 End Class
875
876 'View
877 <Serializable(), DataContract()> _
878 <TableName(Name:="Quarterly Orders")> _
879 Partial Public Class QuarterlyOrders
880 Inherits EntityBase(Of QuarterlyOrders)
881
882 <Nullable(), DataMember()> _
883 Public CustomerID As String
884
885 <Nullable(), DataMember()> _
886 Public CompanyName As String
887
888 <Nullable(), DataMember()> _
889 Public City As String
890
891 <Nullable(), DataMember()> _
892 Public Country As String
893 End Class
894
895 <Serializable(), DataContract()> _
896 <TableName(Name:="Region")> _
897 Partial Public Class Region
898 Inherits EntityBase(Of Region)
899
900 <MapField("RegionID"), PrimaryKey(1), DataMember()> _
901 Public ID As Integer
902
903 <DataMember()> _
904 Public RegionDescription As String
905
906 ' FK_Territories_Region_BackReference
907 <Association(ThisKey:="ID", OtherKey:="RegionID")> _
908 Public Territoriess As IEnumerable(Of Territories)
909 End Class
910
911 'View
912 <Serializable(), DataContract()> _
913 <TableName(Name:="Sales by Category")> _
914 Partial Public Class SalesByCategory
915 Inherits EntityBase(Of SalesByCategory)
916
917 <DataMember()> _
918 Public CategoryID As Integer
919
920 <DataMember()> _
921 Public CategoryName As String
922
923 <DataMember()> _
924 Public ProductName As String
925
926 <Nullable(), DataMember()> _
927 Public ProductSales As Decimal?
928 End Class
929
930 'View
931 <Serializable(), DataContract()> _
932 <TableName(Name:="Sales Totals by Amount")> _
933 Partial Public Class SalesTotalsByAmount
934 Inherits EntityBase(Of SalesTotalsByAmount)
935
936 <Nullable(), DataMember()> _
937 Public SaleAmount As Decimal?
938
939 <DataMember()> _
940 Public OrderID As Integer
941
942 <DataMember()> _
943 Public CompanyName As String
944
945 <Nullable(), DataMember()> _
946 Public ShippedDate As DateTime?
947 End Class
948
949 <Serializable(), DataContract()> _
950 <TableName(Name:="Shippers")> _
951 Partial Public Class Shippers
952 Inherits EntityBase(Of Shippers)
953
954 <Identity(), PrimaryKey(1), DataMember()> _
955 Public ShipperID As Integer
956
957 <DataMember()> _
958 Public CompanyName As String
959
960 <Nullable(), DataMember()> _
961 Public Phone As String
962
963 ' FK_Orders_Shippers_BackReference
964 <Association(ThisKey:="ShipperID", OtherKey:="ShipVia")> _
965 Public Orderss As IEnumerable(Of Orders)
966 End Class
967
968 'View
969 <Serializable(), DataContract()> _
970 <TableName(Name:="Summary of Sales by Quarter")> _
971 Partial Public Class SummaryOfSalesByQuarter
972 Inherits EntityBase(Of SummaryOfSalesByQuarter)
973
974 <Nullable(), DataMember()> _
975 Public ShippedDate As DateTime?
976
977 <DataMember()> _
978 Public OrderID As Integer
979
980 <Nullable(), DataMember()> _
981 Public Subtotal As Decimal?
982 End Class
983
984 'View
985 <Serializable(), DataContract()> _
986 <TableName(Name:="Summary of Sales by Year")> _
987 Partial Public Class SummaryOfSalesByYear
988 Inherits EntityBase(Of SummaryOfSalesByYear)
989
990 <Nullable(), DataMember()> _
991 Public ShippedDate As DateTime?
992
993 <DataMember()> _
994 Public OrderID As Integer
995
996 <Nullable(), DataMember()> _
997 Public Subtotal As Decimal?
998 End Class
999
1000 <Serializable(), DataContract()> _
1001 <TableName(Name:="Suppliers")> _
1002 Partial Public Class Suppliers
1003 Inherits EntityBase(Of Suppliers)
1004
1005 <Identity(), PrimaryKey(1), DataMember()> _
1006 Public SupplierID As Integer
1007
1008 <DataMember()> _
1009 Public CompanyName As String
1010
1011 <Nullable(), DataMember()> _
1012 Public ContactName As String
1013
1014 <Nullable(), DataMember()> _
1015 Public ContactTitle As String
1016
1017 <Nullable(), DataMember()> _
1018 Public Address As String
1019
1020 <Nullable(), DataMember()> _
1021 Public City As String
1022
1023 <Nullable(), DataMember()> _
1024 Public Region As String
1025
1026 <Nullable(), DataMember()> _
1027 Public PostalCode As String
1028
1029 <Nullable(), DataMember()> _
1030 Public Country As String
1031
1032 <Nullable(), DataMember()> _
1033 Public Phone As String
1034
1035 <Nullable(), DataMember()> _
1036 Public Fax As String
1037
1038 <Nullable(), DataMember()> _
1039 Public HomePage As String
1040
1041 ' FK_Products_Suppliers_BackReference
1042 <Association(ThisKey:="SupplierID", OtherKey:="SupplierID")> _
1043 Public Productss As IEnumerable(Of Products)
1044 End Class
1045
1046 <Serializable(), DataContract()> _
1047 <TableName(Name:="Territories")> _
1048 Partial Public Class Territories
1049 Inherits EntityBase(Of Territories)
1050
1051 <PrimaryKey(1), DataMember()> _
1052 Public TerritoryID As String
1053
1054 <DataMember()> _
1055 Public TerritoryDescription As String
1056
1057 <DataMember()> _
1058 Public RegionID As Integer
1059
1060 ' FK_Territories_Region
1061 <Association(ThisKey:="RegionID", OtherKey:="ID")> _
1062 Public Region As IEnumerable(Of Region)
1063
1064 ' FK_EmployeeTerritories_Territories_BackReference
1065 <Association(ThisKey:="TerritoryID", OtherKey:="TerritoryID")> _
1066 Public EmployeeTerritoriess As IEnumerable(Of EmployeeTerritories)
1067 End Class
1068
1069 End Namespace