private void btnConnect_Click(object sender, EventArgs e)
        {
            ConnectDialog dialog = new ConnectDialog();

            dialog.StartPosition = FormStartPosition.CenterScreen;

            if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                try
                {
                    txtConnect.Text = dialog.Connection.ConnectionString;
                }
                catch
                {
                }
            }
        }

<ul id="left"></ul>

            $('#left').listbox({
                data: '/Data/Index?' + new Date().getTime(),
                width: 200,
                height: 300
            });

            $('#btnAddItem').click(function () {
                $('#left').listbox().addItem({ value: 3, text: 'c' });
            });

            $('#btnAddRange').click(function () {
                $('#left').listbox().addRange([{ value: 4, text: 'd' }, ['5', 'e']]);
            });

            $('#btnClear').click(function () {
                $('#left').listbox().clear();
            });

            $('#btnGetData').click(function () {
                var a = $('#left a:first');
                if (a.size() > 0) {
                    var data = $('#left').listbox().getData(a);
                    alert("{value: '" + data.value + "', text: '" + data.text + "'}");
                }
            });

            $('#btnGetDatas').click(function () {
                alert($('#left').listbox().getDatas().length);
            });

            $('#btnGetSelected').click(function () {
                alert($('#left').listbox().getSelected().length);
            });

            $('#btnReload').click(function () {
                $('#left').listbox().reload({ data: '/Data/Index', ajaxsettings: {
                    data: { id: 'a' }
                }
                });
            });

            $('#btnRemoveItem').click(function () {
                $('#left').listbox().removeItem({ value: 1 });
            });

            $('#btnRemoveRange').click(function () {
                var datas = $('#left').listbox().getDatas();
                $('#left').listbox().removeRange(datas);
            });

            $('#btnSetSelection').click(function () {
                $('#left').listbox().setSelection(1);
            });

            $('#btnCallMethod').click(function () {
                var a = $('#left a:first');
                if (a.size() > 0) {
                    var data = $('#left').listbox('getData', a);
                    alert("{value: '" + data.value + "', text: '" + data.text + "'}");
                }
            });

SELECT [Users].[ID],[Users].[Name],[Supervisors].[Name] AS [SupervisorName] FROM Users LEFT JOIN [Users] AS [Supervisors] ON [Users].[SupervisorID] = [Supervisors].[ID]

    var query = new Select(/*Columns*/).From<User>()
        .LeftOuterJoin<User>("SupervisorID","ID");

SELECT [Users].[ID], [Users].[Name], [Users].[SupervisorID] FROM  INNER JOIN [Users] ON [Users].[SupervisorID] = [Users].[ID]

var provider = ProviderFactory.GetProvider();
var tbUsers = provider.FindOrCreateTable<User>();
var tbSupervisors = provider.FindOrCreateTable<User>();
var colSupervisorID = tbUsers.GetColumn("SupervisorID");
var colID = tbSupervisors.GetColumn("ID");

var query = new Select(/*Columns*/).From(tbUsers).LeftOuterJoin(colSupervisorID,colID);

SELECT [Users].[ID], [Users].[Name], [Users].[SupervisorID] FROM  LEFT OUTER JOIN [Users] ON [Users].[SupervisorID] = [Users].[ID]

		public virtual string GenerateFromList()
		{
			StringBuilder sb = new StringBuilder();
			sb.AppendLine();
			sb.Append(this.sqlFragment.FROM);

			bool isFirst = true;
			foreach (ITable tbl in query.FromTables)
			{
				// EK: The line below is intentional. See: http://weblogs.asp.net/fbouma/archive/2009/06/25/linq-beware-of-the-access-to-modified-closure-demon.aspx
				ITable table = tbl;

				//Can't pop a table into the FROM list if it's also in a JOIN
				if (!query.Joins.Any(x => x.FromColumn.Table.Name.Equals(table.Name, StringComparison.InvariantCultureIgnoreCase)))
				{
					if (!isFirst)
						sb.Append(", ");
					sb.Append(tbl.QualifiedName);
					isFirst = false;
				}
			}
			return sb.ToString();
		} 

		public virtual string GenerateJoins()
		{
			StringBuilder sb = new StringBuilder();

			if (query.Joins.Count > 0)
			{
				sb.AppendLine();
				//build up the joins
				foreach (Join j in query.Joins)
				{
					string joinType = Join.GetJoinTypeValue(this, j.Type);
					string equality = " = ";
					if (j.Type == Join.JoinType.NotEqual)
						equality = " <> ";

					sb.Append(joinType);
					sb.Append(j.FromColumn.Table.QualifiedName);
					if (j.Type != Join.JoinType.Cross)
					{
						sb.Append(" ON ");
						sb.Append(j.ToColumn.QualifiedName);
						sb.Append(equality);
						sb.Append(j.FromColumn.QualifiedName);
					}
				}
			}
			return sb.ToString();
		}

        public string QualifiedName
        {
            get { return Provider.QualifyTableName(this); }
        }

        public static SqlQuery SameTableJoin(this SqlQuery query, IColumn fromColumn, string toTableQualifiedName, Join.JoinType type, string toColumnName = "ID")
        {
            var provider = fromColumn.Provider;

            var tmpTable = new DatabaseTable(toTableQualifiedName, provider);
            tmpTable.FriendlyName = fromColumn.Table.Name;
            var tmpCol = new DatabaseColumn(toColumnName, tmpTable);

            query.Joins.Add(new Join(tmpCol, fromColumn, type));

            if (!query.FromTables.Contains(tmpCol.Table))
            {
                query.FromTables.Add(tmpCol.Table);
            }

            return query;
        }

    public class CleverSqlServerProvider : SqlServerProvider
    {
        public CleverSqlServerProvider(string connectionString, string providerName)
            : base(connectionString, providerName)
        { }

        public override ISqlGenerator GetSqlGenerator(SqlQuery query)
        {
            return new CleverSqlGenerator(query);
        }
    }

    public class CleverSqlGenerator : Sql2005Generator
    {
        public CleverSqlGenerator(SqlQuery query)
            : base(query)
        {
            ClientName = "System.Data.SqlClient";
        }
        public override string GenerateJoins()
        {
            StringBuilder sb = new StringBuilder();

            if (base.Query.Joins.Count > 0)
            {
                sb.AppendLine();
                //build up the joins
                foreach (Join j in base.Query.Joins)
                {
                    string joinType = Join.GetJoinTypeValue(this, j.Type);
                    string equality = " = ";
                    if (j.Type == Join.JoinType.NotEqual)
                        equality = " <> ";

                    sb.Append(joinType);
                    sb.Append(string.IsNullOrEmpty(j.FromColumn.Table.FriendlyName) ? j.FromColumn.Table.QualifiedName : string.Format("[{0}] AS {1}", j.FromColumn.Table.FriendlyName, j.FromColumn.Table.QualifiedName));
                    if (j.Type != Join.JoinType.Cross)
                    {
                        sb.Append(" ON ");
                        sb.Append(j.ToColumn.QualifiedName);
                        sb.Append(equality);
                        sb.Append(j.FromColumn.QualifiedName);
                    }
                }
            }

            return sb.ToString();
        }
    }

        public static void Register(string providerName, Func<string, string, IDataProvider> factoryMethod)
        {
            if (_factories.ContainsKey(providerName))
            {
                _factories.Remove(providerName);
            }

            _factories.Add(providerName, factoryMethod);
        }

            var provider = ProviderFactory.GetProvider();
            var tbUser = provider.FindOrCreateTable<User>();
            var colSupervisorID = tbUser.GetColumn("SupervisorID");

            var query = new Select(/*Columns*/).From<User>()
                .SameTableJoin(colSupervisorID, "Supervisors", Join.JoinType.LeftOuter);

SELECT [Users].[ID], [Users].[Name], [Supervisors].[Name] AS [SupervisorName] FROM [Users] LEFT OUTER JOIN [Users] AS [Supervisors] ON [Users].[SupervisorID] = [Supervisors].[ID]