http://blogs.msdn.com/matt/archive/2008/09/26/sql-ce-3-5-with-linq-to-sql-revisited.aspxA few days ago I made a post about using SQL CE 3.5 with LINQ to SQL .&#160;&#160; I described a way to use connection pooling with SQL CE. A gracious blog reader (Mike Brown)&#160; pointed out a way I could make my solution much simpler by using theen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/matt/archive/2008/09/26/sql-ce-3-5-with-linq-to-sql-revisited.aspx#8969673Tue, 30 Sep 2008 04:06:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:8969673Ivolved<p>Anytime Matt! Like I said, I've read that there are caveats to using that attribute, but I can't find the original post that mentioned it.</p> http://blogs.msdn.com/matt/archive/2008/09/26/sql-ce-3-5-with-linq-to-sql-revisited.aspx#9244390Sat, 20 Dec 2008 23:24:37 GMT91d46819-8472-40ad-a661-2c78acb4018c:9244390George Mavritsakis<p>Your post Mike is amazing!</p> <p>I am just wondering, isn't it supposed for the [ThreadStatic] attribute to be applied on a static property?</p> <p>Thanks!</p> http://blogs.msdn.com/matt/archive/2008/09/26/sql-ce-3-5-with-linq-to-sql-revisited.aspx#9854347Fri, 31 Jul 2009 15:00:48 GMT91d46819-8472-40ad-a661-2c78acb4018c:9854347Stoune<p>Your second version has a one side issue. I can't close this connections once then I open them. &nbsp;</p> <p>In my app SCL CE used as custom doc &nbsp;format and in this case it is possible situation then user start a new document by rewriting old.</p> http://blogs.msdn.com/matt/archive/2008/09/26/sql-ce-3-5-with-linq-to-sql-revisited.aspx#9854359Fri, 31 Jul 2009 15:18:21 GMT91d46819-8472-40ad-a661-2c78acb4018c:9854359Stoune<p>I post updated variant into <a rel="nofollow" target="_new" href="http://paste.pocoo.org/show/131885/">http://paste.pocoo.org/show/131885/</a></p> <p>I simply add a trivial method for closing connection.</p>