SQLite Invalid cast from 'System.String' to 'System.Guid' about entityframework-extensions HOT 4 OPEN

Hello @eliottrobson ,

Thank you for reporting. We will look at this case to try to support it.

Best Regards,

Jon

from entityframework-extensions.

Hello @eliottrobson ,

Do you need to output the inserted Guid to your custom CustomerID?

If not, you can already fix it by using cfg.AutoMapOutputDirection = false; such as:

context.Customers.BulkMerge(newCustomers, cfg =>
{
	cfg.ColumnPrimaryKeyExpression = x => new { x.CustomerId };
	// IgnoreOnMergeUpdateExpression ==> this one is not required (We do not update the key used)
	cfg.IgnoreOnMergeUpdateExpression = x => new { x.CustomerId };  
	cfg.IgnoreOnMergeInsertExpression = x => new { x.CustomerId };
	cfg.AutoMapOutputDirection = false;

});

Here is an example: https://dotnetfiddle.net/gGxIGu

Let me know if that solves your issue or if you really need to output this value.

Best Regards,

Jon

from entityframework-extensions.

Hello @eliottrobson,

Since our last conversation, we haven't heard from you.

Is everything working as expected?

Let me know if you need more information.

Best regards,
Jon

from entityframework-extensions.

Apologies for not getting back to you sooner but unfortunately we do need to use the ID as part of the rest of the process. We've managed to work around this by not using BulkMerge in this specific part of the application but would be nice to get it fixed so we can take advantage of the performance at scale!

from entityframework-extensions.