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