Just joined GitHub in order to upload a SQL Server script which is too large for Stack overflow. Stack overflow only allows 30,000 characters. My script contains 42,000. I hope that GitHub will allow ...

SQL Server's like operator is accepting comparison against Integer column, whereas EF.Functions.Like method is not accepting comparison with integer column.

For a wholly numeric one, the kind is 1; for other ones, it's kind 2. When retrieving data that you want to sort, order by the kind of serial, then the serial - e.g. SELECT * FROM tblFoo ORDER BY ...