C#分析数据库结构，使用XSL模板自动生成代码_C#应用

文件 dbxmlcfg.xml内容

--------------------------------------------------------------------------------

<?xml version="1.0" encoding="utf-8" ?>

<application>

<settings>

<setting key="conn">Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=CPR;Initial Catalog=HTIOA;Data Source=192.168.0.124</setting>

<setting key="conndbxml">Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=IssueVision;Data Source=(local)</setting>

<!--

定义查询表结构使用的SQL语句，

queryfield_驱动程序名称 定义了查询指定表的字段定义的SQL语句，该语句带有一个参数

querytable_驱动程序名称 定义了查询所有表名及其字段个数的SQL语句，该语句没有参数

目前定义了 oracle和ms sql server 的SQL语句

-->

<setting key="queryfield_OraOLEDB.Oracle.1">Select TName ,CName ,coltype ,width From Col where tname in (#tablelist) Order by TName,CName</setting>

<setting key="querytable_OraOLEDB.Oracle.1">Select TName ,count(*) From Col group by tname Order by TName </setting>

<setting key="queryfield_SQLOLEDB.1"><![CDATA[select sysobjects.name ,syscolumns.name ,systypes.name ,syscolumns.length from syscolumns,sysobjects,systypes where syscolumns.id=sysobjects.id and syscolumns.xtype=systypes.xtype and sysobjects.type='U' and systypes.name <>'_default_' and systypes.name<>'sysname' and sysobjects.name in (#tablelist) order by sysobjects.name,syscolumns.name]]></setting>