How to query different databases from different vendors using VB.Net -
i'm writing application should able query different databases different vendors (oracle, sybase, sql server, ms access).
is there tool performs c# or vb.net ? unityjdbc ?
i avoid creating different interfaces communicate different sql structures query databases.
thanks
nothing built .net out of box. however, simple web searches proves possible use linq 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 lot of resources, here's comprehensive one): http://www.codeproject.com/articles/215712/linq-to-sql-basic-concepts-and-features
Comments
Post a Comment