public string Content { get; set; }

[MaxLength]
public string Content { get; set; }

[Column(TypeName = "ntext")]
public string Text { get; set; }

Programmatically parsing Transact SQL (T-SQL) with the ScriptDom parser 

WHILE (@pNumber) <> '0'
BEGIN
    SET @number = RIGHT(@pNumber, 3) + 0
     
INSERT INTO @MyNumbers
SELECT 
     @Number / 100 * 100,
 CASE 
   WHEN nbr BETWEEN 10 AND 19 THEN nbr
   ELSE nbr / 10 * 10
 END,
 CASE 
   WHEN nbr BETWEEN 10 AND 19 THEN 0
   ELSE nbr % 10
 END   
FROM (SELECT @Number % 100)S(nbr);

    IF LEN(@pNumber) > 2
        SET @pNumber = LEFT(@pNumber, LEN(@pNumber) -3)
    ELSE
        SET @pNumber = '0'
END

 This type of CollectionView does not support changes to its SourceCollection
from a thread different from the Dispatcher thread

 System.InvalidOperationException: This exception was thrown because the generator for control
'System.Windows.Controls.ListView Items.Count:62' with name '(unnamed)' has received sequence of
CollectionChanged events that do not agree with the current state of the Items collection.
The following differences were detected:  Accumulated count 61 is different from actual count 62.

 private static object _lock = new object();
//...
BindingOperations.EnableCollectionSynchronization(persons, _lock);

public static void EnableCollectionSynchronization(IEnumerable collection, object lockObject)
{
      MethodInfo method = typeof(BindingOperations).GetMethod("EnableCollectionSynchronization",
             new Type[] { typeof(IEnumerable), typeof(object) });
      if (method != null)
      {
         method.Invoke(null, new object[] { collection, lockObject });
      }
}

using System;
using System.Collections;
using System.Collections.ObjectModel;
using System.Collections.Specialized;
using System.Linq;
using System.Windows.Data;
using System.Windows.Threading;

namespace WpfAsyncCollection
{
    public class AsyncObservableCollection<T> : ObservableCollection<T>
    {
        public override event NotifyCollectionChangedEventHandler CollectionChanged;
        private static object _syncLock = new object();

        public AsyncObservableCollection()
        {
            enableCollectionSynchronization(this, _syncLock);
        }

        protected override void OnCollectionChanged(NotifyCollectionChangedEventArgs e)
        {
            using (BlockReentrancy())
            {
                var eh = CollectionChanged;
                if (eh == null) return;

                var dispatcher = (from NotifyCollectionChangedEventHandler nh in eh.GetInvocationList()
                                  let dpo = nh.Target as DispatcherObject
                                  where dpo != null
                                  select dpo.Dispatcher).FirstOrDefault();

                if (dispatcher != null && dispatcher.CheckAccess() == false)
                {
                    dispatcher.Invoke(DispatcherPriority.DataBind, (Action)(() => OnCollectionChanged(e)));
                }
                else
                {
                    foreach (NotifyCollectionChangedEventHandler nh in eh.GetInvocationList())
                        nh.Invoke(this, e);
                }
            }
        }

        private static void enableCollectionSynchronization(IEnumerable collection, object lockObject)
        {
            var method = typeof(BindingOperations).GetMethod("EnableCollectionSynchronization", 
                                    new Type[] { typeof(IEnumerable), typeof(object) });
            if (method != null)
            {
                // It's .NET 4.5
                method.Invoke(null, new object[] { collection, lockObject });
            }
        }
    }
}

public class Page
    {
        public virtual int Id { get; set; }
        public virtual string Title { get; set; }
        public virtual DateTime? CreatedDate { get; set; }
        public virtual DateTime? ModifiedDate { get; set; }
        public virtual string Body { get; set; }
        public virtual string Keyword { get; set; }
        public virtual string Description { get; set; }
        public virtual string Status { get; set; }
        public virtual bool? CommentStatus { get; set; }
        public virtual int? Order { get; set; }
        public virtual User User { get; set; }
        public virtual User EditedByUser { get; set; }
        public virtual ICollection<Comment> Comments { get; set; }
        public virtual int? ParentId { get; set; }
        public virtual Page Parent { get; set; }
        public virtual ICollection<Page> Children { get; set; }
    }

this._pages.ToList().Where(page => page.Parent == null).ToList();

