Question
I feel like I'm losing my mind, why is this resulting in an InvalidCastException?
using (var dbContext = CreateDbContext())
{
result = dbContext
.Users
.Where(m => m.UserId.Equals(userId)).SingleOrDefault();
}
In this case, "UserId" is a uniqueidentifier in SQL Server. userId is a System.Guid.
UserId on the C# in the DbSet is also a System.Guid.
Where is it getting SqlString from?
System.InvalidCastException: 'Unable to cast object of type 'System.Data.SqlTypes.SqlString' to type 'System.Data.SqlTypes.SqlGuid'.'
Accepted Answer
Be careful that your entity class fully matches the database definition.
In my case, columns were being matched in order, and some of those in the SQL table were not defined in the C# entity class.
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow