I spent more than 2 days get these. Hope it help your code shorter

especially in lambda expression.

It works for both structure and reference types.

 1 public static bool IsItemOfCollection<T, TCollection>(this T thisT, TCollection collection) where TCollection : ICollection<T>
 2         {
 3             return collection.Contains(thisT);
 4         }
 5 
 6 public static bool Greater<T>(this T thisT, T obj) where T : IComparable<T>, IEquatable<T>
 7         {
 8             return thisT.CompareTo(obj) > 0;
 9         }
10 
11         public static bool Less<T>(this T thisT, T obj) where T : IComparable<T>, IEquatable<T>
12         {
13             return thisT.CompareTo(obj) < 0;
14         }
15 
16         public static bool GreaterThan<T>(this T thisT, T obj) where T : IComparable<T>, IEquatable<T>
17         {
18             return thisT.CompareTo(obj) >= 0;
19         }
20 
21         public static bool LessThan<T>(this T thisT, T obj) where T : IComparable<T>, IEquatable<T>
22         {
23             return thisT.CompareTo(obj) <= 0;
24         }
25 
26         public static bool NotEquals<T>(this T thisT, T obj) where T : IComparable<T>, IEquatable<T>
27         {
28             return !thisT.Equals(obj);
29         }

        /// <summary>
        /// Convert DataTable to Html Table.
        /// </summary>
        /// <param name="dt">DataTable</param>
        /// <returns>Html string</returns>
        public static string ToHtmlTable(this DataTable dt)
        {
            GridView gridView = new GridView();
            gridView.AutoGenerateColumns = true;
            gridView.DataSource = dt;
            gridView.DataBind();
 
            StringBuilder sb = new StringBuilder();
            StringWriter sw = new StringWriter(sb);
            HtmlTextWriter htw = new HtmlTextWriter(sw);
 
            gridView.RenderControl(htw);
 
            return sb.ToString();
        }

Can't find sequence as Oracle sequence. I did one on Ms SQL server

create a table only one column "id"

CREATE PROCEDURE dbo.GetSeqenceNumber

AS

DECLARE @count decimal

SELECT @count = id FROM JsSequence

UPDATE JsSequence

SET id = @count + 1

SELECT id FROM JsSequence

using System.Web.Script.Serialization;

public static class JsonExtension

    {

        public static T JsonToObject<T>(this string sJson)

        {

            return (T)new JavaScriptSerializer().Deserialize(sJson, typeof(T));

        }

        public static string ObjectToJson(this object obj)

        {

            return new JavaScriptSerializer().Serialize(obj);

        }

    }

折腾了小半天，发现EntLib5.0 reference GAC not work. You can use assembly as reference from EntLib50Src\bin only.

Don't know what is wrong but this way works fine.