public static void InsertForUniqueId()
        {
            DataContext db  = new DataContext();
            TblCounter  tbl = new TblCounter();

            tbl.count = "1";
            db.TblCounters.InsertOnSubmit(tbl);
            db.SubmitChanges();
            db.Dispose();
        }
        public static int ReturnUniqueId()
        {
            DataContext db  = new DataContext();
            TblCounter  obj = new TblCounter();

            var result = (from e in db.TblCounters
                          orderby e.Id descending
                          select e).FirstOrDefault();

            obj = result;
            if (result != null)
            {
                return(obj.Id);
            }
            else
            {
                return(0);
            }
        }