What&#39;s the point of using an optional parameter? `List&lt;T&gt;` is a reference type and if the client doesn&#39;t supply a value it will simply be null:

    public HttpResponseMessage Get(List&lt;long&gt; manufacturerIDs)
    {
        ...
    }

I&#39;m looking to create a comma-separated list of values from a SQL Server 2005 table, just like in [JanetOhara&#39;s question][1].  I&#39;m using a query similar to the one presented in [techdo&#39;s answer][2] to the question.

Everything is working, except the list of values is getting XML encoded.  What should be:

    Sports &amp; Recreation,x &gt;= y

Is instead returning as:

    Sports &amp;amp; Recreation,x &amp;lt;= y

Is there a way to disable the XML character encoding when using &quot;FOR XML&quot; in SQL Server?

  [1]: https://stackoverflow.com/q/12435284/1383298
  [2]: https://stackoverflow.com/a/12435331/1383298

How do I avoid character encoding when using &quot;FOR XML PATH&quot;?

I am working on some CSS where the design calls for page titles (headings) to be centered with horizontal lines that are vertically centered on either side. Further, there is a background image on the page so the background of the title needs to be transparent. 

I have centered the title and I can use pseudo class to create the line. But I need the line disappear when it cross the text of the title. 

I considered using a background gradient that goes transparent where the words are, but since each title could be a different length, I wouldn&#39;t know where to put the stops. 

Here is the CSS so far:

    h1 {  
        text-align: center;  
        position: relative;  
        font-size: 30px;  
        z-index: 1;  
    }  

    h1:after {  
        content: &#39;&#39;;  
    	background-color: red;  
    	height: 1px;  
    	display: block;  
    	position: absolute;  
    	top: 18px;  
    	left: 0;  
        width: 100%;  
    }  

Here is where I&#39;m at: 
http://jsfiddle.net/XWVxk/1/

Can this be done with CSS without adding any extra HTML?

heading with horizontal line on either side

I&#39;m really struggling with this one. I need a generic list parameter for my Get method, but it needs to be optional. I just did this:

    public dynamic Get(List &lt;long&gt; ManufacturerIDs = null)

Unfortunately on runtime i get the error:

&gt; Optional parameter &#39;ManufacturerIDs&#39; is not supported by
&gt; &#39;FormatterParameterBinding&#39;.

How to get a generic list as an optional parameter here?


ASP WebAPI generic List optional parameter

