I have searched for 'DbObjectName' in posts, but none have provided a satisfactory answer.
When I created a typed dataset using the designer wizard, my connection string was pointing at my Development database and the designer created the code referencing 'DbObjectName' as follows:
<DbSource ConnectionRef="CS_CAPAC (Web.config)" DbObjectName="PrimComm_CAPAC_Dev.dbo.CAPAC_Service_Request" DbObjectType="Table" .....>
i.e. it prefixed/qualified DbObjectname with my development database name... PrimComm_CAPAC_Dev.dbo.CAPAC_Service_Request
This is not the name of my Production database.
So can I edit the xsd file and remove the database qualifier i.e set it to DbObjectname = "dbo.CAPAC_Service_Request". I have seen this as a solution, but am not sure of the effect.
What is the purpose of DbObjectname and shouldn't the designer just reference the name of the table, as opposed to the database its contained in. Or does this cater for differences in the schema between development and production. I would have thought the connection string would provide it with enough information as to where the table exists.