private List <SqlCeDataTypes> ReadSqlCeDataTypes()
{
List <SqlCeDataTypes> result = new List <SqlCeDataTypes>();
if (_dbConnection.State != ConnectionState.Open)
{
_dbConnection.Open();
}
try
{
using (DataTable types = _dbConnection.GetSchema("DataTypes"))
{
foreach (DataRow row in types.Rows)
{
var type = new SqlCeDataTypes()
{
ColumnSize = Common.TryConvertInt64(row["ColumnSize"].ToString(), 0),
TypeName = row["TypeName"].ToString(),
CreateFormat = row["CreateFormat"].ToString(),
DotNetDataType = row["DataType"].ToString(),
IsAutoincrementable = Convert.ToBoolean(row["IsAutoincrementable"])
};
result.Add(type);
}
}
}
finally
{
_dbConnection.Close();
}
return(result);
}
private List<SqlCeDataTypes> ReadSqlCeDataTypes()
{
List<SqlCeDataTypes> result = new List<SqlCeDataTypes>();
if (_dbConnection.State != ConnectionState.Open)
_dbConnection.Open();
try
{
using (DataTable types = _dbConnection.GetSchema("DataTypes"))
{
foreach (DataRow row in types.Rows)
{
var type = new SqlCeDataTypes()
{
ColumnSize = Common.TryConvertInt64(row["ColumnSize"].ToString(), 0),
TypeName = row["TypeName"].ToString(),
CreateFormat = row["CreateFormat"].ToString(),
DotNetDataType = row["DataType"].ToString(),
IsAutoincrementable = Convert.ToBoolean(row["IsAutoincrementable"])
};
result.Add(type);
}
}
}
finally
{
_dbConnection.Close();
}
return result;
}
