Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I found the approach in the "final edit" works for me as well. However, it's REALLY annoying. It's not just for testing, but any time you want to use TransactionScope with Entity Framework and SQL CE. I want to code once and have my app support both SQL Server and SQL CE, but anywhere I use transactions I have to do this. Surely the Entity Framework team should have handled this for us!</p> <p>In the meantime, I took it one step farther to make it a little cleaner in my code. Add this block to your data context (whatever class you derive from DbContext):</p> <pre><code>public MyDataContext() { this.Connection.Open(); } protected override void Dispose(bool disposing) { if (this.Connection.State == ConnectionState.Open) this.Connection.Close(); base.Dispose(disposing); } private DbConnection Connection { get { var objectContextAdapter = (IObjectContextAdapter) this; return objectContextAdapter.ObjectContext.Connection; } } </code></pre> <p>This makes it a lot cleaner when you actually use it:</p> <pre><code>using (var db = new MyDataContext()) { using (var ts = new TransactionScope()) { // whatever you need to do db.SaveChanges(); ts.Complete(); } } </code></pre> <p>Although I suppose that if you design your app such that all changes are committed in a single call to SaveChanges(), then the implicit transaction would be good enough. For the testing scenario, we want to roll everything back instead of calling ts.Complete(), so it's certainly required there. I'm sure there are other scenarios where we need the transaction scope available. It's a shame it isn't supported directly by EF/SQLCE.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow can I use Sql CE 4 databases for functional tests
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMatt Johnson
    1. USMatt Johnson
    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. 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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COInteresting solution. I just did a workaround where my `IUnitOfWork` class has a `BeginTransaction()` and `EndTransaction(bool commit)` methods. `BeginTransaction` will open the connection if it doesn't exist yet, and `EndTransaction` will allow me to complete or rollback the transaction easily. So far this seems to work as well. Hopefully in the future though I could just use transaction scopes by themselves.
      singulars
      1. PO
      1. USKallDrexx
 

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