public void Initialize()
{
if (!SetConnection) return;
if (existTable) return;
Type classType = GetType();
StringBuilder query = new StringBuilder("CREATE TABLE [dbo].[" + tableName(classType) + "] ([" + propertyKeyName(classType) + "] " + ConvertType.FromCLR(propertyKeyType(classType)) + " PRIMARY KEY, ");
int colomnCount = propertyNames(classType).Count();
for (int i = 0; i < colomnCount; i++)
{
query.Append("[" + propertyNames(classType)[i] + "] " + ConvertType.FromCLR(propertyTypes(classType)[i]));
if (i == colomnCount - 1)
query.Append(")");
else
query.Append(", ");
}
SqlConnection sqlConnection = new SqlConnection(_connString);
SqlCommand sqlCom = new SqlCommand(query.ToString(), sqlConnection);
sqlConnection.Open();
try
{
sqlCom.ExecuteNonQuery();
}
catch (SqlException e)
{ MessageBox.Show(e.ToString()); }
sqlConnection.Close();
}