I'm new to Subsonic and I work primarily with Oracle databases. Can subsonic be used against an Oracle database and does it support the use of Oracle's ODP.NET data provider.
If yes, can you point me to a good example?
Thanks in advance. Scott
A:
SubSonic does indeed work with Oracle. Go here for a sample configuration for SubSonic 2.x using ODP.NET or here to see a screencast on configuring SubSonic 3.
Marve
2009-08-11 19:05:15
+1
A:
Marve is a little miss leading. Subsonic can be used with Oracle but SubSonic 2.x actually uses System.Data.OracleClient. Subsonic 3.0 does not have any .tt files for Oracle yet as no one has stepped forward to do it. I have been using Subsonic 2.2 with Oracle for months now and find that it works very well.
runxc1 Bret Ferrier
2009-08-11 21:07:42
Thanks for the correction. I wasn't aware that no Oracle templates are in place.
Marve
2009-08-11 21:21:36
A:
Scott, Recently some developers have teamed-up to offer Oracle support (using Oracle's ODP.NET) for Subsonic 3.x, using the T4 Visual Studio template database provider system. Please search Github.com for Oracle/Subsonic, or my link, http://github.com/mabraham1/LINQ2Oracle
Also, I've posted the template provider on the SubsonicProject site, as follows: subsonicproject.com/docs/File:OracleTemplateProviderExample.RAR
Please rename the RAR to ZIP once downloaded (had trouble uploading a ZIP file).
Hope this helps!
Mark
MAbraham1
2009-12-01 15:20:01
Mark, where's the documentation for this? I downloaded it and could not figure out how to get up and running.
aron
2010-07-08 16:31:02
Aron, I'm no longer active in the SubSonic forums, since I've chosen to go with DevARt's DotConnect. I would suggest looking for Simon Timm's branch:git://github.com/stimms/SubSonic-3.0.git
MAbraham1
2010-07-10 23:50:50