Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PhysicalDbcObjectName Property
Message
From
05/09/2008 09:08:50
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
PhysicalDbcObjectName Property
Environment versions
Environment:
C# 3.0
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01345113
Message ID:
01345113
Views:
50
Hi all,

There appears to be a new property in the Business Object called PhysicalDbcObjectName which is seperate from the TableName property. When I generate new business objects for Sql server the table name property is filled with the table name such as "Customer" but the PhysicalDbcObjectName property is filled with "dbo.Customer". I am using SQL server 2005.

This has turned out to cause me a problem as I get an "Invalid Object Name dbo.Customer" unhandled exception in the adapter.Fill call within the DataAccessSQL class. The business object generator works just fine however. Has anyone else experienced this? Once I removed the "dbo." from the property it worked fine.
Thanks
Tim

Updated: I should also note that if this property is left blank the TableName property is used instead. These are used for the SQL statements.
Timothy Bryan
Next
Reply
Map
View

Click here to load this message in the networking platform