TrialUser
asked on
how to make LINQtosql ignore case on joins
I have a SQL Server 2008 database and I am connecting from ASP.net 4.0 application to the SQL Server db. I want LINQ to ignore case while doing Joins. Is there any setting either at the application level or at the datacontext level to make LINQ ignore Cases. I do not want to use toupper in every query. please help thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is LINQ to SQL query case senstive on joins as in If I do
Join soemtable on sometable.column1 equals sometable2.column2
where column1 and column2 are varchar(50 columns in sql server), would this match records
where column1 = Uname
column2 = uname
I am searching on the web and I am seeing some say LINQ is case senstive and some say it is now.
Join soemtable on sometable.column1 equals sometable2.column2
where column1 and column2 are varchar(50 columns in sql server), would this match records
where column1 = Uname
column2 = uname
I am searching on the web and I am seeing some say LINQ is case senstive and some say it is now.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER