I have a coupld of tables that I join using a varchar column in my query. While executing the query in SQL the returned results seem to case insensitive. However whn I use LINQtoSQL to perform the same query in LINQ from aSP.net application it seems like the join condition was case sensitive.
1) I am wondering is LINQ to SQL case sensitive on joins - how can i check this
2) How can I make these joins case insensitive - either by changing a config in SQL or in LINQ.
Please help thanks