I'm using the v2.5 of LLBL and there is something that I want to make sure the product will support before going any further. We have a base schema in all our databases. Call it 'DBO' with a set of base tables - users can create another schema in the application whereas we just create a new schema with the user given name and create a new set of the same tables that are in the DBO schema. So all the schemas will have the same table structure. We are also using the adapter method and sql 2005
Questions
1. Can I only use the generated code against the schema that I created code against? Can I change the schema that is being target at runtime?
2. Further along that model - each account (user) hs their own database with the same set of tables can I just change my connection string to have the generated code target a specific database?
I have a sneaking feeling that the llbl generated code will has a fully qualified name [database].[owner].[object] - if so is there a work around?
