mcs/class/System.Data.Linq/examples/DbLinq.MySql.Example/nwind/Andrus.cs

   1 //#########################################################################\r
   2 //generated by MySqlMetal on 2008-Feb-11 - extracted from server localhost.\r
   3 //#########################################################################\r
   4 \r
   5 using System;\r
   6 using System.Diagnostics;\r
   7 using System.Collections.Generic;\r
   8 using System.Text;\r
   9 using System.Linq;\r
  10 //using System.Data.Linq;\r
  11 using System.Data.Linq.Mapping;\r
  12 using System.Reflection;\r
  13 using DBLinq.Linq;\r
  14 using DBLinq.Linq.Mapping;\r
  15 using DataContext = DBLinq.vendor.mysql.MysqlDataContext;\r
  16 \r
  17 \r
  18 namespace andrusDB\r
  19 {\r
  20     \r
  21         /// <summary>\r
  22         /// This class represents MySql database Andrus.\r
  23         /// </summary>\r
  24         public partial class Andrus : DataContext\r
  25         {\r
  26                 public Andrus(string connStr) \r
  27                         : base(connStr)\r
  28                 {\r
  29                 }\r
  30                 public Andrus(System.Data.IDbConnection connection) \r
  31                         : base(connection)\r
  32                 {\r
  33                 }\r
  34         \r
  35                 //these fields represent tables in database and are\r
  36                 //ordered - parent tables first, child tables next. Do not change the order.\r
  37                 public Table<T2> T2s { get { return base.GetTable<T2>("T2s"); } }\r
  38                 public Table<Tcompositepk> Tcompositepks { get { return base.GetTable<Tcompositepk>("Tcompositepks"); } }\r
  39                 public Table<T1> T1s { get { return base.GetTable<T1>("T1s"); } }\r
  40                 public Table<Char_Pk> Char_Pks { get { return base.GetTable<Char_Pk>("Char_Pks"); } }\r
  41                 public Table<Employee> Employees { get { return base.GetTable<Employee>("Employees"); } }\r
  42         \r
  43                 \r
  44         }\r
  45         \r
  46         \r
  47         \r
  48         [Table(Name = "t2")]\r
  49         public partial class T2 : IModified\r
  50         {\r
  51                 \r
  52                 protected int? _f1;\r
  53                 protected int? _f2;\r
  54         \r
  55                 \r
  56                 public T2()\r
  57                 {\r
  58                 }\r
  59                 \r
  60         \r
  61                 #region properties - accessors\r
  62         \r
  63                 [Column(Storage = "_f1", Name = "f1", DbType = "int", CanBeNull = true)]\r
  64                 [DebuggerNonUserCode]\r
  65                 public int? f1\r
  66                 {\r
  67                     get { return _f1; }\r
  68                     set { _f1 = value; IsModified = true; }\r
  69                 }\r
  70                 \r
  71         \r
  72                 [Column(Storage = "_f2", Name = "f2", DbType = "int", CanBeNull = true)]\r
  73                 [DebuggerNonUserCode]\r
  74                 public int? f2\r
  75                 {\r
  76                     get { return _f2; }\r
  77                     set { _f2 = value; IsModified = true; }\r
  78                 }\r
  79                 \r
  80         #endregion\r
  81                 #warning L189 table t2 has no primary key. Multiple c# objects will refer to the same row.\r
  82 \r
  83                 #region childtables\r
  84                 #endregion\r
  85                 #region parenttables\r
  86                 #endregion\r
  87         \r
  88                 public bool IsModified { get; set; }\r
  89         }\r
  90         \r
  91         \r
  92         \r
  93         [Table(Name = "tcompositepk")]\r
  94         public partial class Tcompositepk : IModified\r
  95         {\r
  96                 \r
  97                 protected int _f1;\r
  98                 protected string _f2;\r
  99                 protected int? _f3;\r
 100         \r
 101                 \r
 102                 public Tcompositepk()\r
 103                 {\r
 104                 }\r
 105                 \r
 106         \r
 107                 #region properties - accessors\r
 108         \r
 109                 [Column(Storage = "_f1", Name = "f1", DbType = "int", IsPrimaryKey = true)]\r
 110                 [DebuggerNonUserCode]\r
 111                 public int f1\r
 112                 {\r
 113                     get { return _f1; }\r
 114                     set { _f1 = value; IsModified = true; }\r
 115                 }\r
 116                 \r
 117         \r
 118                 [Column(Storage = "_f2", Name = "f2", DbType = "varchar(5)", IsPrimaryKey = true)]\r
 119                 [DebuggerNonUserCode]\r
 120                 public string f2\r
 121                 {\r
 122                     get { return _f2; }\r
 123                     set { _f2 = value; IsModified = true; }\r
 124                 }\r
 125                 \r
 126         \r
 127                 [Column(Storage = "_f3", Name = "f3", DbType = "int", CanBeNull = true)]\r
 128                 [DebuggerNonUserCode]\r
 129                 public int? f3\r
 130                 {\r
 131                     get { return _f3; }\r
 132                     set { _f3 = value; IsModified = true; }\r
 133                 }\r
 134                 \r
 135         #endregion\r
 136                 \r
 137                 #region GetHashCode(),Equals() - uses column $fieldID to look up objects in liveObjectMap\r
 138                 //TODO: move this logic our of user code, into a generated class\r
 139                 public override int GetHashCode()\r
 140                 {\r
 141                         return _f1.GetHashCode() ^ (_f2 == null ? 0 : _f2.GetHashCode());\r
 142                 }\r
 143                 public override bool Equals(object obj)\r
 144                 {\r
 145                         Tcompositepk o2 = obj as Tcompositepk;\r
 146                         if(o2==null)\r
 147                                 return false;\r
 148                         return _f1 == o2._f1 && object.Equals(_f2, o2._f2);\r
 149                 }\r
 150                 #endregion\r
 151         \r
 152                 #region childtables\r
 153                 #endregion\r
 154                 #region parenttables\r
 155                 #endregion\r
 156         \r
 157                 public bool IsModified { get; set; }\r
 158         }\r
 159         \r
 160         \r
 161         \r
 162         [Table(Name = "t1")]\r
 163         public partial class T1 : IModified\r
 164         {\r
 165                 \r
 166                 protected int _private;\r
 167         \r
 168                 \r
 169                 public T1()\r
 170                 {\r
 171                 }\r
 172                 \r
 173         \r
 174                 #region properties - accessors\r
 175         \r
 176                 [Column(Storage = "_private", Name = "private", DbType = "int", IsPrimaryKey = true)]\r
 177                 [DebuggerNonUserCode]\r
 178                 public int private_\r
 179                 {\r
 180                     get { return _private; }\r
 181                     set { _private = value; IsModified = true; }\r
 182                 }\r
 183                 \r
 184         #endregion\r
 185                 \r
 186                 #region GetHashCode(),Equals() - uses column $fieldID to look up objects in liveObjectMap\r
 187                 //TODO: move this logic our of user code, into a generated class\r
 188                 public override int GetHashCode()\r
 189                 {\r
 190                         return _private.GetHashCode();\r
 191                 }\r
 192                 public override bool Equals(object obj)\r
 193                 {\r
 194                         T1 o2 = obj as T1;\r
 195                         if(o2==null)\r
 196                                 return false;\r
 197                         return _private == o2._private;\r
 198                 }\r
 199                 #endregion\r
 200         \r
 201                 #region childtables\r
 202                 #endregion\r
 203                 #region parenttables\r
 204                 #endregion\r
 205         \r
 206                 public bool IsModified { get; set; }\r
 207         }\r
 208         \r
 209         \r
 210         \r
 211         [Table(Name = "char_pk")]\r
 212         public partial class Char_Pk : IModified\r
 213         {\r
 214                 \r
 215                 protected string _col1;\r
 216                 protected int? _val1;\r
 217         \r
 218                 \r
 219                 public Char_Pk()\r
 220                 {\r
 221                 }\r
 222                 \r
 223         \r
 224                 #region properties - accessors\r
 225         \r
 226                 [Column(Storage = "_col1", Name = "col1", DbType = "char(1)", IsPrimaryKey = true)]\r
 227                 [DebuggerNonUserCode]\r
 228                 public string col1\r
 229                 {\r
 230                     get { return _col1; }\r
 231                     set { _col1 = value; IsModified = true; }\r
 232                 }\r
 233                 \r
 234         \r
 235                 [Column(Storage = "_val1", Name = "val1", DbType = "int", CanBeNull = true)]\r
 236                 [DebuggerNonUserCode]\r
 237                 public int? val1\r
 238                 {\r
 239                     get { return _val1; }\r
 240                     set { _val1 = value; IsModified = true; }\r
 241                 }\r
 242                 \r
 243         #endregion\r
 244                 \r
 245                 #region GetHashCode(),Equals() - uses column $fieldID to look up objects in liveObjectMap\r
 246                 //TODO: move this logic our of user code, into a generated class\r
 247                 public override int GetHashCode()\r
 248                 {\r
 249                         return (_col1 == null ? 0 : _col1.GetHashCode());\r
 250                 }\r
 251                 public override bool Equals(object obj)\r
 252                 {\r
 253                         Char_Pk o2 = obj as Char_Pk;\r
 254                         if(o2==null)\r
 255                                 return false;\r
 256                         return object.Equals(_col1, o2._col1);\r
 257                 }\r
 258                 #endregion\r
 259         \r
 260                 #region childtables\r
 261                 #endregion\r
 262                 #region parenttables\r
 263                 #endregion\r
 264         \r
 265                 public bool IsModified { get; set; }\r
 266         }\r
 267         \r
 268         \r
 269         \r
 270         [Table(Name = "employee")]\r
 271         public partial class Employee : IModified\r
 272         {\r
 273                 [DBLinq.Linq.Mapping.AutoGenId] \r
 274                 protected int _employeeID;\r
 275                 protected int _employeeType;\r
 276                 protected string _employeeName;\r
 277                 protected DateTime? _startDate;\r
 278         \r
 279                 \r
 280                 public Employee()\r
 281                 {\r
 282                 }\r
 283                 \r
 284         \r
 285                 #region properties - accessors\r
 286         \r
 287                 [Column(Storage = "_employeeID", Name = "employeeID", DbType = "int", IsPrimaryKey = true, IsDbGenerated = true)]\r
 288                 [DebuggerNonUserCode]\r
 289                 public int employeeID\r
 290                 {\r
 291                     get { return _employeeID; }\r
 292                     set { _employeeID = value; IsModified = true; }\r
 293                 }\r
 294                 \r
 295         \r
 296                 [Column(Storage = "_employeeType", Name = "employeeType", DbType = "int", CanBeNull = false)]\r
 297                 [DebuggerNonUserCode]\r
 298                 public int employeeType\r
 299                 {\r
 300                     get { return _employeeType; }\r
 301                     set { _employeeType = value; IsModified = true; }\r
 302                 }\r
 303                 \r
 304         \r
 305                 [Column(Storage = "_employeeName", Name = "employeeName", DbType = "varchar(99)", CanBeNull = true)]\r
 306                 [DebuggerNonUserCode]\r
 307                 public string employeeName\r
 308                 {\r
 309                     get { return _employeeName; }\r
 310                     set { _employeeName = value; IsModified = true; }\r
 311                 }\r
 312                 \r
 313         \r
 314                 [Column(Storage = "_startDate", Name = "startDate", DbType = "date", CanBeNull = true)]\r
 315                 [DebuggerNonUserCode]\r
 316                 public DateTime? startDate\r
 317                 {\r
 318                     get { return _startDate; }\r
 319                     set { _startDate = value; IsModified = true; }\r
 320                 }\r
 321                 \r
 322         #endregion\r
 323                 \r
 324                 #region GetHashCode(),Equals() - uses column $fieldID to look up objects in liveObjectMap\r
 325                 //TODO: move this logic our of user code, into a generated class\r
 326                 public override int GetHashCode()\r
 327                 {\r
 328                         return _employeeID.GetHashCode();\r
 329                 }\r
 330                 public override bool Equals(object obj)\r
 331                 {\r
 332                         Employee o2 = obj as Employee;\r
 333                         if(o2==null)\r
 334                                 return false;\r
 335                         return _employeeID == o2._employeeID;\r
 336                 }\r
 337                 #endregion\r
 338         \r
 339                 #region childtables\r
 340                 #endregion\r
 341                 #region parenttables\r
 342                 #endregion\r
 343         \r
 344                 public bool IsModified { get; set; }\r
 345         }\r
 346         \r
 347 }\r