Compare ntext by row in sql server 2005 by linq

Question

How to compare ntext type in sql server 2005 with string with linq?

in SQL Server 2005

@a as ntext

linq in C #;

string b;

var k=from p in DataContext.TableName 

where p.a.toString()==b)

select p;

//return k=null

+3

ashkufaraz Mar 11 '11 at 12:19

3 answers

devio · Answer 1 · 2011-03-11T20:12:13+0000

NTEXT columns cannot be compared. See MSDN and MSDN Forum

If you work in 2005 or higher, convert NTEXT to NVARCHAR (MAX), as others have already pointed out.

Sam jones · Answer 2 · 2012-02-15T04:00:50+0000

You can do this in linq2sql using the static "Like" method of the System.Data.Linq.SqlClient.SqlMethods class.

string b;

var k=from p in DataContext.TableName 

where System.Data.Linq.SqlClient.SqlMethods.Like(p.a, b)

select p;

Stuart · Answer 3 · 2011-03-11T16:59:50+0000

linq2sql, - .ToString() , , .

, , NVARCHAR (MAX) NTEXT