Database

<code>public class SqlTableAdapter<T> where T : new()

...

// Get properties of a generic class what I want to create a sql table from.

PropertyInfo[] properties = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
for (int indexProperty = 0; indexProperty < properties.Length; indexProperty++)
{
    Object[] attributes = properties[indexProperty].GetCustomAttributes(typeof(DataObjectFieldAttribute), true);
    if (attributes.Length > 0)
    {
        DataObjectFieldAttribute dataObjectField = attributes[0] as DataObjectFieldAttribute;
        DataColumn dataColumn = new DataColumn(properties[indexProperty].Name, properties[indexProperty].PropertyType);
        dataColumn.Unique = dataObjectField.IsIdentity;
        dataColumn.AllowDBNull = dataObjectField.IsNullable;
        if (properties[indexProperty].PropertyType == typeof(string))
        {
              dataColumn.MaxLength = dataObjectField.Length;
        }

        // The problem is here to convert the system type ! I don't have a method SqlTypeConvert.
        dataColumn.SqlType = SqlTypeConvert( properties[indexProperty].PropertyType );

        dataColumns.Add(dataColumn);
    }
}

...

// Create a Sql column definition, ex. columnDefinition="CustID int PRIMARY KEY, CompanyName nvarchar (50)" from the dataColumns list.

...

DbCommand commandCreateTable = this.Connection.CreateCommand();
commandCreateTable.Connection = this.Connection;
commandCreateTable.CommandText = string.Format("CREATE TABLE [{0}] ({1})", typeof(T).ToString(), columnDefinition);
commandCreateTable.CommandType = CommandType.Text;

alter Proc GetAll
with encryption 
as
select * from test1