Databases
StackOverflow2013
Postsdbo
POLocal storage layer for Entity Framework?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLocal storage layer for Entity Framework?
    primarykey
    data
    text
    <p>I've been implementing a SQLServer 2005 backed EF solution for the business app I'm working on, and It's been working out fine.</p> <p>I'm encountering a problem in that I want to allow the user to work without a database at all while using the same entities.</p> <p>I don't want to go to local databases for portability reasons. Also, it's easy to send a small database over email if it's just an XML file.</p> <p>So, I know that a DataSet could be stored, and loaded from a XML file, schema and all. Is there some way to use one (or two, or three) XML files as the storage layer of EF?</p> <p>Since Entity Framework is built on top of ADO.Net, I was expecting there to be a XML Data Provider of sorts. Then, the Entity Model could be made to run of an XML file. I came upon the DataSet designer which allowed me to create the schema and save and load from a XML file, but it doesn't slot into EF, since EF uses Object Services instead of DataSet (correct me if I'm wrong. I read it <a href="http://msdn.microsoft.com/en-us/library/cc716791.aspx" rel="nofollow noreferrer">here at MSDN</a>).</p> <p>I did come across the <a href="http://code.msdn.microsoft.com/WilsonXmlDbClient" rel="nofollow noreferrer">WilsonXmlDbClient library</a>, which is supposed to be a XML DataProvider for ADO.Net. It seems old, and I don't really know where to start with it.</p> <p>I know that XML is not anyone's first choice for storing relational data, however, I' m looking to be working with files 1Mb or smaller.</p> <p>TIA</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USbiozinc
    1. USbiozinc
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLocal storage layer for Entity Framework?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POLocal storage layer for Entity Framework?
      1. USSLaks
      1. VTFavorite
    3. VO
      singulars
      1. POLocal storage layer for Entity Framework?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSo I know this doesn't answer your question the way you want it answered, but SQL Express is free . . . why not provide your database as a *.SQL script that builds and loads the database? Fully functional, including schema, stored procedures, data and anything else you need/want . . . no cost, just a single free install from a well known trusted manufacturer.
      singulars
      1. POLocal storage layer for Entity Framework?
      1. USFrank Merrow
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload