Comments (2)
No, this is not possible. The underlying database is NMemory that uses .net expression trees for defining, compiling and executing queries. When you query something with Entity Framework it builds another type of expression tree that ADO.NET providers have to convert into SQL commands. Effort is basically an ADO.NET provider as converts these EF expression trees into .net expression trees under the hood that can be passed to NMemory.
If we wanted to make Effort purely ADO.NET compatible, someone should make it able to interpret SQL commands. This is a much more complex problem than being able to convert EF expression trees and I will certainly not have time to dedicate on this.
from entityframework-effort.
Roger that, I understand that this would be quite a complex endeavour. Too bad that there isn't any in-memory SQL-compliant database for .NET, something like HSQLDB for Java. I ended up using SqlLocalDb, not as fast as in-memory but supports SQL.
from entityframework-effort.
Related Issues (20)
- EffortConnection.RollbackToRestorePoint incorrectly works with identity fields of entities HOT 6
- Target netstandard2.1 HOT 1
- Using multiple EDMX files within a single in-memory connection HOT 4
- In memory db ignores Unique Index HOT 1
- In memory db targeting specific migration HOT 1
- SaveChanges throws exception HOT 4
- FK violation. Value [x] does not exists in the referenced table [t] HOT 1
- How to you create a connection with IdentityDbContext ? HOT 1
- Batch Update is not working with Effort.EF6 HOT 2
- Change Tracking - Single property update of entity seems broken HOT 5
- Exception querying context during unit test HOT 3
- Nested transactions rollback should allow commit on parent transaction. HOT 2
- Z.EntityFramework.Classic.Effort v 2.2.9 is not compatible with NMemory version 3.1.2 HOT 2
- Expose IdentitySpecification so we can change the seed value HOT 3
- Object of type 'a' cannot be converted to type 'b' on Effort.Internal.Common.DatabaseReflectionHelper.InsertEntity HOT 6
- [DatabaseGenerated(DatabaseGeneratedOption.Computed)] Workaround? HOT 10
- Entity Framework Plus - InsertFromQuery command - doesn't wotk HOT 2
- ExecuteSqlCommand can't be used HOT 1
- EffortException when BulkInserting a class with a nullable enum. HOT 6
- Test runs forever without a ToList() on repository query HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from entityframework-effort.