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.