c# 连接数据库的方式

 

sqlite  ConnectionString

public static string ConnectionString = @"DataSource=c:\\\\test.db";
//加密码，注意 System.Data.SQLite版本不同 是不支持密码连接的

public static string ConnectionString = @"DataSource=c:\\\\test.db;Password=mypassword";

 

 

mysql  ConnectionString

<add key="MysqlDB" value="server=IP地址;port=3306;Database=数据库名;Uid=用户名;Pwd=密码;CharSet=utf8" />

 

sqlserver ConnectionString

Server=IP地址,端口号;Database=数据库;User=用户名;Password=密码;

 

oracle 

odbc

OdbcConnection conn = new OdbcConnection(DSN=XXX;UID=XXX;Pwd=XXX;);

oledb
OleDbConnection conn = new OleDbConnection("Provider=MSDAORA.1;User ID=XXX;password=XXX;Data Source=XXX;Persist Security Info=False");

OracleClient 利用System.Data.OracleClient方式（该方式已过时，不推荐使用）
OracleConnection conn = new OracleConnection(“data source=XXX;user=XXX;password=XXX;”);

OracleDataAccess
 Oracle.DataAccess.Client.OracleConnection conn = new Oracle.DataAccess.Client.OracleConnection("Data Source=yellow;user Id=Knemes;Password=oracle");

ODP.NET
string connString = "DATA SOURCE=实例名;PERSIST SECURITY INFO=True;USER ID=XXX;password=密码";
OracleConnection conn = new OracleConnection(connString);