Entity Framework Core - Knowledge Base (KB)

Entity Framework 7 migration: how to get a varchar column with a length greater than 1?

I have the following:...[Table("Countries")] public class Country { public int CountryId { get; set; } [MaxLength(255), Required] public string CountryName { get; set; } [Column(TypeName = "varchar")] public string CountryCode { get;...

EnitityFramework is very slow to compare strings because create a nvarchar sqlparameter instead of varchar

I have this sample query:...context.BarcodeTipiDoc.AsQueryable().Where(d => d.Barcode.CompareTo(minBarcode) > 0); ...That query runs very slow because Entity Framework creates SqlParameter for "minBarcode" as ...nvarchar... instead of ...varchar.......I t...