Argument data type xml is invalid for argument 1 of len function

Question

Navigation

#1 by (1 votes)

1

I'm mapping a property to the xml-type database using Migrations .

public string Xml { get; set; }

this.Property(t => t.Xml).HasColumnName("Xml").HasColumnType("xml");

However, querying the class using Linq returns the error.

 _context.PreListaPostagemLog.Where(p => p.IdPlp == null && !string.IsNullOrEmpty(p.Xml)).ToList();

Argument data type xml is invalid for argument 1 of len function.

c# .net entity-framework linq migrations

asked by anonymous 23.02.2016 / 14:59

1 answer

score 1 · Accepted Answer

In SQL Server, len() does not work with XML type . You will need to use datalength() in place.

In the Entity Framework, datalength() is used like this:

_context.PreListaPostagemLog
        .Where(p => p.IdPlp == null && SqlFunctions.DataLength(p.Xml) > 0)
        .ToList();