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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASP.NET
The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications
128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER