LINQ - is this bug in linq to sql - Asked By bhanupratap singh on 27-Jun-12 02:59 AM

Error is:----String must be exactly one character long.

How to solve it ?

 con = new SqlConnection(Constr);
        SqlCommand cmd = new SqlCommand("select *from Consignment", con);
        
        cmd.CommandType = CommandType.Text;
 HGCNEWDataContext db = new HGCNEWDataContext();
        var cnmtt = from p in db.CONSIGNMENTs
                    where p.GOODS=="R M GOODS"
                    orderby p.CNMT descending 
                  select p;
        GridView1.DataSource = cnmtt;
        GridView1.DataBind();

how to solve it I m using studio 2008 and sql 2008
Pls write solution of it

Hi Frndz,

 

Functionality:  LINQ to SQL Varchar(1) Character Filter

 

 

To achieve this task,

 

In you db table there is filed is Varchar(1) or nVarchar(1)

 

When you drag and Drop you table into DBML file then this type convert to char

 

So there is two way to solved this problem

 

First Way

 

Change varchar(1) filed type char to string in DBML

 

Or

 

 

 

Second Way

 

Set p.GOODS.ToString()

 

 

 

var cnmtt = from p in db.CONSIGNMENTs

              where p.GOODS.ToString() == "R M GOODS"

              orderby p.CNMT descending

              select p;

 

 

 

 

Hope this helpful!

Thanks

 

 

 

this is still showing same problems

Couple of changes:

a)Add a where clause,
SqlCommand cmd = new SqlCommand("select *from Consignment where goods is not null", con); 

b) If your underlying table has a collation defined, you might have to remove it.

c) Any elements that are mapped to Char(1) can be changed to string. Do this in your designer, recompile and check. 

This is the best shot I can take.