예제 #1
0
        public void CreateTable(DataColumnCollection columnCollection)
        {
            var createStatement = $"CREATE TABLE {_tableName}";

            var columns = string.Join(
                ", ",
                columnCollection.Cast <DataColumn>().Select(col => $"[{col.ColumnName}] {col.DataType.GetSqlType()}")
                );


            var query = $"{createStatement} ({columns})";

            sqliteService.ExecuteQuery(query);
        }