예제 #1
0
		public void AddTable(Table table)
		{
			Table[] tempReDim = new Table[_tables.Length+1];
			Array.Copy(_tables, tempReDim, _tables.Length);
			_tables = tempReDim;
			_tables[_tables.Length-1] = table;
		}
예제 #2
0
 internal DataAssembler(string domainUrl, Table table, string select)
     : base(table.Name + " Assembler")
 {
     _domainUrl = domainUrl;
     _select = select;
     _table = table;
 }
예제 #3
0
		public override DataDomain BuildDomain()
		{
			DataDomain domain = new DataDomain(this.Driver.DomainUrl);

			using(IDbConnection connection = this.Driver.OpenConnection() )
			{
				DataTable schemaTable = ((OleDbConnection)connection).GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[0]);
				DataColumn tableTypeColumn = schemaTable.Columns["TABLE_TYPE"];
				DataColumn tableNameColumn = schemaTable.Columns["TABLE_NAME"];

				foreach(DataRow schemaRowTable in schemaTable.Rows)
				{
					if (string.Compare(schemaRowTable[tableTypeColumn].ToString(), "TABLE") == 0)
					{
						string tableName = schemaRowTable[tableNameColumn].ToString();
						Table table = new Table(tableName);

						DataTable schemaColumns = ((OleDbConnection)connection).GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, tableName });
						DataColumn ordinalPosition = schemaColumns.Columns["ORDINAL_POSITION"];
						DataColumn dataType = schemaColumns.Columns["DATA_TYPE"];
						DataColumn columnNameColumn = schemaColumns.Columns["COLUMN_NAME"];
						DataColumn numericPrecisionColumn = schemaColumns.Columns["NUMERIC_PRECISION"];
						DataColumn allowDBNull = schemaColumns.Columns["IS_NULLABLE"];
						DataColumn columnSize = schemaColumns.Columns["CHARACTER_MAXIMUM_LENGTH"];
						DataColumn numericScale = schemaColumns.Columns["NUMERIC_SCALE"];
                        DataColumn descriptionColumn = schemaColumns.Columns["DESCRIPTION"];
						schemaColumns.DefaultView.Sort = ordinalPosition.ColumnName;
						foreach (DataRowView schemaRowColumn in schemaColumns.DefaultView)
						{
							string columnName = schemaRowColumn[columnNameColumn.Ordinal].ToString();

							Column column = new Column(columnName);
							column.IsNullable = (bool)schemaRowColumn[allowDBNull.Ordinal];
							OleDbType oleDbType = (OleDbType)schemaRowColumn[dataType.Ordinal];
							column.OriginalSQLType = oleDbType.ToString();

							if(_sqlTypesDictionary.Contains(oleDbType))
								column.SqlType = (SqlType)_sqlTypesDictionary[oleDbType];
							else
								column.SqlType = SqlType.Unknown;

                            if (_netDataTypes.ContainsKey(column.SqlType))
                            {
                                column.NetDataType = (string)_netDataTypes[column.SqlType];
                                column.ActionScriptType = TypeMapper.GetActionScriptType(_netDataTypes[column.SqlType] as string);
                            }
                            else
                                column.NetDataType = "unknown";

							if( schemaRowColumn[numericPrecisionColumn.Ordinal] != DBNull.Value )
								column.Length = Convert.ToInt32(schemaRowColumn[numericPrecisionColumn.Ordinal]);

							if((column.SqlType == SqlType.VarChar) || (column.SqlType == SqlType.VarBinary) || (column.SqlType == SqlType.Binary) )
							{
								column.Length = Convert.ToInt32(schemaRowColumn[columnSize.Ordinal]);
                                if (column.SqlType == SqlType.VarChar)
                                {
                                    column.SqlType = SqlType.Text;
                                    //column.Length = 0;
                                }
                                else
                                    column.IsBlob = true;
							}
							else if (column.SqlType == SqlType.Decimal)
							{
								column.Length = Convert.ToInt32(schemaRowColumn[numericPrecisionColumn.Ordinal]);
								column.Scale = Convert.ToInt32(schemaRowColumn[numericScale.Ordinal]);
							}

                            if (schemaRowColumn[descriptionColumn.Ordinal] != DBNull.Value)
                            {
                                string description = schemaRowColumn[descriptionColumn.Ordinal] as string;
                                if (description == "AutoNumber")
                                    column.IsIdentity = true;
                            }

							table.AddColumn(column);
						}

						DataTable schemaPrimaryKeys = ((OleDbConnection)connection).GetOleDbSchemaTable( OleDbSchemaGuid.Primary_Keys, new object [] { null, null, tableName});
						DataColumn pkColumnNameColumn = schemaColumns.Columns["COLUMN_NAME"];
						foreach (DataRowView schemaRowPK in schemaPrimaryKeys.DefaultView)
						{
							string columnName = (string)schemaRowPK[pkColumnNameColumn.Ordinal];
							Column column = table[ columnName ];
							if( column != null )
								column.IsPrimaryKey = true;
						}

						domain.AddTable(table);
					}
				}

				foreach(DataRow schemaRowTable in schemaTable.Rows)
				{
					if (string.Compare(schemaRowTable[tableTypeColumn].ToString(), "TABLE") == 0)
					{
						string tableName = schemaRowTable[tableNameColumn].ToString();

						DataTable schemaForeignKeys = ((OleDbConnection)connection).GetOleDbSchemaTable(OleDbSchemaGuid.Foreign_Keys, new object[0]);
						DataColumn constraintName = schemaForeignKeys.Columns["FK_NAME"];
						DataColumn columnOrdinal = schemaForeignKeys.Columns["ORDINAL"];
						DataColumn childTableName = schemaForeignKeys.Columns["FK_TABLE_NAME"];
						DataColumn parentColumnName = schemaForeignKeys.Columns["FK_COLUMN_NAME"];
						DataColumn updateRule = schemaForeignKeys.Columns["UPDATE_RULE"];
						DataColumn deleteRule = schemaForeignKeys.Columns["DELETE_RULE"];
						DataColumn parentTableName = schemaForeignKeys.Columns["PK_TABLE_NAME"];
						DataColumn childColumnName = schemaForeignKeys.Columns["PK_COLUMN_NAME"];

						schemaForeignKeys.DefaultView.Sort = constraintName + "," + columnOrdinal.ColumnName;
						schemaForeignKeys.DefaultView.RowFilter = childTableName.ColumnName + " = '" + tableName + "'";

						foreach (DataRowView schemaRowFK in schemaForeignKeys.DefaultView)
						{
							string parentTable = schemaRowFK[parentTableName.Ordinal].ToString();
							string primaryKeyColumnName = schemaRowFK[childColumnName.Ordinal].ToString();
						}
					}
				}
			}

			return domain;
		}
예제 #4
0
 public bool Contains(Table value)
 {
     return List.Contains(value);
 }
예제 #5
0
 public void Remove(Table value)
 {
     List.Remove(value);
 }
예제 #6
0
 public void Insert(int index, Table value)
 {
     List.Insert(index, value);
 }
예제 #7
0
 public int IndexOf(Table value)
 {
     return List.IndexOf(value);
 }
예제 #8
0
 public int Add(Table value)
 {
     return List.Add(value);
 }