miniSql

创建
zgc123@gmail.com authored at 11/19/2023 1:40:15 AM
489.00 B
Sample - Tables and Columns and DATA.txt.mt
ConnectionString: "${Host.Model.ConnectionString}"
ProviderName: "${Host.Model.ProviderName}"

#foreach ($table in ${Host.Model.Tables})
Table Data: ${table.FullName} (Row count: ${Data.Get(${table.Schema}, ${table.Name}).Rows.Count})

#set($dataTable = $Host.Data.Get(${table.Schema}, ${table.Name}))
#foreach ($row in $dataTable.Rows)
#foreach ($c in ${table.Columns})
${c.Name}: ${Host.Data.ColumnValue($row, $c.Name)}
#end ## table columns
#end ## table rows
#end ## foreach table