1.连接VS内置的数据库的连接字符串是:
DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\App.mdf(文件路径);Integrated Security=True;User Instance=True"
下面我说明下这连接字符串的意思:
DataSource相当于server
DataSource=.\SQLEXPRESS:是本机下的数据库实例SQLEXPRESS
AttachDbFilename=|DataDirectory|\App.mdf附加项目App_Data下的App.mdf
Integrated Security=True;User Instance=True"一个是将整体安全性设置为true,一个是将用户实例设置为true
2.Data Source=localhost/IP地址;initial catalog=dbname;user id=sa;password=123456;Connect Timeout=30;min pool size=15;max pool size=2000