DevForce Community Forum : SQLite http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : SQLite Mon, 13 Apr 2026 13:46:12 -700 Sat, 25 Feb 2012 13:13:40 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3298 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ SQLite : Hi Kimj.Thanks , i fixed it, and... http://www.ideablade.com/forum/forum_posts.asp?TID=3298&PID=12812#12812 Author: Sakar SR
Subject: 3298
Posted: 25-Feb-2012 at 1:13pm

Hi Kimj.

Thanks , i fixed it, and it is working.

Have a nice day.
]]> Sat, 25 Feb 2012 13:13:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3298&PID=12812#12812 SQLite : DevForce wraps queries in a TransactionScope... http://www.ideablade.com/forum/forum_posts.asp?TID=3298&PID=12805#12805 Author: kimj
Subject: 3298
Posted: 24-Feb-2012 at 2:08pm

DevForce wraps queries in a TransactionScope by default, so this is probably causing the problem.  You can disable this behavior by modifying the TransactionSettings.Default singleton:
 
   TransactionSettings.Default = new TransactionSettings(System.Transactions.IsolationLevel.ReadCommitted, TimeSpan.FromSeconds(30), false);
 
It's the "false" parameter which disables the TransactionScope.
 
More about TransactionSettings - http://drc.ideablade.com/ApiDocumentation/webframe.html?IdeaBlade.EntityModel~IdeaBlade.EntityModel.TransactionSettings.html.
 
 
 
]]> Fri, 24 Feb 2012 14:08:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3298&PID=12805#12805 SQLite : Is SQLite DB fully supported in... http://www.ideablade.com/forum/forum_posts.asp?TID=3298&PID=12786#12786 Author: Sakar SR
Subject: 3298
Posted: 24-Feb-2012 at 5:59am

Is SQLite DB fully supported in DF 2010 in .Net 4

When i ran this code it gave me this error.

public static SysUser GetUser(EntityManager pManager, string pUserName)
{
try
            {
                var mgr = new eFilerDBEntities(pManager,true);
                var aUser = mgr.SysUsers.Where(p => p.UserName == pUserName).FirstOrNullEntity();
                return aUser;
            }
 catch(Exception p)
            {
                throw p.InnerException;
 
            }          
           
        }

Throws this Error:

"The underlying provider failed on EnlistTransaction."

I using SQLite data base.





]]> Fri, 24 Feb 2012 05:59:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3298&PID=12786#12786