New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Add Support for InsertFromQuery + InMemory #477
Comments
Hello @groberts71 , We indeed do not support that feature with We will look at what we can do. Best Regards, Jon |
Hello @groberts71 , My developer investigated this issue to find out what it will possible to do and what would be the limitation. First, we would like to understand your scenario to see if we can support it or not. You currently try to insert to the Also how the table name is mapped ( Best Regards, Jon |
Hi Jon, In answer to your questions about the real scenario on our side - (2) The example code was just for illustrative purposes and pared down to absolute bare basics. Maybe I went too far. in removing the destination table mapping.... :-) The zcustomerdest table is mapped within EF (i.e. there is a DbSet definition) (3) We currently use the Table annotation, but can easily switch this to use Fluent API as part of any remediation effort to get this working. Cheers, |
Thank @groberts71 for the additional information. Just wanted to be sure that if we try to work on it that we could support your scenario ;) |
Description
When attempting to use InsertFromQuery with the Microsoft InMemory database it throws the exception below.
Our unit tests at present are based on the InMemory database. We are hoping you might be able to add in support for this rather than us having to find a workaround (or not have unit tests).
Exception
Unhandled exception. System.Exception: Oops! This scenario is not yet support for InsertFromQuery + InMemory.
at
1.(IQueryable
1 , Action1 ) at
1.Execute(IQueryable1 query, Action
1 batchInsertBuilder)at DbContextExtensions.[](IQueryable
1 , Action
1 )at DbContextExtensions.[](IQueryable
1 , String , String , String , Type , Expression
1 )at DbContextExtensions.InsertFromQuery[TEntity](IQueryable
1 query, String tableName, Expression
1 selectExpression)at InsertFromQuery.Program.Main()
Command terminated by signal 6
Fiddle or Project (Optional)
https://dotnetfiddle.net/NfpB4n
Further technical details
The text was updated successfully, but these errors were encountered: