Mercurial > pub > bltoolkit
diff Tools/Templates/SybaseDataModel.generated.cs @ 0:f990fcb411a9
Копия текущей версии из github
| author | cin |
|---|---|
| date | Thu, 27 Mar 2014 21:46:09 +0400 |
| parents | |
| children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/Tools/Templates/SybaseDataModel.generated.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,175 @@ +//--------------------------------------------------------------------------------------------------- +// <auto-generated> +// This code was generated by BLToolkit template for T4. +// Changes to this file may cause incorrect behavior and will be lost if the code is regenerated. +// </auto-generated> +//--------------------------------------------------------------------------------------------------- +using System; + +using BLToolkit.Data; +using BLToolkit.Data.Linq; +using BLToolkit.DataAccess; +using BLToolkit.Mapping; +using BLToolkit.Validation; + +namespace SybaseDataModel +{ + public partial class SybaseDataContext : DbManager + { + public Table<BinaryData> BinaryData { get { return this.GetTable<BinaryData>(); } } + public Table<Child> Child { get { return this.GetTable<Child>(); } } + public Table<DataTypeTest> DataTypeTest { get { return this.GetTable<DataTypeTest>(); } } + public Table<Doctor> Doctor { get { return this.GetTable<Doctor>(); } } + public Table<GrandChild> GrandChild { get { return this.GetTable<GrandChild>(); } } + public Table<LinqDataTypes> LinqDataTypes { get { return this.GetTable<LinqDataTypes>(); } } + public Table<Parent> Parent { get { return this.GetTable<Parent>(); } } + public Table<Patient> Patient { get { return this.GetTable<Patient>(); } } + public Table<Person> Person { get { return this.GetTable<Person>(); } } + public Table<sysquerymetrics> sysquerymetrics { get { return this.GetTable<sysquerymetrics>(); } } + public Table<TestIdentity> TestIdentity { get { return this.GetTable<TestIdentity>(); } } + } + + [TableName(Name="BinaryData")] + public partial class BinaryData + { + [Identity, PrimaryKey(1), Required] public int BinaryDataID { get; set; } // int(4) + [ Required] public byte[] Stamp { get; set; } // timestamp(8) + [ Required] public byte[] Data { get; set; } // varbinary(1024) + } + + [TableName(Name="Child")] + public partial class Child + { + [Required] public int ParentID { get; set; } // int(4) + [Required] public int ChildID { get; set; } // int(4) + } + + [TableName(Name="DataTypeTest")] + public partial class DataTypeTest + { + [Identity, PrimaryKey(1), Required ] public int DataTypeID { get; set; } // int(4) + [Nullable ] public byte[] Binary_ { get; set; } // binary(50) + [ Required ] public bool Boolean_ { get; set; } // bit(1) + [Nullable ] public byte? Byte_ { get; set; } // tinyint(1) + [Nullable ] public byte[] Bytes_ { get; set; } // varbinary(50) + [Nullable ] public char? Char_ { get; set; } // char(1) + [Nullable ] public DateTime? DateTime_ { get; set; } // datetime(8) + [Nullable ] public decimal? Decimal_ { get; set; } // decimal(10)(20,2) + [Nullable ] public double? Double_ { get; set; } // float(8) + [Nullable ] public byte[] Guid_ { get; set; } // varbinary(16) + [Nullable ] public short? Int16_ { get; set; } // smallint(2) + [Nullable ] public int? Int32_ { get; set; } // int(4) + [Nullable ] public long? Int64_ { get; set; } // bigint(8) + [Nullable ] public decimal? Money_ { get; set; } // money(8) + [Nullable ] public byte? SByte_ { get; set; } // tinyint(1) + [Nullable ] public float? Single_ { get; set; } // real(4) + [Nullable ] public byte[] Stream_ { get; set; } // varbinary(50) + [Nullable, MaxLength( 50)] public string String_ { get; set; } // nvarchar(50) + [Nullable ] public short? UInt16_ { get; set; } // smallint(2) + [Nullable ] public int? UInt32_ { get; set; } // int(4) + [Nullable ] public long? UInt64_ { get; set; } // bigint(8) + [Nullable, MaxLength(1000)] public string Xml_ { get; set; } // nvarchar(1000) + } + + [TableName(Name="Doctor")] + public partial class Doctor + { + [PrimaryKey(1), Required ] public int PersonID { get; set; } // int(4) + [ MaxLength(50), Required] public string Taxonomy { get; set; } // nvarchar(50) + + // FK_Doctor_Person + [Association(ThisKey="PersonID", OtherKey="PersonID", CanBeNull=false)] + public Person Person { get; set; } + } + + [TableName(Name="GrandChild")] + public partial class GrandChild + { + [Required] public int ParentID { get; set; } // int(4) + [Required] public int ChildID { get; set; } // int(4) + [Required] public int GrandChildID { get; set; } // int(4) + } + + [TableName(Name="LinqDataTypes")] + public partial class LinqDataTypes + { + [ Required ] public int ID { get; set; } // int(4) + [Nullable ] public decimal? MoneyValue { get; set; } // decimal(6)(10,4) + [Nullable ] public DateTime? DateTimeValue { get; set; } // datetime(8) + [Nullable ] public DateTime? DateTimeValue2 { get; set; } // datetime(8) + [ Required ] public bool BoolValue { get; set; } // bit(1) + [Nullable, MaxLength(36)] public string GuidValue { get; set; } // char(36) + [Nullable ] public byte[] BinaryValue { get; set; } // binary(500) + [Nullable ] public short? SmallIntValue { get; set; } // smallint(2) + [Nullable ] public int? IntValue { get; set; } // int(4) + [Nullable ] public long? BigIntValue { get; set; } // bigint(8) + } + + [TableName(Name="Parent")] + public partial class Parent + { + [ Required] public int ParentID { get; set; } // int(4) + [Nullable ] public int? Value1 { get; set; } // int(4) + } + + [TableName(Name="Patient")] + public partial class Patient + { + [PrimaryKey(1), Required ] public int PersonID { get; set; } // int(4) + [ MaxLength(256), Required] public string Diagnosis { get; set; } // nvarchar(256) + + // FK_Patient_Person + [Association(ThisKey="PersonID", OtherKey="PersonID", CanBeNull=false)] + public Person Person { get; set; } + } + + [TableName(Name="Person")] + public partial class Person + { + [Identity, PrimaryKey(1), Required ] public int PersonID { get; set; } // int(4) + [ MaxLength(50), Required] public string FirstName { get; set; } // nvarchar(50) + [ MaxLength(50), Required] public string LastName { get; set; } // nvarchar(50) + [Nullable, MaxLength(50) ] public string MiddleName { get; set; } // nvarchar(50) + [ Required ] public char Gender { get; set; } // char(1) + + // FK_Doctor_Person_BackReference + [Association(ThisKey="PersonID", OtherKey="PersonID", CanBeNull=true)] + public Doctor Doctor { get; set; } + + // FK_Patient_Person_BackReference + [Association(ThisKey="PersonID", OtherKey="PersonID", CanBeNull=true)] + public Patient Patient { get; set; } + } + + // View + [TableName(Name="sysquerymetrics")] + public partial class sysquerymetrics + { + [ Required ] public int uid { get; set; } // int(4) + [ Required ] public int gid { get; set; } // int(4) + [ Required ] public int hashkey { get; set; } // int(4) + [ Required ] public int id { get; set; } // int(4) + [ Required ] public short sequence { get; set; } // smallint(2) + [Nullable ] public int? exec_min { get; set; } // int(4) + [Nullable ] public int? exec_max { get; set; } // int(4) + [Nullable ] public int? exec_avg { get; set; } // int(4) + [Nullable ] public int? elap_min { get; set; } // int(4) + [Nullable ] public int? elap_max { get; set; } // int(4) + [Nullable ] public int? elap_avg { get; set; } // int(4) + [Nullable ] public int? lio_min { get; set; } // int(4) + [Nullable ] public int? lio_max { get; set; } // int(4) + [Nullable ] public int? lio_avg { get; set; } // int(4) + [Nullable ] public int? pio_min { get; set; } // int(4) + [Nullable ] public int? pio_max { get; set; } // int(4) + [Nullable ] public int? pio_avg { get; set; } // int(4) + [Nullable ] public int? cnt { get; set; } // int(4) + [Nullable ] public int? abort_cnt { get; set; } // int(4) + [Nullable, MaxLength(255)] public string qtext { get; set; } // varchar(255) + } + + [TableName(Name="TestIdentity")] + public partial class TestIdentity + { + [Identity, PrimaryKey(1), Required] public int ID { get; set; } // int(4) + } +}