虽然在DotNet Framework3.5 面世以后，可通过LINQ支持SQL的直接查询，但LINQ只支持SQL系列的，SQL2K,SQL2K5，对于ACCESS,ORACLE,MYSQL等不支持。同时平常的一些工具的创作，对于我们的软件水平也大有好处

        下面附上DBACCESS的整套代码，供大家分享

   public interface IClause
    ...{
        void Add(string name, object val);
        void AddWhere(string name, object val);
        void Clear();
        string TableName ...{ set;}
    }

    public abstract class ClauseFactory
    ...{
        public enum Flag
        ...{
            Insert,
            Update,
            Select,
            Delete,
        }

        Create#region Create

        public static IClause Create(string table, Flag category)
        ...{
            BaseClause ret = null;
            switch (category)
            ...{
                case Flag.Insert:
                    ret = new Insert();
                    break;

                case Flag.Update:
                    ret = new Update();
                    break;

                case Flag.Select:
                    ret = new Select();
                    break;

                case Flag.Delete:
                    ret = new Delete();
                    break;

                default:
                    break;
            }
            if (ret != null)
            ...{
                ret.TableName = table;
            }
            return ret;
        }

        #endregion

        BaseClause#region BaseClause

        private abstract class BaseClause : IClause
        ...{
            private string m_strTable = string.Empty;
            private Where m_oWhere = new Where();

            protected BaseClause()
            ...{
                this.m_strTable = string.Empty;
                this.Clear();
            }

            public virtual void Add(string name, object val)
            ...{
            }