tag:blogger.com,1999:blog-13472432.post5277573746320254968..comments2017-11-23T06:04:08.309-08:00Comments on C# on the SmartPhone: Keeping SqlCeConnection Open and Thread Safetyjonfroehlichhttp://www.blogger.com/profile/15642573762258876817noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-13472432.post-3163317283174684112011-04-30T10:34:17.739-07:002011-04-30T10:34:17.739-07:00Actually there is a flaw in first approach when ta...Actually there is a flaw in first approach when talking about multiple threads performing transactions. How could be possible to open multiple transactions on the same connection? would overlapping would be an issue?Moin Ahmedhttps://www.blogger.com/profile/07534667943110063594noreply@blogger.comtag:blogger.com,1999:blog-13472432.post-39982756685487217092011-04-19T00:07:06.714-07:002011-04-19T00:07:06.714-07:00Excellent!!!!!!
I am working with SQL CE and a CO...Excellent!!!!!!<br /><br />I am working with SQL CE and a COM Wrapper class.<br /><br />I had issues with reading and inserting records some times due to the threading issue of COM wrapper while using the typed datasets.<br /><br />This SQLWrapper worked like a charm.<br /><br />Thank you for the post :)<br /><br />Yasir GodilAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-13472432.post-57156167581987229122011-02-01T06:06:35.793-08:002011-02-01T06:06:35.793-08:00What about the returned SqlCeDataReader, doesnt it...What about the returned SqlCeDataReader, doesnt it need to use the same lock when calling read?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-13472432.post-46713041365752471362008-09-22T16:18:00.000-07:002008-09-22T16:18:00.000-07:00Hi, good posting, i have been battling with this s...Hi, good posting, i have been battling with this subject for a while now, well for ages and has held me up on my own person projects to the point where I give up for a while then come back some weeks later to re look at it.<BR/> I am just a hobbiest programmer now a days moving from vb6. In the old days I would just create a public variable for my db connections in a modual and ref the connection from there through out the life time of my app.<BR/>The thing that i struggle with is how would you open and keep the connection open in c#, there are so many differant ways to do this and most seem very long winded. The wrapper class you demonstrated I think is the way to go...for me i would get the app to call the open function on load and close on app exit. So thanks for the good posting, it helped me out.<BR/><BR/>RichardUnknownhttps://www.blogger.com/profile/00098330982491551225noreply@blogger.com