WPF数据库配置1.Sqlserver数据库连接2.Oracle数据库连接3.MySql数据库连接4.Acces数据库连接5.SQLite数据库连接

153 阅读 0 评论 101 点赞

我是靠谱客的博主幽默水壶，这篇文章主要介绍WPF数据库配置1.Sqlserver数据库连接2.Oracle数据库连接3.MySql数据库连接4.Acces数据库连接5.SQLite数据库连接，现在分享给大家，希望可以做个参考。

1.Sqlserver数据库连接

<connectionStrings>
<add name="Conn" connectionString="Provider=MSDAORA;Data Source=demo;User ID=sa;Password=123456;" providerName="System.Data.OracleClient"/>
</connectionStrings>

2.Oracle数据库连接

<connectionStrings>
<add name="Conn" connectionString="server=.;database=demo;uid=sa;pwd=123456" providerName="System.Data.SqlClient"/>
</connectionStrings>

3.MySql数据库连接

<connectionStrings>
<add name="Conn" connectionString="host=127.0.0.1;Port=3306;Database=mysql;uid=sa;pwd=12346" providerName="MySql.Data.MySqlClient"/>
</connectionStrings>

4.Acces数据库连接

<connectionStrings>
<add name="Conn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}App_Data/demo.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>

5.SQLite数据库连接

<connectionStrings>
<add name="Conn" connectionString="host=127.0.0.1;Port=3306;Database=mysql;uid=sa;pwd=12346" providerName="MySql.Data.MySqlClient"/>
</connectionStrings>