SubSonic-based app that connects to multiple databases

Posted by Fervelas on Stack Overflow See other posts from Stack Overflow or by Fervelas
Published on 2010-01-16T04:16:08Z Indexed on 2010/03/27 6:03 UTC
Read the original article Hit count: 427

Filed under:

subsonic

|

subsonic2.2

Hello there,

I currently developed an app that connects to SQL Server 2005 database, so my DAL objects where generated using information from that DB.

It will also be possible to connect to an Oracle and MySQL db, all with the same table structures (aside from the normal differences in fields, such as varbinary(max) in SQL Server and BLOB in Oracle, and so on). For this purpose, I already defined multiple connection strings and multiple SubSonic providers for the different DB's the app will run on.

My question is, if I generated my objects using a SQL Server database, should the generated objects work transparently with the other DB's or do I need to generate a different DAL for each database engine I use? Should I be aware of any possible bugs I may encounter while performing these operations?

Thanks in advance for any advice on this issue.

© Stack Overflow or respective owner

Related posts about subsonic

subsonic.migrations and Oracle XE

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, Probably I'm doing something wrong but here it goes: I'm trying to create a database using subsonic.migrations in an OracleXE version 10.2.0.1.0. I have ODP v 10.2.0.2.20 installed. This is my app.config: <?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> … >>> More
SUBSONIC 3.0.0.3 Subsonic.Query.SqlQuery

as seen on Stack Overflow - Search for 'Stack Overflow'
New to subsonic and having issues figuring it out. I am simply just trying to do a distinct search and any documentation I find is telling me to use the class/method SubSonic.SqlQuery Though I am finding out that since I am using the newest version, a lot of the documentation I am finding does not… >>> More
Error with SubSonic 2.0.3

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have to work on an application which used Subsonic 2.0.3. When I opened the project,I got a message The projectfile 'C:\Program Files\Subsonic\Subsonic 2.0.3\src\SubSonic\SubSonic.csproj' has been moved, renamed or is not on your computer. Does it mean I need to install Subsonic 2.0.3, I… >>> More
Benchmark Linq2SQL, Subsonic2, Subsonic3 - Any other ideas to make them faster ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working with Subsonic 2 more than 3 years now... After Linq appears and then Subsonic 3, I start thinking about moving to the new Linq futures that are connected to sql. I must say that I start move and port my subsonic 2 with SubSonic 3, and very soon I discover that the speed was so slow… >>> More
Saving record in Subsonic 3 using Active Record

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having trouble saving a record in Subsonic 3 using Active record. I've generated my objects using the DALs and tts and everything seems fine because the following test passes. I think that my connection string is correct or the generation wouldn't have succeeded. [Test] public void… >>> More

Related posts about subsonic2.2

SubSonic Stored Procedure Issue - Data Generated at Stored Procedure is different from Data Received

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I am facing a unknown problem while using stored procedure with SubSonic. I have written a stored procedure & application code that takes first name & last name as input parameter and return last login id as ouput parameter. It creates login id as first character of first name &… >>> More
Table Alias in SubSonic

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I assign alias to tables with SubSonic 2.1? I am trying to reproduce the following query: SELECT * FROM posts P RIGHT OUTER JOIN post_meta X ON P.post_id = X.post_id RIGHT OUTER JOIN post_meta Y ON P.post_id = Y.post_id WHERE X.meta_key = "category" AND X.meta_value = "technology" … >>> More
SubSonic 2.2 missing stored procedures in StoredProcedures.cs when generated with sonic.exe

as seen on Stack Overflow - Search for 'Stack Overflow'
We are trying to move from SubSonic 2.0.3 to 2.2 (not using .NET 3.5). When we regenerate the project using SubCommander\sonic.exe and try to compile we get some errors reporting missing members (which should have been automatically generated based on the stored procedures we have). On closer inspection… >>> More
Exception with Subsonic 2.2, SQLite and Migrations

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm playing with Migrations and created a simple migration like public class Migration001 : Migration { public override void Up() { TableSchema.Table testTable = CreateTableWithKey("TestTable"); } public override void Down() { … >>> More
SubSonic-based app that connects to multiple databases

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello there, I currently developed an app that connects to SQL Server 2005 database, so my DAL objects where generated using information from that DB. It will also be possible to connect to an Oracle and MySQL db, all with the same table structures (aside from the normal differences in fields, such… >>> More