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.
__
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
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
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