title: How to get project namespace name using Assembly.GetExecutingAssembly().GetName().Name
body: <p>I am creating class library file. In this I embedded stored procedure script file. so I need to take sp data as a string and I have to create in c#. so for this GetManifestResourceStream method need full-name of assemble and script file. so I did . But I did not figure out why my stream object getting null value.</p>
  
  <pre><code>string strNameSpace = System.Reflection.Assembly.GetExecutingAssembly().GetName().Name;
  
  using (Stream stream = Assembly.GetExecutingAssembly()
     .GetManifestResourceStream(strNameSpace + "GP_SOP_AdjustTax.sql")) 
  {
    // Here stream  is null.
  
    using (StreamReader reader = new StreamReader(stream))
    {
      string result = reader.ReadToEnd();
    }
  }
  </code></pre>