Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><a href="http://blog.wekeroad.com/2011/02/16/and-i-shall-call-it-massive/" rel="nofollow">Massive</a> can support this, because it materializes data into <a href="http://msdn.microsoft.com/en-us/library/system.dynamic.expandoobject.aspx" rel="nofollow">ExpandoObject</a>'s:</p> <blockquote> <p>The secret sauce is the ExpandoObject. Everything that goes in and everything that comes out of Massive is an Expando – which allows you to do whatever you want with it. At it’s core, an ExpandoObject is just an IDictionary&lt; string,object ></p> </blockquote> <p>ExpandoObject implements <a href="http://msdn.microsoft.com/en-us/library/s4ys34ea.aspx" rel="nofollow"><code>IDictionary&lt;string, Object&gt;</code></a> and <code>IEnumerable&lt;KeyValuePair&lt;string, Object&gt;&gt;</code>, so you can enumerate and test for members in any way you need to.</p> <p>Massive's default is to issue a <code>SELECT *</code> query, so the ExpandoObject will contain all fields in the table, even those you do not know about.</p> <p>You can get <a href="https://github.com/robconery/massive" rel="nofollow">Massive's current code from Github</a>.</p> <p><a href="http://code.google.com/p/dapper-dot-net/" rel="nofollow">Dapper</a> can also select into dynamic objects, but unlike Massive it can only select data and cannot insert, update, or delete it. EDIT: Reviewing the Dapper docs, it appears it can perform modifications, as it can execute any sql. There is <a href="http://samsaffron.com/archive/2012/01/16/that-annoying-insert-problem-getting-data-into-the-db-using-dapper" rel="nofollow">some more recent information about performing inserts with Dapper</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POORM for use with databases that have semi-flexible schema design
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USquentin-starin
    1. USquentin-starin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POORM for use with databases that have semi-flexible schema design
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COwow "can also select into dynamic objects, but unlike Massive it can only select data and cannot insert, update, or delete it." nothing could be further than the truth.
      singulars
      1. PO
      1. USSam Saffron
    2. CO@SamSaffron: I do not use Dapper, and I thought I recalled when it was initially released it only selected data. I checked the docs when I added Dapper to this answer and from what I could tell that was still the case. I see now that it can simply execute any sql, but that was somewhat obscured in the doc page. I have edited my answer taking your comment under consideration.
      singulars
      1. PO
      1. USquentin-starin
    3. COit does inserts just fine, from the doco: http://code.google.com/p/dapper-dot-net/ "Execute a Command that returns no results public static int Execute(this IDbConnection cnn, string sql, object param = null, SqlTransaction transaction = null)" .. also see: http://samsaffron.com/archive/2012/01/16/that-annoying-insert-problem-getting-data-into-the-db-using-dapper I am working on improving the dapper tag wiki, but the process is slow
      singulars
      1. PO
      1. USSam Saffron
 

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