Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Business Layer Generator Error
Message
De
24/11/2008 13:00:03
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
 
 
À
24/11/2008 12:11:20
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
VB 9.0
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01361186
Message ID:
01363828
Vues:
19
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform