Problem with LINQ to entities on a XML field in database

I've a problem:

I try to access to a database with the code below, but I've an error:

System.Data.EntityCommandExecutionException: Une erreur s'est produite lors de l'exécution de la définition de la commande. Pour plus de détails, consultez l'exception interne. ---> System.Data.SqlClient.SqlException: Disallowed implicit conversion from data type xml to data type nvarchar, table 'dbo.Fournisseurs', column 'Informations'. Use the CONVERT function to run this query.

I think it's the database that say this error, but what can I do? Because I'm using Linq to Entity, It's not me who write this query.
using (geststockEntities gse = new geststockEntities("name=geststockEntitiesTechnicien"))
            {
                IQueryable<Fournisseurs> fourns = gse.Fournisseurs.Where(f => f.Informations.Contains(prefixText));
                res = new String[fourns.Count()];
 
                int i = 0;
                foreach (Fournisseurs f in fourns)
                {
                    XElement fournisseur = XElement.Parse(f.Informations.ToString());
                    res[i++] = fournisseur.Element("nom") + " (ID #" + f.ID_fournisseur + ")";
                }
            }

Open in new window

LVL 1
NargzulAsked:
Who is Participating?
 
Salim FayadConnect With a Mentor Commented:
try to replace line 2 by the following:

IQueryable<Fournisseurs> fourns = gse.Fournisseurs.Where(f => f.Informations.ToString().Contains(prefixText));

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.