Entity Framework Core / SQL Server Express returning byte array instead of string on m1 mac parallels

Question

Wondering if anyone else is running into an issue with Entity Framework Core throwing an error when reading data from a local SQL Server Express instance that's running on an m1 mac and Parallels?

I get the following error

Unable to cast object of type 'System.Byte[]' to type 'System.String'

The database columns datatypes are all nvarchar, int, or bit. When I change my connection string to our remote SQL Server, there are no issues. Any help with this would be greatly appreciated.

I'm following the recent KB article provided by Parallels to use a local SQL Server Express instance. I copied the database from our remote SQL Server to local for development.

Article here: https://kb.parallels.com/129699/

HKiernan · Accepted Answer · 2024-06-04 03:05:49Z

0

I figured it out... When I copied the database it had carried over the encryption too. Removing this addressed the issue.

answered Jun 4, 2024 at 3:05

HKiernan

652 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Core / SQL Server Express returning byte array instead of string on m1 mac parallels

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related