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; }