连接到SQL服务器，Oracle，DB2和MySQL的同时使用ADO.NET？ [英] Connecting to SQL Server, Oracle, DB2 and MySQL simultaneously using ADO.NET?

问题描述

我是比较新的.NET，但我想，以确定是否有可能有一个.NET 4的应用程序同时连接到多个供应商数据库（SQL服务器，Oracle，DB2和MySQL），使用ADO.NET和同时执行查询？

I'm relatively new to .NET but I'm trying to determine if it's possible to have a single .NET 4 application connect to multiple vendor databases simultaneously (SQL Server, Oracle, DB2 and MySQL) using ADO.NET and execute queries simultaneously?

所有我发现迄今谈论连接到只有一个数据库在一个时间例子。 谢谢！

All the examples I've found so far talk about connecting to only one database at a time. Thanks!

推荐答案

您只需要4个连接字符串和4个独立的ADO连接对象。然后呢SLaks说，大约异步查询，同时做他们，如果你真的希望他们并行运行。

You just need 4 connections strings and 4 separate ADO Connection objects. And then what SLaks said about async queries to do them simultaneously, if you truly want them running in parallel.

这篇关于连接到SQL服务器，Oracle，DB2和MySQL的同时使用ADO.NET？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！