c.Apelido) .IsRequir" /> c.Apelido) .IsRequir" /> c.Apelido) .IsRequir"/>

Trouble when trying to make a query with entity framework and .net6 and firebird database

99 views Asked by At

Here is the mapping:

builder.Property(c => c.Nome)
    .IsRequired()
    .HasMaxLength(100)
    .HasColumnName("NOME");

builder.Property(c => c.Apelido)
    .IsRequired()
    .HasMaxLength(100)
    .HasColumnName("APELIDO");

Here is my repository:

public async Task<Operadora> ObterPorNome(string nome, string apelido)
{
    return await _db.Set<Operadora>()
        .Where(c => c.Nome.ToLower().StartsWith(nome.ToLower()) 
                 || c.Apelido.ToLower().StartsWith(apelido.ToLower()))
        .FirstOrDefaultAsync();
}

And in the data base has the same length, but when make the query at the repository return the following error:

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error SQL error code = -204 Implementation limit exceeded block size exceeds implementation restriction

Does anyone know what is happening?

I've already tried to increase the length to 300, but it didn't work.

0

There are 0 answers