Subsonic SQLite Multiple Files

Posted by Marcus Vinicius de LIma on Stack Overflow See other posts from Stack Overflow or by Marcus Vinicius de LIma
Published on 2010-05-12T20:58:49Z Indexed on 2010/05/15 16:54 UTC
Read the original article Hit count: 368

Filed under:

subsonic

|

sqlite

Hi,

I have an application that must be accessed for many users. To optimize the performance I intend to store each user profile information at a independant database file.

I need everytime a user login the application, to setup a new provider linked with his own database. All databases have the same structure. So while querying user the commom generated DAL classes must switch for the database file relative the the user.

Is there a way for configure SubSonic for doing that switch at runtime?

Thanks.

© 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 sqlite

How to add SQLite (SQLite.NET) to my C# project

as seen on Stack Overflow - Search for 'Stack Overflow'
I followed the instructions in the documentation: Scenario 1: Version Independent (does not use the Global Assembly Cache) This method allows you to drop any new version of the System.Data.SQLite.DLL into your application's folder and use it without any code modifications or recompiling… >>> More
dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite

as seen on Stack Overflow - Search for 'Stack Overflow'
Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)? >>> More
SQLite table does not exist exception for existing SQLite database (and table)

as seen on Stack Overflow - Search for 'Stack Overflow'
I've followed the instructions given here for introducing an existing SQLite database to your Android app. When I query the table "android_metadata" this is fine. But when I run a similar query on my own table "words" (which has _id for primary integer key) I get a table does not exist exception… >>> More
Android Jelly bean database is locked (code 5)

as seen on Stack Overflow - Search for 'Stack Overflow'
Im getting a database is locked (code 5) in my ListActivity the code works in the other versions of the Emulator but fails in the 4.1 version of the emulator E/SQLiteLog( 2132): (5) database is locked E/SQLiteDatabase( 2132): Failed to open database '/data/data/id.online.mydroid/databases/geo… >>> More
Android:accessing assets folder sqlite databse file with .sqlite extension

as seen on Stack Overflow - Search for 'Stack Overflow'
How to read data from the assets folder sqlite database file with .sqlite extension in my android application? Thanks >>> More