c# keyword in table using business object mapper


Author
Message
Victor Sousa
Victor Sousa
StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)StrataFrame Novice (78 reputation)
Group: Forum Members
Posts: 21, Visits: 236
How do I use the business object mapper on an SQL table which contains a field that is a key work in c#?

The field name is void.



I do not have control of these field names. I need to query data from an existing ERP system.



Is there anyway to use the @ prefix on the field names?



I actually do not need this field in the result set. Is there a way to instruct the BOM to use only certain fields for the BO definition?
Reply
Peter Jones
Peter Jones
Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)
Group: Forum Members
Posts: 386, Visits: 2.1K
Hi Victor,



You could create a view that omitts/renames the Void column and then use the view as the data source in the BO mapper.



You can do quite a bit in the Properties section of each column in the BO mapper but I'm pretty sure renaming columns isn't supported.

Cheers, Peter
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search