Databases
StackOverflow2013
Postsdbo
POBest place to put a xml in a solution with few projects
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBest place to put a xml in a solution with few projects
    primarykey
    data
    text
    <p>I have the following solution structure:</p> <p>Portal.DataAccess -> Class library project with methods against database...</p> <p>Portal.DomainEntities -> Class library project (Where i have my storage classes)</p> <p>Portal.Business -> class library (proxy between front end and data access)</p> <p>Portal.Web -> class library with references to web context (system.web.mvc, etc...)</p> <p>Portal.Web.Website1 -> My website 1</p> <p>Portal.Web.Website2 -> My website 2 </p> <p>....</p> <p>Portal.Web.WebsiteN -> My website N </p> <p>All my websites uses the same queries, and i would like to create a file with the following structure:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt; &lt;Queries&gt; &lt;Query&gt; &lt;Name&gt;DetailArticle&lt;/Name&gt; &lt;Value&gt; &lt;![CDATA[ select * from Articles where ID={ID} ]]&gt; &lt;/Value&gt; ..... All my queries here &lt;/Queries&gt; </code></pre> <p>Where do you think is the best place to put this xml file that will be deserialized for use? I think that could be good to have it into Portal.DataAccess as an embedded resource but my issue is that i dont want to access to disk everytime i want to do a query. In addition, this project doesnt contains references to WebContext (so i cannot put this in cache). For this reason i was thinking to put this file on Portal.Web which is a project with common funcionality for all websites.</p> <p>What's your recomendation? Is there any other place (apart from web cache) to put the deserialized class of the xml?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRyan Kohn
    1. USJose3d
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POBest place to put a xml in a solution with few projects
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. CODo you mean that other projects than the DAL is performing queries? If yes, I think you going the wrong way. The dal should contains all data access logic. Higher layers should only call meaningful data access methods. Whatever the implementation is.
      singulars
      1. POBest place to put a xml in a solution with few projects
      1. USSteve B
    2. COThe only project that does real queries (sqlconnection, etc...) is the Data Access proyect. And the Portal.Business is the proxy between front end and data access.
      singulars
      1. POBest place to put a xml in a solution with few projects
      1. USJose3d
    3. COIn this case none projects except DAL should now anything about your queries, and you answered yourself to your question.
      singulars
      1. POBest place to put a xml in a solution with few projects
      1. USvittore
 

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