So, I've been trying to implement EntityFramework.PartitionedViews all day and I'm not really any further than when I started.
My problem is that I collect large quantities of data (scores of millions of rows per month), so want to partition the data so that it's maintainable as the tables grow. I've found a class library that does this but I'm not really sure how to implement it.
The guide I've been using is: http://datumstream.ca/blog/index.php/2016/05/18/big-data-partitioned-views-using-entity-framework/
The library is https://github.com/GiscardGirard/EntityFramework.PartitionedViews
My issue is that I don't even know where to start. It says that a DbContext should be created for each table, but not how one goes about this. Normally when creating a new db I just create a context and I know how to do that, but creating several contexts at once is more problematic; where do I write the code that implements this?
The guide basically says:
- Create partitioned view config
- Register a type with a DbContext (but only shows the method provided in the library)
- Create partitioned views
It doesn't provide any sample code and i'm super confused. If anyone has any experience with this and can point me in the right direction of how I create my context. How I create the tables (I have three non-relational tables that need going in this azure SQL DB), would I create a library for a context and then have contexts held inside that?
