dataset.cs

客户关系管理系统ASP.NET+VB.NET编程完整程序！

//------------------------------------------------------------------------------
// <autogenerated>
//     This code was generated by a tool.
//
//     Changes to this file may cause incorrect behavior and will be lost if 
//     the code is regenerated.
// </autogenerated>
//------------------------------------------------------------------------------
using System;
using System.Data;
using System.Data.SqlTypes;
using System.Runtime.Serialization;

namespace ORMBiz
{
	/// <summary>
	/// Wraps DataSet, creating all Tables, Columns, Constraints and Relations
	/// </summary>
	public class OrmDataSet
	{
		private OrmDataSet(){}

		/// <summary>
		/// Creates a DataSet with representing the databases schema
		/// </summary>
		/// <returns></returns>
		public static DataSet NewDataSet()
		{
			DataSet ds = new DataSet("OrmDataSet");

			try
			{
				InitDb(ds);
			}
			catch(Exception ex)
			{
				throw new Exception("An invalid DataSet was detected.", ex);
			}

			ds.EnforceConstraints = true;
			ds.CaseSensitive = false;

			return ds;
		}
		
		private static void InitDb(DataSet ds)
		{
			
			DataTable ColumnTable = ds.Tables.Add("Column");
			ColumnTable.Columns.Add("ID", typeof(System.Int32));
			ColumnTable.Columns["ID"].AllowDBNull = false;
			ColumnTable.Columns["ID"].ReadOnly = true;
			ColumnTable.Columns.Add("FKTableID", typeof(System.Int32));
			ColumnTable.Columns["FKTableID"].AllowDBNull = true;
			ColumnTable.Columns["FKTableID"].ReadOnly = false;
			ColumnTable.Columns.Add("Name", typeof(System.String));
			ColumnTable.Columns["Name"].AllowDBNull = true;
			ColumnTable.Columns["Name"].ReadOnly = false;
			ColumnTable.Columns["Name"].MaxLength = 200;

			ColumnTable.Columns.Add("FKDataTypeID", typeof(System.Int32));
			ColumnTable.Columns["FKDataTypeID"].AllowDBNull = true;
			ColumnTable.Columns["FKDataTypeID"].ReadOnly = false;
			ColumnTable.Columns.Add("Length", typeof(System.Int32));
			ColumnTable.Columns["Length"].AllowDBNull = true;
			ColumnTable.Columns["Length"].ReadOnly = false;
			ColumnTable.Columns.Add("PrimaryKey", typeof(System.String));
			ColumnTable.Columns["PrimaryKey"].AllowDBNull = true;
			ColumnTable.Columns["PrimaryKey"].ReadOnly = false;
			ColumnTable.Columns["PrimaryKey"].MaxLength = 5;

			ColumnTable.Columns.Add("SetAccessor", typeof(System.String));
			ColumnTable.Columns["SetAccessor"].AllowDBNull = true;
			ColumnTable.Columns["SetAccessor"].ReadOnly = false;
			ColumnTable.Columns["SetAccessor"].MaxLength = 50;

			ColumnTable.Columns.Add("GetAccessor", typeof(System.String));
			ColumnTable.Columns["GetAccessor"].AllowDBNull = true;
			ColumnTable.Columns["GetAccessor"].ReadOnly = false;
			ColumnTable.Columns["GetAccessor"].MaxLength = 50;

			ColumnTable.Columns.Add("RequiredForInstantiation", typeof(System.String));
			ColumnTable.Columns["RequiredForInstantiation"].AllowDBNull = true;
			ColumnTable.Columns["RequiredForInstantiation"].ReadOnly = false;
			ColumnTable.Columns["RequiredForInstantiation"].MaxLength = 5;

			ColumnTable.Columns.Add("AccessorName", typeof(System.String));
			ColumnTable.Columns["AccessorName"].AllowDBNull = true;
			ColumnTable.Columns["AccessorName"].ReadOnly = false;
			ColumnTable.Columns["AccessorName"].MaxLength = 100;

			ColumnTable.Columns.Add("Nullable", typeof(System.String));
			ColumnTable.Columns["Nullable"].AllowDBNull = false;
			ColumnTable.Columns["Nullable"].ReadOnly = false;
			ColumnTable.Columns["Nullable"].MaxLength = 5;

			ColumnTable.Columns.Add("IsIdentity", typeof(System.String));
			ColumnTable.Columns["IsIdentity"].AllowDBNull = true;
			ColumnTable.Columns["IsIdentity"].ReadOnly = false;
			ColumnTable.Columns["IsIdentity"].MaxLength = 5;

			ColumnTable.Columns.Add("IsReadOnly", typeof(System.String));
			ColumnTable.Columns["IsReadOnly"].AllowDBNull = true;
			ColumnTable.Columns["IsReadOnly"].ReadOnly = false;
			ColumnTable.Columns["IsReadOnly"].MaxLength = 5;

			ColumnTable.Columns.Add("DeclaredType", typeof(System.String));
			ColumnTable.Columns["DeclaredType"].AllowDBNull = true;
			ColumnTable.Columns["DeclaredType"].ReadOnly = false;
			ColumnTable.Columns["DeclaredType"].MaxLength = 100;

			ColumnTable.Columns.Add("Precision", typeof(System.Int32));
			ColumnTable.Columns["Precision"].AllowDBNull = true;
			ColumnTable.Columns["Precision"].ReadOnly = false;
			ColumnTable.PrimaryKey = new DataColumn[]{ColumnTable.Columns["ID"]};
			ColumnTable.PrimaryKey[0].AutoIncrement = true;
			ColumnTable.PrimaryKey[0].AutoIncrementSeed = -1000000;
			ColumnTable.PrimaryKey[0].AutoIncrementStep = -1;
						
			DataTable DatabaseTable = ds.Tables.Add("Database");
			DatabaseTable.Columns.Add("ID", typeof(System.Int32));
			DatabaseTable.Columns["ID"].AllowDBNull = false;
			DatabaseTable.Columns["ID"].ReadOnly = true;
			DatabaseTable.Columns.Add("DatabaseName", typeof(System.String));
			DatabaseTable.Columns["DatabaseName"].AllowDBNull = true;
			DatabaseTable.Columns["DatabaseName"].ReadOnly = false;
			DatabaseTable.Columns["DatabaseName"].MaxLength = 100;

			DatabaseTable.Columns.Add("DatabaseToken", typeof(System.String));
			DatabaseTable.Columns["DatabaseToken"].AllowDBNull = true;
			DatabaseTable.Columns["DatabaseToken"].ReadOnly = false;
			DatabaseTable.Columns["DatabaseToken"].MaxLength = 100;

			DatabaseTable.PrimaryKey = new DataColumn[]{DatabaseTable.Columns["ID"]};
			DatabaseTable.PrimaryKey[0].AutoIncrement = true;
			DatabaseTable.PrimaryKey[0].AutoIncrementSeed = -1000000;
			DatabaseTable.PrimaryKey[0].AutoIncrementStep = -1;
						
			DataTable DataTypeTable = ds.Tables.Add("DataType");
			DataTypeTable.Columns.Add("ID", typeof(System.Int32));
			DataTypeTable.Columns["ID"].AllowDBNull = false;
			DataTypeTable.Columns["ID"].ReadOnly = true;
			DataTypeTable.Columns.Add("SqlType", typeof(System.String));
			DataTypeTable.Columns["SqlType"].AllowDBNull = true;
			DataTypeTable.Columns["SqlType"].ReadOnly = false;
			DataTypeTable.Columns["SqlType"].MaxLength = 50;

			DataTypeTable.Columns.Add("NetType", typeof(System.String));
			DataTypeTable.Columns["NetType"].AllowDBNull = true;
			DataTypeTable.Columns["NetType"].ReadOnly = false;
			DataTypeTable.Columns["NetType"].MaxLength = 50;

			DataTypeTable.Columns.Add("XmlType", typeof(System.String));
			DataTypeTable.Columns["XmlType"].AllowDBNull = true;
			DataTypeTable.Columns["XmlType"].ReadOnly = false;
			DataTypeTable.Columns["XmlType"].MaxLength = 50;

			DataTypeTable.Columns.Add("NetSqlType", typeof(System.String));
			DataTypeTable.Columns["NetSqlType"].AllowDBNull = true;
			DataTypeTable.Columns["NetSqlType"].ReadOnly = false;
			DataTypeTable.Columns["NetSqlType"].MaxLength = 50;

			DataTypeTable.Columns.Add("SqlDbType", typeof(System.String));
			DataTypeTable.Columns["SqlDbType"].AllowDBNull = true;
			DataTypeTable.Columns["SqlDbType"].ReadOnly = false;
			DataTypeTable.Columns["SqlDbType"].MaxLength = 50;

			DataTypeTable.Columns.Add("OracleDbType", typeof(System.String));
			DataTypeTable.Columns["OracleDbType"].AllowDBNull = true;
			DataTypeTable.Columns["OracleDbType"].ReadOnly = false;
			DataTypeTable.Columns["OracleDbType"].MaxLength = 50;

			DataTypeTable.Columns.Add("OracleType", typeof(System.String));
			DataTypeTable.Columns["OracleType"].AllowDBNull = true;
			DataTypeTable.Columns["OracleType"].ReadOnly = false;
			DataTypeTable.Columns["OracleType"].MaxLength = 50;

			DataTypeTable.PrimaryKey = new DataColumn[]{DataTypeTable.Columns["ID"]};
			DataTypeTable.PrimaryKey[0].AutoIncrement = true;
			DataTypeTable.PrimaryKey[0].AutoIncrementSeed = -1000000;
			DataTypeTable.PrimaryKey[0].AutoIncrementStep = -1;
						
			DataTable ParamTable = ds.Tables.Add("Param");
			ParamTable.Columns.Add("ID", typeof(System.Int32));
			ParamTable.Columns["ID"].AllowDBNull = false;
			ParamTable.Columns["ID"].ReadOnly = true;
			ParamTable.Columns.Add("FKProcedureID", typeof(System.Int32));
			ParamTable.Columns["FKProcedureID"].AllowDBNull = true;
			ParamTable.Columns["FKProcedureID"].ReadOnly = false;
			ParamTable.Columns.Add("Name", typeof(System.String));
			ParamTable.Columns["Name"].AllowDBNull = true;
			ParamTable.Columns["Name"].ReadOnly = false;
			ParamTable.Columns["Name"].MaxLength = 200;

			ParamTable.Columns.Add("FKDataTypeID", typeof(System.Int32));
			ParamTable.Columns["FKDataTypeID"].AllowDBNull = true;
			ParamTable.Columns["FKDataTypeID"].ReadOnly = false;
			ParamTable.Columns.Add("Length", typeof(System.Int32));
			ParamTable.Columns["Length"].AllowDBNull = true;
			ParamTable.Columns["Length"].ReadOnly = false;
			ParamTable.Columns.Add("IsOutputParam", typeof(System.String));
			ParamTable.Columns["IsOutputParam"].AllowDBNull = true;
			ParamTable.Columns["IsOutputParam"].ReadOnly = false;
			ParamTable.Columns["IsOutputParam"].MaxLength = 5;

			ParamTable.PrimaryKey = new DataColumn[]{ParamTable.Columns["ID"]};
			ParamTable.PrimaryKey[0].AutoIncrement = true;
			ParamTable.PrimaryKey[0].AutoIncrementSeed = -1000000;
			ParamTable.PrimaryKey[0].AutoIncrementStep = -1;
						
			DataTable ProcedureTable = ds.Tables.Add("Procedure");
			ProcedureTable.Columns.Add("ID", typeof(System.Int32));
			ProcedureTable.Columns["ID"].AllowDBNull = false;
			ProcedureTable.Columns["ID"].ReadOnly = true;
			ProcedureTable.Columns.Add("Name", typeof(System.String));
			ProcedureTable.Columns["Name"].AllowDBNull = true;
			ProcedureTable.Columns["Name"].ReadOnly = false;
			ProcedureTable.Columns["Name"].MaxLength = 200;

			ProcedureTable.Columns.Add("FKDatabaseID", typeof(System.Int32));
			ProcedureTable.Columns["FKDatabaseID"].AllowDBNull = true;
			ProcedureTable.Columns["FKDatabaseID"].ReadOnly = false;
			ProcedureTable.PrimaryKey = new DataColumn[]{ProcedureTable.Columns["ID"]};
			ProcedureTable.PrimaryKey[0].AutoIncrement = true;
			ProcedureTable.PrimaryKey[0].AutoIncrementSeed = -1000000;
			ProcedureTable.PrimaryKey[0].AutoIncrementStep = -1;
						
			DataTable RelationTable = ds.Tables.Add("Relation");
			RelationTable.Columns.Add("ID", typeof(System.Int32));
			RelationTable.Columns["ID"].AllowDBNull = false;