求一字符串的比较linq语句,该如何解决

求一字符串的比较linq语句有一表t :ABS10001S10050S10051S10100S10101S10200.........一变量:string csql

求一字符串的比较linq语句
有一表t :

A B
S10001 S10050
S10051 S10100
S10101 S10200
.... .....


一变量:string c 

sql 取出记录
select * from t where a>=c and b<=c 

linq 怎么写?

[解决办法]
"".CompareTo("") >0
"".CompareTo("") <0
"".CompareTo("") =0