miniSql

创建
zgc123@gmail.com authored at 11/19/2023 1:40:15 AM
6136600
Tree
0 Parent(s)
Summary: 1 changed files with 28 additions and 0 deletions.
Added +28 -0
Added +28 -0
diff --git a/minisqlquery-master/src/MiniSqlQuery/Templates/Sample - Tables and Columns.txt.mt b/minisqlquery-master/src/MiniSqlQuery/Templates/Sample - Tables and Columns.txt.mt
new file mode 100644
index 0000000..fd60248
--- /dev/null
+++ b/minisqlquery-master/src/MiniSqlQuery/Templates/Sample - Tables and Columns.txt.mt
@@ -0,0 +1,28 @@
+ConnectionString: "${Host.Model.ConnectionString}"
+ProviderName: "${Host.Model.ProviderName}"
+
+#foreach ($table in ${Host.Model.Tables})
+Table: ${table.FullName}
+#foreach ($c in ${table.Columns})
+  * Column.Name:     ${c.Name}
+	DbType.Summary:  ${c.DbType.Summary}
+		Name:        ${c.DbType.Name}
+		Length:      ${c.DbType.Length}
+		Precision:   ${c.DbType.Precision}
+		Scale:       ${c.DbType.Scale}
+		SystemType:  ${c.DbType.SystemType}
+	Nullable:        ${c.Nullable}
+	IsKey:           ${c.IsKey}
+	IsUnique:        ${c.IsUnique}
+	IsRowVersion:    ${c.IsRowVersion}
+	IsIdentity:      ${c.IsIdentity}
+	IsAutoIncrement: ${c.IsAutoIncrement}
+	IsReadOnly:      ${c.IsReadOnly}
+	IsWritable:      ${c.IsWritable}
+	HasFK:           ${c.HasFK}
+#if($c.HasFK)
+	 ${c.ForeignKeyReference.ReferenceTable.FullName}.${c.ForeignKeyReference.ReferenceColumn.Name}
+#end ## hasFK
+#end ## foreach column
+#end ## foreach table
+