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

SQLite
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
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: 25-Feb-2012 at 1:13pm
Hi Kimj.

Thanks , i fixed it, and it is working.

Have a nice day.
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1391 		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: 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
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down