I'm just learning the WCF entity framework (and .net in general), and I'm running into a problem specifying
lock hints in an embedded SQL query. I'm trying to specify a query that has
lock hints in it (e.g., "SELECT * FROM xyz WITH(XLOCK, ROWLOCK)") and I keep getting errors from the runtime that the query syntax is not valid. The query
…