Charset problems in Entity Framework Core 3.12 Firebird.Core 7.10.1 while filtering or inserting

206 Views Asked by At

Is it possible to set charset for filtering, inserting in Entity Framework not changing database default charset

If I execute raw SQL, filtering works, but if I use objects, it fails if there are special characters.

Working

var sql = string.Format("SELECT * From Products p Where p.Name= '{0}'", productName);
var test = db.Products.FromSqlRaw(sql).FirstOrDefault();

Not working

var product = db.Products.FirstOrDefault(f => f.Name ==productName))

When defining charset in connection string it only works if reading data.

0

There are 0 best solutions below