StrataFrame Forum » .NET Forums » General .NET Discussion » Database Schema Support in SF....?

Database Schema Support in SF....?

Edhy Rijo — Mon, 23 Jun 2008 13:30:13 GMT

Hi Trent,

I am starting a new project and I am planning on using SQL2005 Database Schemas to better organize the model. Is there any problem in SF to support multiple schemas other than the default dbo?

Also how will using Schemas affect my working code with the BOs in SF? So far using the default dbo when creating an scalar method, I simply refer to the BO.TableName in the SQL, would I need to alter this to include the schema or will this be included in the BO.TableName property?

RE: Database Schema Support in SF....?

Edhy Rijo — Mon, 23 Jun 2008 13:30:13 GMT

Thanks!

RE: Database Schema Support in SF....?

Trent L. Taylor — Mon, 23 Jun 2008 13:24:44 GMT

[quote]Is there any problem in SF to support multiple schemas other than the default dbo? [/quote]

Nope. Doing it as we speak. I did make a change to the DDT the other day as there was a bug if you had the same table name but different schemas, but this will be addressed in the beta build I post later on today or tomorrow.

[quote]Also how will using Schemas affect my working code with the BOs in SF? [/quote]

dbo is always the default schema. So if you have queries that use something other than dbo, SQL Server will require you to supply them. But in regards to the BOs and the framework, there is no difference. The schema name is part of the BO when mapped, so any intrinsic methods (i.e. FillByPrimaryKey) methods will already take this into account.

[quote]So far using the default dbo when creating an scalar method, I simply refer to the BO.TableName in the SQL, would I need to alter this to include the schema or will this be included in the BO.TableName property?
[/quote]

You will need to include the schema:

[codesnippet]Dim fullName as String = MyBO.TableSchema & "." & MyBO.TableName[/codesnippet]