|
0
|
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 using System;
|
|
|
8
|
|
|
9 using BLToolkit.Data;
|
|
|
10 using BLToolkit.Data.Linq;
|
|
|
11 using BLToolkit.DataAccess;
|
|
|
12 using BLToolkit.Mapping;
|
|
|
13 using BLToolkit.Validation;
|
|
|
14
|
|
|
15 using NpgsqlTypes;
|
|
|
16
|
|
|
17 namespace PostgreSqlDataModel
|
|
|
18 {
|
|
|
19 public partial class PostgreSqlDataContext : DbManager
|
|
|
20 {
|
|
|
21 public Table<alltypes> alltypes { get { return this.GetTable<alltypes>(); } }
|
|
|
22 public Table<Child> Child { get { return this.GetTable<Child>(); } }
|
|
|
23 public Table<Doctor> Doctor { get { return this.GetTable<Doctor>(); } }
|
|
|
24 public Table<entity> entity { get { return this.GetTable<entity>(); } }
|
|
|
25 public Table<GrandChild> GrandChild { get { return this.GetTable<GrandChild>(); } }
|
|
|
26 public Table<LinqDataTypes> LinqDataTypes { get { return this.GetTable<LinqDataTypes>(); } }
|
|
|
27 public Table<Parent> Parent { get { return this.GetTable<Parent>(); } }
|
|
|
28 public Table<Patient> Patient { get { return this.GetTable<Patient>(); } }
|
|
|
29 public Table<Person> Person { get { return this.GetTable<Person>(); } }
|
|
|
30 public Table<SequenceTest1> SequenceTest1 { get { return this.GetTable<SequenceTest1>(); } }
|
|
|
31 public Table<SequenceTest2> SequenceTest2 { get { return this.GetTable<SequenceTest2>(); } }
|
|
|
32 public Table<SequenceTest3> SequenceTest3 { get { return this.GetTable<SequenceTest3>(); } }
|
|
|
33 public Table<TestIdentity> TestIdentity { get { return this.GetTable<TestIdentity>(); } }
|
|
|
34 }
|
|
|
35
|
|
|
36 [TableName(Owner="public", Name="alltypes")]
|
|
|
37 public partial class alltypes
|
|
|
38 {
|
|
|
39 [Identity, PrimaryKey(1), Required] public Int32 id { get; set; } // integer
|
|
|
40 [Nullable ] public Int64? bigintdatatype { get; set; } // bigint
|
|
|
41 [Nullable ] public Decimal? numericdatatype { get; set; } // numeric
|
|
|
42 [Nullable ] public Int16? smallintdatatype { get; set; } // smallint
|
|
|
43 [Nullable ] public Int32? intdatatype { get; set; } // integer
|
|
|
44 [Nullable ] public Decimal? moneydatatype { get; set; } // money
|
|
|
45 [Nullable ] public Double? doubledatatype { get; set; } // double precision
|
|
|
46 [Nullable ] public Single? realdatatype { get; set; } // real
|
|
|
47 [Nullable ] public DateTime? timestampdatatype { get; set; } // timestamp without time zone
|
|
|
48 [Nullable ] public DateTime? timestamptzdatatype { get; set; } // timestamp with time zone
|
|
|
49 [Nullable ] public DateTime? datedatatype { get; set; } // date
|
|
|
50 [Nullable ] public DateTime? timedatatype { get; set; } // time without time zone
|
|
|
51 [Nullable ] public DateTime? timetzdatatype { get; set; } // time with time zone
|
|
|
52 [Nullable ] public NpgsqlInterval? intervaldatatype { get; set; } // interval
|
|
|
53 [ Required] public String chardatatype { get; set; } // character(1)(1)
|
|
|
54 [ Required] public String varchardatatype { get; set; } // character varying(20)(20)
|
|
|
55 [ Required] public String textdatatype { get; set; } // text
|
|
|
56 [ Required] public Byte[] binarydatatype { get; set; } // bytea
|
|
|
57 [Nullable ] public Guid? uuiddatatype { get; set; } // uuid
|
|
|
58 [Nullable ] public BitString? bitdatatype { get; set; } // bit(3)(3)
|
|
|
59 [Nullable ] public Boolean? booleandatatype { get; set; } // boolean
|
|
|
60 [Nullable ] public object colordatatype { get; set; } // color
|
|
|
61 [Nullable ] public NpgsqlPoint? pointdatatype { get; set; } // point
|
|
|
62 [Nullable ] public NpgsqlLSeg? lsegdatatype { get; set; } // lseg
|
|
|
63 [Nullable ] public NpgsqlBox? boxdatatype { get; set; } // box
|
|
|
64 [Nullable ] public NpgsqlPath? pathdatatype { get; set; } // path
|
|
|
65 [Nullable ] public NpgsqlPolygon? polygondatatype { get; set; } // polygon
|
|
|
66 [Nullable ] public NpgsqlCircle? circledatatype { get; set; } // circle
|
|
|
67 [Nullable ] public NpgsqlInet? inetdatatype { get; set; } // inet
|
|
|
68 [Nullable ] public NpgsqlMacAddress? macaddrdatatype { get; set; } // macaddr
|
|
|
69 [Nullable ] public String xmldatatype { get; set; } // xml
|
|
|
70 }
|
|
|
71
|
|
|
72 [TableName(Owner="public", Name="Child")]
|
|
|
73 public partial class Child
|
|
|
74 {
|
|
|
75 [Nullable] public Int32? ParentID { get; set; } // integer
|
|
|
76 [Nullable] public Int32? ChildID { get; set; } // integer
|
|
|
77 }
|
|
|
78
|
|
|
79 [TableName(Owner="public", Name="Doctor")]
|
|
|
80 public partial class Doctor
|
|
|
81 {
|
|
|
82 [Required] public Int32 PersonID { get; set; } // integer
|
|
|
83 [Required] public String Taxonomy { get; set; } // character varying(50)(50)
|
|
|
84 }
|
|
|
85
|
|
|
86 [TableName(Owner="public", Name="entity")]
|
|
|
87 public partial class entity
|
|
|
88 {
|
|
|
89 [Required] public String the_name { get; set; } // character varying(255)(255)
|
|
|
90 }
|
|
|
91
|
|
|
92 [TableName(Owner="public", Name="GrandChild")]
|
|
|
93 public partial class GrandChild
|
|
|
94 {
|
|
|
95 [Nullable] public Int32? ParentID { get; set; } // integer
|
|
|
96 [Nullable] public Int32? ChildID { get; set; } // integer
|
|
|
97 [Nullable] public Int32? GrandChildID { get; set; } // integer
|
|
|
98 }
|
|
|
99
|
|
|
100 [TableName(Owner="public", Name="LinqDataTypes")]
|
|
|
101 public partial class LinqDataTypes
|
|
|
102 {
|
|
|
103 [Nullable ] public Int32? ID { get; set; } // integer
|
|
|
104 [Nullable ] public Decimal? MoneyValue { get; set; } // numeric(10,4)(10)(4)
|
|
|
105 [Nullable ] public DateTime? DateTimeValue { get; set; } // timestamp without time zone
|
|
|
106 [Nullable ] public DateTime? DateTimeValue2 { get; set; } // timestamp without time zone
|
|
|
107 [Nullable ] public Boolean? BoolValue { get; set; } // boolean
|
|
|
108 [Nullable ] public Guid? GuidValue { get; set; } // uuid
|
|
|
109 [ Required] public Byte[] BinaryValue { get; set; } // bytea
|
|
|
110 [Nullable ] public Int16? SmallIntValue { get; set; } // smallint
|
|
|
111 [Nullable ] public Int32? IntValue { get; set; } // integer
|
|
|
112 [Nullable ] public Int64? BigIntValue { get; set; } // bigint
|
|
|
113 }
|
|
|
114
|
|
|
115 [TableName(Owner="public", Name="Parent")]
|
|
|
116 public partial class Parent
|
|
|
117 {
|
|
|
118 [Nullable] public Int32? ParentID { get; set; } // integer
|
|
|
119 [Nullable] public Int32? Value1 { get; set; } // integer
|
|
|
120 }
|
|
|
121
|
|
|
122 [TableName(Owner="public", Name="Patient")]
|
|
|
123 public partial class Patient
|
|
|
124 {
|
|
|
125 [Required] public Int32 PersonID { get; set; } // integer
|
|
|
126 [Required] public String Diagnosis { get; set; } // character varying(256)(256)
|
|
|
127 }
|
|
|
128
|
|
|
129 [TableName(Owner="public", Name="Person")]
|
|
|
130 public partial class Person
|
|
|
131 {
|
|
|
132 [Identity, PrimaryKey(1), Required] public Int32 PersonID { get; set; } // integer
|
|
|
133 [ Required] public String FirstName { get; set; } // character varying(50)(50)
|
|
|
134 [ Required] public String LastName { get; set; } // character varying(50)(50)
|
|
|
135 [ Required] public String MiddleName { get; set; } // character varying(50)(50)
|
|
|
136 [ Required] public String Gender { get; set; } // character(1)(1)
|
|
|
137 }
|
|
|
138
|
|
|
139 [TableName(Owner="public", Name="SequenceTest1")]
|
|
|
140 public partial class SequenceTest1
|
|
|
141 {
|
|
|
142 [PrimaryKey(1), Required] public Int32 ID { get; set; } // integer
|
|
|
143 [ Required] public String Value { get; set; } // character varying(50)(50)
|
|
|
144 }
|
|
|
145
|
|
|
146 [TableName(Owner="public", Name="SequenceTest2")]
|
|
|
147 public partial class SequenceTest2
|
|
|
148 {
|
|
|
149 [Identity, PrimaryKey(1), Required] public Int32 ID { get; set; } // integer
|
|
|
150 [ Required] public String Value { get; set; } // character varying(50)(50)
|
|
|
151 }
|
|
|
152
|
|
|
153 [TableName(Owner="public", Name="SequenceTest3")]
|
|
|
154 public partial class SequenceTest3
|
|
|
155 {
|
|
|
156 [Identity, PrimaryKey(1), Required] public Int32 ID { get; set; } // integer
|
|
|
157 [ Required] public String Value { get; set; } // character varying(50)(50)
|
|
|
158 }
|
|
|
159
|
|
|
160 [TableName(Owner="public", Name="TestIdentity")]
|
|
|
161 public partial class TestIdentity
|
|
|
162 {
|
|
|
163 [Identity, PrimaryKey(1), Required] public Int32 ID { get; set; } // integer
|
|
|
164 }
|
|
|
165 }
|
