CODEWITHSUNDEEP
databasevb.net
Thomas Carlton
Thomas Carlton

Reputation: 5968

How to query different databases from different vendors using VB.Net

I'm writing an application that should be able to query different databases from different vendors (Oracle, Sybase, SQL Server, MS Access).

Is there any tool that performs this for C# or VB.Net ? something like UnityJDBC ?

I would like to avoid creating different interfaces that communicate with different SQL structures to query databases.

Thanks

Upvotes: 0

Views: 285

Answers (1)

djv
djv

Reputation: 15774

Nothing is built into .NET out of the box. However, simple web searches proves that it is possible to use LINQ to all of these

Oracle: http://download.oracle.com/oll/obe/EntityFrameworkOBE/EntityFrameworkOBE.htm

Sybase: http://www.sybase.com/detail?id=1056609

Access: http://forums.asp.net/t/1542443.aspx

SQL Server (there are a lot of resources, here's a comprehensive one): http://www.codeproject.com/Articles/215712/LINQ-to-SQL-Basic-Concepts-and-Features

Upvotes: 1

Related Questions