SELECT 
[Extent1].[Id] AS [Id], 
[Extent1].[Title] AS [Title], 
[Extent1].[CreatedDate] AS [CreatedDate], 
[Extent1].[ModifiedDate] AS [ModifiedDate], 
[Extent1].[Body] AS [Body], 
[Extent1].[Keyword] AS [Keyword], 
[Extent1].[Description] AS [Description], 
[Extent1].[Status] AS [Status], 
[Extent1].[CommentStatus] AS [CommentStatus], 
[Extent1].[Order] AS [Order], 
[Extent1].[ParentId] AS [ParentId], 
[Extent2].[Id] AS [Id1], 
[Extent2].[Title] AS [Title1], 
[Extent2].[CreatedDate] AS [CreatedDate1], 
[Extent2].[ModifiedDate] AS [ModifiedDate1], 
[Extent2].[Body] AS [Body1], 
[Extent2].[Keyword] AS [Keyword1], 
[Extent2].[Description] AS [Description1], 
[Extent2].[Status] AS [Status1], 
[Extent2].[CommentStatus] AS [CommentStatus1], 
[Extent2].[Order] AS [Order1], 
[Extent2].[ParentId] AS [ParentId1], 
[Extent2].[User_Id] AS [User_Id], 
[Extent2].[EditedByUser_Id] AS [EditedByUser_Id], 
[Extent1].[User_Id] AS [User_Id1], 
[Extent1].[EditedByUser_Id] AS [EditedByUser_Id1]
FROM  [dbo].[Pages] AS [Extent1]
LEFT OUTER JOIN [dbo].[Pages] AS [Extent2] ON [Extent1].[ParentId] = [Extent2].[Id

create unique nonclustered index idx on dbo.DimCustomer(emailAddress)
where EmailAddress is not null;

  management studio -> select server -> expand Security -> right click Logins ->  select "New Login..."

Right click on db-> properties -> permission -> View Server permission

 public PdfPTable RenderingReportHeader(Document pdfDoc, PdfWriter pdfWriter, IList<SummaryCellData> summaryData)
    {
        var httpCookie = HttpContext.Current.Request.Cookies["FinancialMarine"];
          if (httpCookie != null)
          {
              int requestId = int.Parse(httpCookie.Value);
              var ctx = new clearanceEntities();

              var item = (from d in ctx.CLEARANCE_ITEMS
                          where d.REQUEST_ID == requestId
                          select d).FirstOrDefault();
              if (item != null)
              {
                 
                 
                


                  string imagepath = HttpRuntime.AppDomainAppPath + "tir.JPG";
                  string imagepath2 = HttpRuntime.AppDomainAppPath + "tir2.JPG";

                  var fontPath = AppPath.ApplicationPath + "\\Fonts\\BNAZANIN.TTF";
                  //Environment.GetEnvironmentVariable("SystemRoot") + "\\fonts\\tahoma.ttf";
                  var baseFont = BaseFont.CreateFont(fontPath, BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
                  var tahomaFont = new Font(baseFont, 10, Font.NORMAL, BaseColor.BLACK);

                  PdfPTable table = new PdfPTable(numColumns: 3);

                  table.WidthPercentage = 100;
                  table.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  table.ExtendLastRow = false;

                  Image img = Image.GetInstance(imagepath);
                  Image img2 = Image.GetInstance(imagepath2);

                  PdfPCell c = new PdfPCell(img);
                  c.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  c.Border = 0;


                  table.AddCell(c);

                  c = new PdfPCell(img2);
                  c.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  c.Border = 0;
                  c.Padding = 5;
                  table.AddCell(c);

                  ////////////////////////////////////////////////////////////////////////
                  PdfPTable table2 = new PdfPTable(numColumns: 2);
                  table2.WidthPercentage = 100;

                  table2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  table2.ExtendLastRow = false;

                  PdfPCell cell2 = new PdfPCell(new Phrase("تاریخ:", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase(" ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase("شماره: ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase("TST/F/91-4641 ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase("پیوست: ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  cell2 = new PdfPCell(new Phrase("مدارک ضمیمه ", tahomaFont));
                  cell2.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell2.Border = 0;
                  table2.AddCell(cell2);

                  var cell5 = new PdfPCell(table2);
                  cell5.Colspan = 3;
                  cell5.Border = 0;
                  table.AddCell(cell5);
                  ////////////////////////////////////////////////////////////////////////////////////
                  PdfPCell cell = new PdfPCell(new Phrase("شرکت", tahomaFont));
                  cell.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell.Padding = 10;
                  cell.Border = 0;
                  cell.Colspan = 3;
                  table.AddCell(cell);
                  cell = new PdfPCell(new Phrase("اداره محترم بازرگانی / تدارکات کالا", tahomaFont));
                  cell.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell.Padding = 10;
                  cell.Border = 0;
                  cell.Colspan = 3;
                  table.AddCell(cell);

                  cell = new PdfPCell(new Phrase("با سلام", tahomaFont));
                  cell.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell.Padding = 10;
                  cell.Border = 0;
                  cell.Colspan = 3;
                  table.AddCell(cell);

                  cell = new PdfPCell(new Phrase("با احترام به شرح زیر یک فقره صورتحساب مربوط به ترخیص محمولات آن شرکت جهت اطلاع و صدور دستور مقتضی بحضورتان ایفاد می‌گردد.", tahomaFont));
                  cell.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell.Padding = 10;
                  cell.Border = 0;
                  cell.Colspan = 3;
                  table.AddCell(cell);


                  ////////////////////////////////////////////////////////////////
                  
                  PdfPTable table3 = new PdfPTable(numColumns: 6);
                  table3.WidthPercentage = 100;

                  table3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  table3.ExtendLastRow = false;

                  PdfPCell cell3 = new PdfPCell(new Phrase("کشتی/کامیون", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.CLEARANCE_REQUEST.SHIP_NAME + " " + item.CLEARANCE_REQUEST.TRAVEL_NO, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(" تعداد و نوع بسته بندی", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.QUANTITY.ToString(CultureInfo.InvariantCulture) + " " + item.PACKING_TYPES.PACKING_NAME, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(" شماره پروانه", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.CLEARANCE_REQUEST.PERMIT_NO, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase("شماره بارنامه ", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);


                  cell3 = new PdfPCell(new Phrase(item.CLEARANCE_REQUEST.WAYBILL_NO, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(" وزن(کیلوگرم)", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.TARE_WEIGHT.ToString(CultureInfo.InvariantCulture), tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(" شماره درخواست", tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell3 = new PdfPCell(new Phrase(item.CLEARANCE_REQUEST.REQUEST_NO, tahomaFont));
                  cell3.RunDirection = PdfWriter.RUN_DIRECTION_RTL;
                  cell3.Border = 0;
                  table3.AddCell(cell3);

                  cell = new PdfPCell(table3);
                  cell.Colspan = 3;
                  cell.Border = 0;

                  table.AddCell(cell);
                  return table;
              }
          }
        return null;
        
    }