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

>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.

We've actually had this property for several versions now. Can you post the full stack trace an error?

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform