c#

ASP.NET MVC EPPlus Download Excel File

by

So I’m using the fancy EPPlus library to write an Excel file and output it to the user to download. For the following method I’m just using some test data to minimize on the code, then I’ll add the code I’m using to connect to database later. Now I can download a file all fine, but when I go to open the file, Excel complains that it’s not a valid file and might be corrupted. When I go to look at the file, it says it’s 0KB big. So my question is, where am I going wrong? I’m assuming it’s with the MemoryStream. Haven’t done much work with streams before so I’m not exactly sure what to use here. Any help would be appreciated!

WebAPI Custom Model binding of complex abstract object

by

This is a tough one. I have an issue with binding a model from JSON. I am attempting to resolve polymorphic-ally the record supplied with the type of record that it will resolve to (I want to be able to add many record types in the future). I have attempted to use the following example to resolve my model when calling the endpoint however this example only works for MVC and not Web API applications.

How to limit a LINQ left outer join to one row

by

I have a left outer join (below) returning results as expected. I need to limit the results from the ‘right’ table to the ‘first’ hit. Can I do that somehow? Currently, I get a result for every record in both tables, I only want to see one result from the table on the left (items) no matter how many results I have in the right table (photos).

Check if 2 URLs are equal

by

Is there a method around that tests if 2 URLs are equal, ie point to the same place.
I am not talking about 2 URLs with different domain names pointing to the same IP address but for example 2 URLs that point to the same .aspx page: