Re: [MonoTouch] SQLITE TIMED OUT

2013-03-05 Thread asavasamuel
sama446 This may help, here is Linq to SQLite. https://www.kellermansoftware.com/p-47-net-data-access-layer.aspx -- View this message in context: http://monotouch.2284126.n4.nabble.com/SQLITE-TIMED-OUT-tp4657910p4658134.html Sent from the MonoTouch mailing list archive at Nabble.com. __

Re: [MonoTouch] SQLITE TIMED OUT

2012-12-31 Thread Wally McClure
C: monotouch@lists.ximian.com > Subject: Re: [MonoTouch] SQLITE TIMED OUT > > why are you using an adapter are you updating the data?, I would use a reader > as they are much quicker and then if some of the data needs to be updated, > native sql update statements to update e.g. upd

Re: [MonoTouch] SQLITE TIMED OUT

2012-12-30 Thread Alex White
why are you using an adapter are you updating the data?, I would use a reader as they are much quicker and then if some of the data needs to be updated, native sql update statements to update e.g. update tbldata set field1=test where primarykey=1 or use the orm of sql-net which is quick enough

[MonoTouch] SQLITE TIMED OUT

2012-12-30 Thread sama446
I have a database with tables containing more than 1000 lines, when i write a query for sqlite database on MonoTouch. To read data into dataadapter and fill it into datatable. IOS throws an exception at the statement dataadaper.fill(datatable).(TIMED OUT). The query is a simple one to collect 4 col