Using json as database with EF, how can I link EF and the json file during DbContext initialization?
- by blacai
For a personal testing-project I am considering to create a SPA with the following technologies:
ASP.NET MVC + EF + WebAPI + AngularJS.
The project will make use of small amount of data, so I was thinking I could use just a .json file as storage.
But I am not sure about how to proceed with the link between EF and the json file in the initialization of the DbContext.
I found a stackoverflow related question: http://stackoverflow.com/questions/13899342/can-we-use-json-as-a-database
I know the basics of edit files and store data inside. What I tried is to get the data from the json file in the initilizer method and create the objects one by one.
This is more a doubt about how this works if I save/update an object in the dbcontext, do I need to go through all the elements and add/update it manually? Is it better to rewrite the complete file?
According to this http://stackoverflow.com/questions/7895335/append-data-to-a-json-file-with-php it is not a good practice to use json/XML for data wich will be manipulated.
Anyone has experience with anything similar? Is this a really bad idea and I should use another kind of data-storage?