How To Use Guid Filter in Select StateMent :( :( :(

[mhd sbt]

hi to all i want wrote a one line Code Similare This

myDataTable.Select("Guid IN ('8556c1fd-d4a1-4c1c-b2af-c1fa9403ce4e')”)

but i face With this Problem 'myDataTable.Select("Guid IN ('8556c1fd-d4a1-4c1c-b2af-c1fa9403ce4e')")' threw an exception of type 'System.Data.EvaluateException' System.Data.DataRow[] {System.Data.EvaluateException} this is a one line Code That is ok, but i dont want use of this Method

myDataTable.Select("Guid = '8556c1fd-d4a1-4c1c-b2af-c1fa9403ce4e'”)

any way is Exist that Use Guid in Linq FilterExpresion With 'IN'???? thank for Any Help

[V 0]

Is the Guid in the database as a string representation or a byte [] ?

V.
(MQOTD rules and previous solutions)

[Richard Deeming]

Try converting the column to a string in the filter expression:

myDataTable.Select("Convert(Guid, 'System.String') IN ('8556c1fd-d4a1-4c1c-b2af-c1fa9403ce4e')")

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

[mhd sbt]

Guid save in DataBase AS UniqueIdentifier

[V 0]

That's most probably the culprit. This "UniqueIdentifier" is not a string and apparently your database engine cannot convert it implicitly. Try to follow Richard Deeming's advice. Alternatively you could use a parametrized query instead and try to pass the guid as a byte[] (blob) instead of a string. Hope this helps.

V.
(MQOTD rules and previous solutions)

[mhd sbt]

thanks Mr Deeming,Your Answer Save My life :)