Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Business Layer Generator Error
Message
From
24/11/2008 13:00:03
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
 
To
24/11/2008 12:11:20
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
VB 9.0
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01361186
Message ID:
01363828
Views:
20
Hi Michael,

>I have installed the 11/17/2008 update but I am still having a problem with the Business Layer Generator.
>
>It works fine for Northwind and other SQLServer databases that do not make use of Schemas. However, it does not work with schema-based SQLServer tables (at least not for me).
>
>For example, table objects in my database belong to one of 4 schemas. So, my Patients table if referenced by dbo.ServiceDelivery.Patient instead of just dbo.Patient.
>
>The Business Generator connects to the database and populates the object list just fine. But when I go to click on one of the table objects I get an exception that starts with "Invalid object name 'dbo.Patient'.
>
>Is there something I can configure to make this work? If not, can this be fixed/patched? or am I S.O.L.?
>
>Thanks,
>
>Michael

I am not sure how the BLG handles it directly but there are two properties in your business objects "TableName" and "PhysicalDbcObjectName" that you can set for each business object as needed. That being said, if you can't get them created and I don't have the answer at this point, you could set all your tables without the schemas to create your business objects and then reset them the way you want. I would bet once created they would get accessed OK with the right value in the PhysicalDbcObjectName property for those business objects. You may want to test that with a table first and then Maybe someone from OakLeaf can give you an answer to the BLG issue.
Tim
Timothy Bryan
Previous
Reply
Map
View

Click here to load this message in the networking platform