<p>I have a project that I'm currently working on but it currently only supports the .net framework 2.0. I love linq, but because of the framework version I can't use it. What I want isn't so much the ORM side of things, but the "queryability" (is that even a word?) of Linq. </p>

<p>So far the closest is <a href="http://www.llblgen.com/defaultgeneric.aspx" rel="nofollow noreferrer">llblgen</a> but if there was something even lighter weight that could just do the querying for me that would be even better.</p>

<p>I've also looked at <a href="http://www.hibernate.org/343.html" rel="nofollow noreferrer">NHibernate</a> which looks like it could go close to doing what I want, but it has a pretty steep learning curve and the mapping files don't get me overly excited.</p>

<p>If anyone is aware of something that will give me a similar query interface to Linq (or even better, how to get Linq to work on the .net 2.0 framework) I'd really like to hear about it.</p>

[{'answer_id': 7653, 'author': 'Jon Limjap', 'author_id': 372, 'author_profile': 'https://Stackoverflow.com/users/372', 'pm_score': 0, 'selected': False, 'text': '<p>There\'s a way to reference LINQ in the .NET 2.0 Framework, but I have to warn you that it <em>might</em> be against the terms of use/EULA of the framework:</p>\n\n<p><a href="https://stackoverflow.com/questions/2138/linq-on-the-net-20-runtime#2146">LINQ on the .NET 2.0 Runtime</a></p>\n'}, {'answer_id': 7656, 'author': 'Lars Mæhlum', 'author_id': 960, 'author_profile': 'https://Stackoverflow.com/users/960', 'pm_score': 0, 'selected': False, 'text': "<p>First of all. Getting linq itself to work on 2.0 is out of the question. Its possible, but really not something to do outside a testing environment.\n<br /><br />\nThe closest you can get in terms of the ORM/Dynamic Querying part of it, is imho SubSonic, which I'll recommend for anyone stuck in C# 2.0</p>\n"}, {'answer_id': 7710, 'author': 'Will Dean', 'author_id': 987, 'author_profile': 'https://Stackoverflow.com/users/987', 'pm_score': 4, 'selected': True, 'text': '<p>Have a look at this:</p>\n\n<p><a href="http://www.albahari.com/nutshell/linqbridge.html" rel="noreferrer">http://www.albahari.com/nutshell/linqbridge.html</a></p>\n\n<p>Linq is several different things, and I\'m not 100% sure which bits you want, but the above might be useful in some way.  If you don\'t already have a book on Linq (I guess you don\'t), then I found "Linq In Action" to be be good.</p>\n'}, {'answer_id': 7824, 'author': 'lomaxx', 'author_id': 493, 'author_profile': 'https://Stackoverflow.com/users/493', 'pm_score': 0, 'selected': False, 'text': "<p>LinqBridge looks like a pretty nice place to start since I have VS2008, I just need to compile and deploy to a .net 2.0 server.</p>\n\n<p>I've looked at SubSonic and it's also an interesting alternative, but linqbridge seems to provide a much closer fit so I'm not going to have to go and learn a new ORM / query syntax.</p>\n"}, {'answer_id': 8037, 'author': 'Lance Fisher', 'author_id': 571, 'author_profile': 'https://Stackoverflow.com/users/571', 'pm_score': 2, 'selected': False, 'text': '<p>You might want to check out <a href="http://subsonicproject.com/" rel="nofollow noreferrer">Subsonic</a>.  It is an ORM that uses an ActiveRecord pattern.  I\'m pretty sure most of its features work with the .NET Framework 2.0.</p>\n'}, {'answer_id': 8085, 'author': 'Jon Galloway', 'author_id': 5, 'author_profile': 'https://Stackoverflow.com/users/5', 'pm_score': 1, 'selected': False, 'text': "<p>To echo what Lance said - the SubSonic query language has a fluent interface which isn't as pretty as LINQ, but gives you some of the benefits (compile time checking, intellisense, etc.).</p>\n"}, {'answer_id': 31120, 'author': 'Thomas Eyde', 'author_id': 3282, 'author_profile': 'https://Stackoverflow.com/users/3282', 'pm_score': 1, 'selected': False, 'text': "<p>LinqBridge works fine under .NET 2.0, and you get all the Linq extensions and query language. You need VS 2008 in order to use it, but you already knew that.</p>\n\n<p>However, Linq it not an ORM. It's a query syntax. If you want to use Linq to query a database, you will need .NET 3.5. That's because 2.0 does not provide the mechanism needed to convert Linq code to your favorite database query language.</p>\n\n<p>In other words, if an ORM is what you need, <em>LinqBridge will not help you</em>. You need to check out some of the other suggestions provided.</p>\n"}]
['https://Stackoverflow.com/questions/7652', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/493/']