Database Objects

Database Objects is a library of utility classes for inspecting database schemas.

Features

Provides classes representing various database objects.

Loads the definitions of the following database objects from Microsoft Sql Server Databases:

• Tables
  • Columns
  • Constraints (with target columns)
• Routines (Procedures And Functions)
  • Parameters

This includes names, data types and other related information.

Sample Code

Loading a database model:

Model model = Model.LoadFromDatabase(ConnectionString);

Using some of the loaded model items:

foreach (Table table in model.Tables)
{
	Console.WriteLine(table.Name);

	foreach (Column column in table.Columns)
	{
		Console.WriteLine(column.Name);

		Console.WriteLine(column.DataType.DataType);
	}

	foreach (Constraint constraint in table.Constraints)
	{
		Console.WriteLine(constraint.Name);

		Console.WriteLine(constraint.ConstraintType);
	}
}

foreach (Routine routine in model.Routines)
{
	Console.WriteLine(routine.Name);

	Console.WriteLine(routine.RoutineType);

	foreach (RoutineParameter parameter in routine.Parameters)
	{
		Console.WriteLine(parameter.Name);

		Console.WriteLine(parameter.Mode);

		Console.WriteLine(parameter.DataType.DataType);
	}
}

Contributing

The project includes The following projects:

• DatabaseObjects - The main library.
• DatabaseObjects.Tests - The unit tests.

The following tasks would be good items to work on:

• Support for check constraints
• Unit tests
• Support for additional database objects.
• Compatibility with other Databases (Oracle, MySql, SQLite...).
• Refactor constraints, parameters etc where a "Type" enumeration is used to be either:
  • Classes derived from a common base.
  • Classes implementing a common interface.
• Construction of DDL
• De/serialization of row data