https://www.developerfusion.com/t/sql/tutorials/sort/popularity/ SQL Tutorials & Articles from Developer Fusion http://www.rssboard.org/rss-specification en-GB Fri, 14 Jan 2011 13:37:00 GMT Creating connections and all your data objects are really easy Design-Time, but what if you need it for runtime? Here's how. http://www.developerfusion.com/article/2459/creating-a-database-connection/ http://www.developerfusion.com/article/2459/creating-a-database-connection/ Mon, 28 Oct 2002 12:17:00 GMT Tony Ho Running LINQ queries over databases gets all the limelight, but Jon Skeet reminds us of it's possibilities over object graphs too. http://www.developerfusion.com/article/84468/linq-to-log-files/ http://www.developerfusion.com/article/84468/linq-to-log-files/ Fri, 14 Jan 2011 13:37:00 GMT Jon Skeet Kevin Jones explains how ActiveRecord works in Rails, and in a standalone Ruby application. http://www.developerfusion.com/article/84435/activerecord-for-ruby-and-rails/ http://www.developerfusion.com/article/84435/activerecord-for-ruby-and-rails/ Fri, 16 Jul 2010 10:07:00 GMT Kevin Jones Learn about some of the new features in C# 3.0 including automatic properties, collection initializers, extension methods, lambda expressions and anonymous types. http://www.developerfusion.com/article/7556/new-c-30-language-features/ http://www.developerfusion.com/article/7556/new-c-30-language-features/ Thu, 28 Feb 2008 21:26:00 GMT Scott Guthrie Joydip Kanjilal looks at the problems caused by concurrency when accessing data, both online and offline, and how to overcome them. http://www.developerfusion.com/article/84418/concurrency-handling-techniques-in-adonet/ http://www.developerfusion.com/article/84418/concurrency-handling-techniques-in-adonet/ Thu, 23 Sep 2010 10:54:00 GMT Joydip Kanjilal Completely new to Visual Basic? Overwhelmed with the confusing instructions? Read this tutorial and get a head start - learn what VB is, what you can do with it, how much it costs, and how to get star http://www.developerfusion.com/article/30/visual-basic-tutorial/ http://www.developerfusion.com/article/30/visual-basic-tutorial/ Sat, 14 Jul 2001 23:00:00 GMT James Crowley XML, which is all about tree structures, and LINQ, which is all about querying collections, might not seem to fit together, but Mike James explains that they work together just fine. http://www.developerfusion.com/article/84298/linqing-to-xml/ http://www.developerfusion.com/article/84298/linqing-to-xml/ Fri, 23 Jul 2010 09:22:00 GMT Mike James Ever wondered how the magic "yield" statement works? Jon Skeet digs into the inner workings of C# 2.0 and how this innocuous statement gets you a whole load of "free" generated code for your iterators. http://www.developerfusion.com/article/9397/iterator-blocks-in-c-2-autogenerated-state-machines/ http://www.developerfusion.com/article/9397/iterator-blocks-in-c-2-autogenerated-state-machines/ Wed, 03 Dec 2008 11:50:00 GMT Jon Skeet Persisting objects is all about SLOB (serialized large objects), or so says Dave Wheeler who explains how it's now all so much easier. http://www.developerfusion.com/article/84431/slobbing-about-with-net/ http://www.developerfusion.com/article/84431/slobbing-about-with-net/ Mon, 22 Nov 2010 12:26:00 GMT Dave Wheeler An article for all those like Robert Scoble who would like to be able to drag and drop an item to a folder in their Outlook and post it instantly to their Blog. We also briefly cover web services and talking to Outlook. http://www.developerfusion.com/article/4667/how-to-access-outlook-and-post-to-a-blog-using-c/ http://www.developerfusion.com/article/4667/how-to-access-outlook-and-post-to-a-blog-using-c/ Fri, 11 Feb 2005 13:52:00 GMT Simon Soanes Learn how to allow a user to upload an image to your server and store the binary data in a Microsoft SQL database. http://www.developerfusion.com/article/3905/uploading-images-to-a-database/ http://www.developerfusion.com/article/3905/uploading-images-to-a-database/ Fri, 01 Aug 2003 06:40:00 GMT Dave Wanta Where is Web Development moving to in the future? http://www.developerfusion.com/article/78919/the-next-generation-of-web-development/ http://www.developerfusion.com/article/78919/the-next-generation-of-web-development/ Thu, 01 Jan 2009 00:00:00 GMT James Crowley An introduction to using ADO in C++ - its far simpler than you'd think! http://www.developerfusion.com/article/4033/using-ado-in-c/ http://www.developerfusion.com/article/4033/using-ado-in-c/ Tue, 16 Sep 2003 12:15:00 GMT Randy Charles Morin Kevin Jones thinks that the key idea in Rails is routing. See how this fits in with the MVC pattern and find out more about Rails by reading on. http://www.developerfusion.com/article/84417/rails-mvc-and-routing/ http://www.developerfusion.com/article/84417/rails-mvc-and-routing/ Tue, 02 Nov 2010 11:33:00 GMT Kevin Jones Learn how to retrieve binary data from a database, and stream it directly to a client via a browser. http://www.developerfusion.com/article/3933/retrieving-images-from-a-database/ http://www.developerfusion.com/article/3933/retrieving-images-from-a-database/ Tue, 12 Aug 2003 06:47:00 GMT Dave Wanta Ever wanted to combine the power and ease of the .NET platform with a free database like MySQL? Well thanks to ODBC database functions in ADO.NET it's really easy. This article shows how. http://www.developerfusion.com/article/4635/using-mysql-with-net/ http://www.developerfusion.com/article/4635/using-mysql-with-net/ Thu, 09 Sep 2004 08:34:00 GMT cardinals33 This article illustrates a mixture of common .NET methods for formatting and presenting in a readable fashion any XML document you may encounter. The latest hype with XML Web Services and even the .NET Framework itself relies on XML as its backbone, therefore this is no light matter. http://www.developerfusion.com/article/4078/reading-storing-and-transforming-xml-data-in-net/ http://www.developerfusion.com/article/4078/reading-storing-and-transforming-xml-data-in-net/ Tue, 07 Oct 2003 11:14:00 GMT Dimitrios Markatos If you want to use databases, in VB, Access, ASP or anything else, at some stage you will need to learn SQL. This tutorial shows you how to use this powerful and universal language. http://www.developerfusion.com/article/48/sql-commands/ http://www.developerfusion.com/article/48/sql-commands/ Sat, 14 Jul 2001 14:47:00 GMT James Crowley You've heard the hype - but not given it a shot yet? Kevin Jones explains the background of MVC, DRY and TDD and how to get started with your first Ruby on Rails web app! http://www.developerfusion.com/article/9409/rails-an-introduction/ http://www.developerfusion.com/article/9409/rails-an-introduction/ Mon, 08 Dec 2008 11:05:00 GMT Kevin Jones A very common requirement in an information system is to have a function (or several functions) where the users are able to search the data by selecting freely among many possible criterias. In this text I will look at various techniques to solve this problem. http://www.developerfusion.com/article/7305/dynamic-search-conditions-in-tsql/ http://www.developerfusion.com/article/7305/dynamic-search-conditions-in-tsql/ Sat, 01 Dec 2007 13:46:00 GMT Erland Sommarskog