New Posts New Posts RSS Feed: SQLite
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

SQLite

 Post Reply Post Reply
Author
Sakar SR View Drop Down
Newbie
Newbie
Avatar

Joined: 21-Jul-2010
Location: India
Posts: 39
Post Options Post Options   Quote Sakar SR Quote  Post ReplyReply Direct Link To This Post Topic: SQLite
    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.





Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1390
Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post 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.
 
 
 
 
Back to Top
Sakar SR View Drop Down
Newbie
Newbie
Avatar

Joined: 21-Jul-2010
Location: India
Posts: 39
Post Options Post Options   Quote Sakar SR Quote  Post ReplyReply Direct Link To This Post Posted: 25-Feb-2012 at 1:13pm
Hi Kimj.

Thanks , i fixed it, and it is working.

Have a nice day.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down