我在数据库系统方面没有足够的经验。我需要连接到远程SQL服务器并对其进行一些查询处理。我该如何通过Entity Framework连接远程服务器?
我在数据库系统方面没有足够的经验。我需要连接到远程SQL服务器并对其进行一些查询处理。我该如何通过Entity Framework连接远程服务器?
1) 检查远程SQL服务器是否允许远程连接
2) 在Visual Studio中使用Entity Framework向导(添加新连接)
Create the connection string as follow (see SqlConnectionStringBuilder):
public static string GetRemoteConnectionString()
{
SqlConnectionStringBuilder sqlString = new SqlConnectionStringBuilder()
{
DataSource = $"{IP},{PORT}", // ex : 37.59.110.55,1433
InitialCatalog = "MyDatabaseName", //Database
IntegratedSecurity = false,
MultipleActiveResultSets = true,
ApplicationName = "EntityFramework",
UserID = "MyUserId",
Password = "MyPassword"
};
return sqlString.ToString();
}
Then connect via the DbContext :
public class MDBContext : DbContext
{
public MDBContext () : base(GetRemoteConnectionString())
{
}
......
}
You can also easily check connection (before to create the DbContext) as follow :
try
{
using (SqlConnection con = new SqlConnection(GetRemoteConnectionString()))
{
con.Open();
}
success = true;
}
catch (Exception ex)
{
success = false;
...
}