when to use with(nolock) and with(rowLock) in sql server

Question

when to use with(nolock) and with(rowLock) in sql server 2008.

 and what is the advantage and disadvantages of using this.

and what impact on performance  of application of using this.

 

i am getting error :- transaction process id was deadlocked on lock resources with another process  and has been detect as deadlock victiom

Answer 1

Provide some code. where you want to do this? At what stage you are now?

Meanwhile,

You can add properties dynamically in two ways,

1. using ExpandoObject

   var dynamicObject = new ExpandoObject();
   dynamicObject.YourPro1 = "Your Value 1";
   dynamicObject.YourPro1 = 1234;

2. using Dictionary

    public class MyClass
   {
       public string Template { get; set; }
       public string Term { get; set; }
       public Dictionary<string, string> Properties{ get; private set; }

      public MyClass()
      {
          Properties= new Dictionary<string, string>();
      }

      public void AddProperty(string key, string value)
      {
             Properties.Add(key, value);
      }
   }

    // to be used like this:
    MyClass instance = new MyClass();
    instance.AddProperty("Email", "[e-mail]");
    instance.AddProperty("Phone", "976856734");

3. using Reflection Emit

    Please read here with Example.