I'm really struggling with this one. I need a generic list parameter for my Get method, but it needs to be optional. I just did this:
<pre><code class="hljs language-csharp">public dynamic Get(List &#x3C;long> ManufacturerIDs = null)
</code></pre>
Unfortunately on runtime i get the error:
> Optional parameter 'ManufacturerIDs' is not supported by
> 'FormatterParameterBinding'.
How to get a generic list as an optional parameter here?

I am new to MVC 4 and I am trying to implement File Upload Control in
my website. I am not able to find the mistake.I am getting a null
value in my file.

Controller:

    public class UploadController : BaseController
        {
            public ActionResult UploadDocument()
            {
                return View();
            }
    
           [HttpPost]
           public ActionResult Upload(HttpPostedFileBase file)
           {
               if (file != null &amp;&amp; file.ContentLength &gt; 0)
               {
                   var fileName = Path.GetFileName(file.FileName);
                   var path = Path.Combine(Server.MapPath(&quot;~/Images/&quot;), fileName);
                   file.SaveAs(path);
               }
    
               return RedirectToAction(&quot;UploadDocument&quot;);
            }
        }

View:

    @using (Html.BeginForm(&quot;Upload&quot;, &quot;Upload&quot;, FormMethod.Post, new { enctype = &quot;multipart/form-data&quot; }))
    { 
        &lt;input type=&quot;file&quot; name=&quot;FileUpload&quot; /&gt;
        &lt;input type=&quot;submit&quot; name=&quot;Submit&quot; id=&quot;Submit&quot; value=&quot;Upload&quot; /&gt;
    }



MVC 4 Razor File Upload

**My Tools:**

**Visual Studio 2012 Ultimate + Update 1**

**ReSharper v7.1.25.234**

**My Solution Build Status:** *Build Successfully*

But when I install ReSharper and ReSharper code analysis is enable, many keywords of my code are red with this error:

**&quot;Cannot resolve symbol XXX&quot;**

![Enter image description here][1]

----
Another picture of my project &gt;&gt;

**The ReSharper “CANNOT RESOLVE SYMBOL” errors are everywhere, but my project build process is successfully, and it works correctly.**

![Enter image description here][2]

**Additional Note:** If I disable ReSharper Code Analysis, my project will be Normal, but I want to use ReSharper code analysis.

------
**I tried** ReSharper → *Options* → *General* → *Clear Cache*. But I still have this problem!

----

 - One month ago, I got these errors when I uninstalled Visual Studio 2012 RC and installed VS 2012 RTM.

 - I&#39;ve already uninstalled and installed ReSharper again. But I have this problem yet!

 - My solution has five projects &gt;&gt; two loaded projects (main project + resource project) and three unloaded projects

----

**I realize that my Visual Studio also has bigger problems** [(More information on Stack&amp;nbsp;Overflow)][3]

 - I can&#39;t add any reference to my projects (even inside new solutions and new projects)

 - I can&#39;t install any package (by &quot;Packet Manager Console&quot; or Manage NuGet Package)

 - I can&#39;t update any package (by &quot;Packet Manager Console&quot; or Manage NuGet Package)

**I&#39;ve done a lot of suggestions (of myself and others)**

 - Re-resister some DLL files

 - Using some windows and registry repair tools

 - Remove ReSharper

 - Repair Visual Studio

 - and...

But I could not solve it.

**I&#39;m thinking of installing a new Windows** :(

-----

**What is wrong, and how can I fix it?**

  [1]: http://i.stack.imgur.com/mtS8B.jpg
  [2]: http://i.stack.imgur.com/IUkrX.jpg
  [3]: https://stackoverflow.com/questions/15746529/mvc-website-package-updating-error-loading-type-library-dll-exception-from-h


ReSharper &quot;Cannot resolve symbol&quot; even when project builds

I wanting to know how to run the &#39;Update-Database&#39; command for a production database.

The &#39;Update-Database&#39; database works fine from my local machine, but how do I get this to work for production data? 

So, if I make a change to my application and then run the &#39;publish&#39; through visual studio this works fine for the code side of things, but how do I run the &#39;Update-Database&#39; command for the production data.

Hope this question makes sense...

Thanks,

Entity framework code first - how to run Update-Database for production database

What are differences between these classes in ASP.NET? As I discovered there is no inheritance relationship between these classes.

Below code returns an instance of `HttpRequestWrapper` which `is a` `HttpRequestBase` and `has a` `HttpRequest`
 
    HttpRequestMessage request = ...;
    HttpRequestBase reqBase = (request.Properties[&quot;MS_HttpContext&quot;] as HttpContextWrapper).Request;
    // do somthing with reqBase.Cookies

It seems like Microsoft wanted to annoy us while reaching cookies from HttpRequestMessage.

Is it guaranteed that `request.Properties[&quot;MS_HttpContext&quot;]` will never be null?

Or think that an ajax request is handled in an action of ApiController. I can reach IP of the client with two different ways.

    var ip = (request.Properties[&quot;MS_HttpContext&quot;] as HttpContextWrapper).Request.UserHostAddress

    var ip = HttpContext.Current.Request.UserHostAddress

What is the difference between these two?

Or in general, I can access same request/response data such as Cookie, Header, Requestor Info etc. in different ways. When to use which? Can we say something like &quot;if it is an ajax request, HttpRequest is not guaranteed to work properly because of lack of something so for ajax requests we should use HttpRequestMessage instead&quot;?

HttpRequest vs HttpRequestMessage vs HttpRequestBase

I am new to Entity Framework.

I have get to some values in my database using EF. It returns perfectly, and the values are shown in labels. But When I delete all values in my table (without using EF), the EF query is returning my old values. I know the EF stores the values in cache and returns the cached data for subsequent runs. Is this correct?  

So how can I solve the problem when I have deleted all values in my database, but EF returns the old values?


**Edit**:

Now i used `datamodel.SaveChanges()`. But now also it&#39;s returning the same old values.

My sample query is look like below:

    SchoolBriefcaseEntities datamodel = new SchoolBriefcaseEntities();
    datamodel.SaveChanges();
    List&lt;Compliance&gt; compliance=new List&lt;Compliance&gt;();
    IList&lt;ComplianceModel&gt; complianceModel;
    if (HttpContext.Current.User.IsInRole(&quot;SuperAdmin&quot;))
    {
        compliance = datamodel.Compliances.Where(c =&gt; c.School.DistrictId == districtId).ToList();
    }


Entity Framework Caching Issue

This error is very common, and I tried all of the solutions and non of them worked. I have disabled WebDAV publishing in control panel and added this to my web config file:

      &lt;handlers&gt;
      &lt;remove name=&quot;WebDAV&quot;/&gt;
      &lt;/handlers&gt;
      &lt;modules runAllManagedModulesForAllRequests=&quot;true&quot;&gt;
      &lt;remove name=&quot;WebDAVModule&quot;/&gt;
      &lt;/modules&gt;

The error still persists. This is the controller:

       static readonly IProductRepository repository = new ProductRepository();

        public Product Put(Product p)
        {
            return repository.Add(p);
        }

Method implementation:

     public Product Add(Product item)
        {
            if (item == null)
            {
                throw new ArgumentNullException(&quot;item&quot;);
            }
            item.Id = _nextId++;
            products.Add(item);
            return item;
        }

And this is where the exception is thrown:

    client.BaseAddress = new Uri(&quot;http://localhost:5106/&quot;);
    client.DefaultRequestHeaders.Accept.Add(
    new MediaTypeWithQualityHeaderValue(&quot;application/json&quot;));      
    var response = await client.PostAsJsonAsync(&quot;api/products&quot;, product);//405 exception

Any suggestions?


405 method not allowed Web API

What&#39;s the best way to set cache control headers for public caching servers in WebAPI?  

I&#39;m not interested in OutputCache control on my server, I&#39;m looking to control caching at the CDN side and beyond (I have individual API calls where the response can be indefinitely cached for the given URL) but everything I&#39;ve read thus far either references pre-release versions of WebAPI (and thus references things that seem to no longer exist, like System.Web.HttpContext.Current.Reponse.Headers.CacheControl) or seems massively complicated for just setting a couple of http headers.

Is there a simple way to do this?

Setting HTTP cache control headers in Web API

How do I catch _all_ unhandled exceptions that occur in ASP.NET Web Api so that I can log them?

So far I have tried:

* Create and register an [`ExceptionHandlingAttribute`](http://weblogs.asp.net/fredriknormen/archive/2012/06/11/asp-net-web-api-exception-handling.aspx)
* Implement an `Application_Error` method in `Global.asax.cs`
* Subscribe to `AppDomain.CurrentDomain.UnhandledException`
* Subscribe to `TaskScheduler.UnobservedTaskException`

The `ExceptionHandlingAttribute` successfully handles exceptions that are thrown within controller action methods and action filters, but other exceptions are not handled, for example:

* Exceptions thrown when an `IQueryable` returned by an action method fails to execute
* Exceptions thrown by a message handler (i.e. `HttpConfiguration.MessageHandlers`)
* Exceptions thrown when creating a controller instance

Basically, if an exception is going to cause a 500 Internal Server Error to be returned to the client, I want it logged. Implementing `Application_Error` did this job well in Web Forms and MVC - what can I use in Web Api?

catch all unhandled exceptions in ASP.NET Web Api

I am starting to learn the webapi and find myself doing stuff that makes sense in an MVC project but may not make sense in.

Normally in an MVC project I make ViewModels and use that as the parameter or pass them back with the view.

Since there are no views in webapi I guess it does not make sense to have a ViewModel as parameter.

I am wondering maybe if I should just have as a Parameter my EF domains(code first) and put data annotations on top of these. I normally would put the annotations over the view model properties as I liked this over the domain.

However what is stopping me from doing this is I am not 100% clear how my MVC site would work. 

Does the MVC site just spit back simples views and then you use Jquery to call your webapi or do you just call MVC action methods that directly just call the same methods the Webapi would call?

If is the second way then I rather put the data annotations on my view model again but then I am putting the same ones on both the EF domain and VM&#39;s and that seem redundant. 



Does it Make Sense to have ViewModels in the Webapi?

I&#39;m troubleshooting a bug with a service I call through .NET&#39;s HttpClient, trying to route the request through a local proxy (Fiddler), but my proxy settings seem to not be taking effect.

Here&#39;s how I create the client:

    private HttpClient CreateHttpClient(CommandContext ctx, string sid) {
        var cookies = new CookieContainer();

        var handler = new HttpClientHandler {
            CookieContainer = cookies,
            UseCookies = true,
            UseDefaultCredentials = false,
            Proxy = new WebProxy(&quot;http://localhost:8888&quot;, false, new string[]{}),
            UseProxy = true,
        };

        // snip out some irrelevant setting of authentication cookies

        var client = new HttpClient(handler) {
            BaseAddress = _prefServerBaseUrl,
        };

        client.DefaultRequestHeaders.Accept.Add(
            new MediaTypeWithQualityHeaderValue(&quot;application/json&quot;));

        return client;
    }

then I send the request by:

    var response = CreateHttpClient(ctx, sid).PostAsJsonAsync(&quot;api/prefs/&quot;, smp).Result;

Request goes straight to the server without attempting to hit the proxy.  What did I miss?


Content Type	Original Author	Original Content on Stackoverflow
Question	Dennis Puzak	View Question on Stackoverflow
Solution 1 - asp.net Mvc	Darin Dimitrov	View Answer on Stackoverflow

ASP WebAPI generic List optional parameter

asp.net Mvc Problem Overview

asp.net Mvc Solutions

Solution 1 - asp.net Mvc

heading with horizontal line on either side

How do I avoid character encoding when using "FOR XML PATH"?

Attributions