使用SQL Server链接服务器与DB2实体框架的任何经验?

时间:2022-01-18 15:40:27

Unfortunately, we have to use data from a DB2 mainframe in several of our web applications. We are using Entity Framework for any data stored in SQL Server, and we would love to be able to use EF for all of our data access.

不幸的是,我们必须在几个Web应用程序中使用来自DB2大型机的数据。我们正在将实体框架用于存储在SQL Server中的任何数据,我们希望能够将EF用于我们的所有数据访问。

I know that IBM is working on an EF provider, but I have been following that bug-ridden mess and I don't even want to touch it.

我知道IBM正在开发一个EF提供商,但我一直在关注那个充满错误的混乱,我甚至都不想触摸它。

So the next option seems to be setting up linked servers. This has worked well for other situations in the past, but I have never tried it with Entity Framework.

所以下一个选项似乎是设置链接服务器。这在过去的其他情况下效果很好,但我从未尝试使用Entity Framework。

Has anyone out there ever tried this, and been successful? If so, could you please share your pain points and any tips and tricks?

有没有人试过这个,并取得了成功?如果是这样,你能分享一下你的痛点和任何提示和技巧吗?

Thanks in advance.

提前致谢。

1 个解决方案

#1


2  

Hide the linked servers behind views or stored procedures. Hopefully EF should not realise...

隐藏视图或存储过程后面的链接服务器。希望EF不应该意识到......

#1


2  

Hide the linked servers behind views or stored procedures. Hopefully EF should not realise...

隐藏视图或存储过程后面的链接服务器。希望EF不应该意识到......