<% foreach (ColumnSchema column in Table.Columns) { switch(column.CSDataType){ case "DateTime": %> <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").ToString("yyyy-MM-dd"), <% break; case "DateTime?": %> <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").HasValue ? row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").Value.ToString("yyyy-MM-dd") : string.Empty, <% break; default: %> <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>"), <% break; } } %> DbCommand deletedCommand = conn.CreateCommand(); deletedCommand.CommandText = "DELETE FROM <%= Table.aliasName %>"; deletedCommand.ExecuteNonQuery(); DbCommand insertedCommand = conn.CreateCommand(); insertedCommand.CommandText = "<%= Table.SqlBuilder.GetInsertCommandText(true) %>"; <% foreach (ColumnSchema column in Table.Columns) { %> insertedCommand.Parameters.Add(new SQLiteParameter("<%= column.AliasName %>")); <% } %> int affectedRecords = 0; foreach (var item in list) { <% foreach (ColumnSchema column in Table.Columns) { %> insertedCommand.Parameters["<%= column.AliasName %>"].Value = item.<%= column.AliasName %>; <% } %> affectedRecords += insertedCommand.ExecuteNonQuery(); } return affectedRecords; <% foreach (ColumnSchema column in Table.Columns) { %> <%= GetScript(column) %> <% } %>