InvalidCastException: Unable to Cast SqlString to SqlGuid

asp.net-core c# entity-framework-core

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'.'

1
1
11/28/2019 4:20:39 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

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.

0
11/28/2019 1:36:25 PM

Related Questions

Unable to cast Anonymous Type from 'System.Linq.IQueryable' to 'System.Data.Entity.Core.Objects.ObjectQuery'

The following query was working well with EF5 but gives me error with EF6. I use DbContext and CodeFirst....Error raised with EF6:...Unable to cast the type 'System.Linq.IQueryable...1[[<>f__AnonymousType5...4[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Int32, mscorlib, Version=4.0.0.0, Cultur...
c# entity-framework entity-framework-6 linq linq-to-entities
asked by Dan

Unable to cast the type 'DynamicClass1' to type <T>. LINQ to Entities only supports casting EDM primitive or enumeration types

To get the entity itself from a dynamic query you have to use the ...it... keyword, in stead of ...new...:...using (var entities = new vskdbEntities()) { _list = entities.vsk_error_log .OrderBy(entity.Order) .Select("it") // here "it" .Skip(entity.PageSize * entity.PageNumber) .Take(entity.PageSize) ...
.net c# entity-framework entity-framework-6 linq
asked by Gert Arnold

Unable to cast object of type 'System.Linq.Expressions.FieldExpression' to type 'System.Linq.Expressions.ParameterExpression

I am using ...Entity Framework rc1-final... in ...ASP.NET5....I have the following table....public class PlayerComment { [Key] public int Id { get; set; } public int? PeriodId { get; set; } [ForeignKey("PeriodId")] public Period Period { get; set; } public int? PlayerId { get; set; } [ForeignKey("PlayerId")] publ...
entity-framework entity-framework-core linq
asked by dfmetro

Entityframework Core Unable to cast object of type 'System.Int32' to type 'System.Int64'

It was my mistake.. When I first created the table, productNo was bigint and I created the model based on that table. After that somehow (it must be me...) productNo changed to int. It is working just fine after changing productNo back to bigint
c# entity-framework-core sql-server
asked by jong shin

Unable to cast EntityEntry current value

I have the same method in EF 6 and working just fine, but using EF core v1.1.1 is with method throwing an exception like this. Please take a look. ... public virtual T Update(T obj) { try { if (null == obj) throw new ArgumentNullException(nameof(obj)); _context.Set<T>().Attach(obj); var ...
c# entity-framework-core
asked by Robin

InvalidCastException: Can't cast database type bpchar to Char

I am using a PgSQL database with NpgSQL Nuget package. But when it tries to get some data is shows this error...InvalidCastException: Can't cast database type bpchar to Char...I guess that happens because database has a ...char... column, and its like a bug of PgSQL, but wanted to know if anyone of you guys have any idea of how to handle that....p....
c# entity-framework-core npgsql
asked by Ertan Hasani

Unable to cast object of type 'System.Linq.Expressions.MethodCallExpression' to type 'System.Linq.Expressions.LambdaExpression'

I am using EntityFramework and having trouble with the above error. When I invoke ...var documents = docRepository.GetAllSavedDocuments(); var withRatings = documentFilter.GetDocumentsWithRating(documents, 1); ...I get the error in the title....My code is split across a few classes...public class DocRepository { public IQueryable<Document> GetA...
c# entity-framework entity-framework-6 linq sql
asked by bookshopkeeper

ASP.NET Core 3.0 Error 'Unable to cast object of type' while Scaffolding Existing Database

I am using Visual Studio 2019. My application is in ASP.NET Core 3.0....I'm trying to scaffold an existing database from LocalDb using the Package Manager Console with this command: ... Scaffold-DbContext "Server=(localdb)\mssqllocaldb; Database=hamdoonsoft;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Appcontext ...
asp.net-core-3.0 c# entity-framework-core entity-framework-core-3.0 sql
asked by Muhammad Ashikuzzaman

Entity Framework Core DbContext.SaveChanges throws System.InvalidCastException: Unable to cast object of type System.Boolean to type System.Int16

try belove code:...[Required] [Column(TypeName = "BIT")] public bool IsDelete { get; set; }
c# entity-framework-core exception mysql
asked by bdangvnt

Cosmos DB update fails Unable to cast Guid to string

Is there any reason you're using Guid as your id type? In your Todo class you could write it like so:...public class Todo { [JsonProperty("id") public string Id { get; set; } [JsonProperty("description") [Required(ErrorMessage = "Description is required")] public string description { get; set; } } ...I'm assuming that you're us...
asp.net-core azure-cosmosdb entity-framework-core
asked by Will V

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow