version 1.0.2005.1 final (self-servicing)
VS2005 asp.net 2.0
hiya,
I want to grab the value of a single field in a single table.
It’s the opposite of the “entity.FetchUsingPK()” function.
I have 2 field values, which, when taken together, guarantee uniqueness:
orderStatusID
username
And I want to use them to return the value of the primaryKey in the table, ie
orderId
So, the query would be
SELECT orderID
FROM tblOrder
WHERE orderStatusID = 99
AND username =”Jimmy”
I believe that I won’t need to use an entityCollection (because I only want a single, non-computed value)??
many thanks,
yogi