Is there any way to invoke PowerQuery/M outside of Excel or PowerBI?
Our BI team is really growing to like the [Power Query ETL tool](https://support.office.com/en-us/article/Introduction-to-Microsoft-Power-Query-for-Excel-6E92E2F4-2079-4E1F-BAD5-89F6269CD605?ui=en-US&...
- Modified
- 4 Nov at 22:43
Convert HTML to PDF using HtmlRenderer
I am looking to use HtmlRenderer to convert an HTML file to a PDF file. I have seen it being mentioned on several sites that it is possible. However, I don't seem to be able to find any basic sample c...
- Modified
- 14 Mar at 08:56
MD5CryptoServiceProvider in ASP.NET Core
I have a database with passwords created in the old Identity system. Passwords were hashed using the `MD5CryptoServiceProvider` class. I now need to use these passwords in ASP.NET MVC Core but `MD5Cry...
- Modified
- 4 Nov at 21:4
Why is this custom backstage UI for Word not displaying its user interface?
I have an Office addin which uses the following backstage XML to add custom UI elements into Microsoft Word backstage: ``` <?xml version="1.0" encoding="UTF-8"?> <customUI xmlns="http://schemas.micro...
- Modified
- 8 Nov at 21:8
How do I hide routes I don't control from ServiceStack's SwaggerFeature?
In my example, I'm using the `ApiKeyAuthProvider` and `RegistrationFeature,` which both add new routes to my metadata. I want to use swagger as our main documentation for these services, but I don't ...
- Modified
- 4 Nov at 18:32
IP Security in Asp.Net Core
I am trying to restrict a site by IP address. In previous MVC versions I'd add something like the following to the web.config: ``` <security> <ipSecurity allowUnlisted="false" denyAction="NotFound"...
- Modified
- 4 Nov at 16:23
How to get the value of cell containing a date and keep the original formatting using NPOI
I have an Excel file that I edited using DevExpress and I am reading using NPOI. When I try to get the value of a date cell as string, it does not keep the original value. For example: In a DevExpres...
- Modified
- 12 Nov at 00:23
Nuget: What is the purpose of the <package requireReinstallation /> attribute in packages.config?
I upgraded my C# project (which already had some nuget packages) from 4.0 to 4.5.2. I saw that some `<package />` elements now contain an additional attribute `requireReinstallation="true"`. - What is...
XML serialization force full closing tag on null or empty value
I have class ``` public class Testowa { public string test { get; set; } } ``` When I serialize it without value for test, I get ``` <test/> ``` But I want get ``` <test></test> ``` How ...
- Modified
- 2 May at 08:48
'Newtonsoft' could not be found
I pasted the code from [http://www.codeproject.com/Tips/789481/Bridging-the-Gap-between-Linqpad-and-Visual-Studio](http://www.codeproject.com/Tips/789481/Bridging-the-Gap-between-Linqpad-and-Visual-St...
- Modified
- 8 Dec at 16:58
Xamarin Forms IsVisible false taking up space
I have a list view with a template switcher, and a on a particular item I want it to be hidden so I've used a hidden template. I set the view (or the StackLayout) to be isVisible=false and the HeightR...
- Modified
- 4 Nov at 06:16
C# Dictionary get item by index
I am trying to make a method that returns a name of a card from my Dictionary randomly. My Dictionary: First defined name of the card which is string and second is the value of that card, which is int...
- Modified
- 3 Jan at 19:56
How can I bind output values to my async Azure Function?
How can I bind my outputs to an async function? The usual method of setting the parameter to `out` doesn't work with async functions. ### Example ``` using System; public static async void Run(st...
- Modified
- 20 Jun at 09:12
Incoming Webhook for Private Messages in Microsoft Teams
I can create an incoming webhook from a C# app or PS Script sending a JSON message to channels like MSFT doc explains. However, I want to use my incoming webhook for send JSON messages from my app to ...
- Modified
- 17 Jul at 08:30
How can I read JSON from a StringContent object in an ApiController?
I'm writing an API controller intended to receive and parse the contents of a JSON asynchronous post, and am unable to read the contents of the StringContent object in that post. Here is the section ...
- Modified
- 3 Nov at 18:37
Service Fabric Actor or Service Becomes Inaccessible at Random after Upgrading to SDK 2.3.301
After upgrading from Service Fabric SDK 2.0.135 to 2.3.301, we have started encountering situations where a Service Fabric actor or service is inaccessible in spite of showing as healthy in Service Fa...
- Modified
- 3 Nov at 15:47
Is there an alternative to the Notification pattern for multiple messages and success/failure?
Is there an alternative to the Notification pattern for multiple messages and success/failure? I have a class, OperationResult, that I use to return a `Success` boolean and a list of "error" messages...
- Modified
- 8 Feb at 15:33
What's the equivalent of Javascript's Object.assign() in C#
If I have a C# class And two instances of that class How could I copy the values from both objects to create a new instance of `Foo` that contained the values from both `foo1` and `foo2`? In Javascrip...
- Modified
- 4 Jun at 03:45
How to get all certificates with powershell?
I am trying to get all certificates with powershell. When I set "\$computer\My" as store location below script returns user certificates I think. When I set "\$computer\root" it returns root certifi...
- Modified
- 3 Nov at 11:21
What is a C# solution and how to use it?
I am new to C# (coming from Python and C) and when I start a new project in Monodevelop or Visual Studio, the project is put in a "solution" container. I had a look at Microsoft description of what a...
- Modified
- 3 Nov at 11:7
Using matrix factorization for a recommender system
I'm working on a recommender system for restaurants using an item-based collaborative filter in C# 6.0. I want to set up my algorithm to perform as well as possible, so I've done some research on diff...
- Modified
- 3 Nov at 12:30
ASP.NET Core Configuration Section in Startup
I am migrating a ASP.NET 5 RC1 project to ASP.NET Core, and have come across an interesting issue I've not yet seen, or found a solution for. In order to use configuration settings within Startup I h...
- Modified
- 3 Nov at 13:29
C# Case Sensitivity in Switch-statement
I'm working a little with `switch` statements and want to know how to ignore the case sensitivity when it comes to input values. Here is my code: If I put 'a' in instead of 'A' it returns the default ...
- Modified
- 6 May at 06:15
Azure Function logging using TraceWriter in external library
How can I reuse the `TraceWriter` object available in an Azure Function to log information in an externally referenced library? I tried passing in the object using the constructor and referencing the ...
- Modified
- 7 Jun at 22:5
Expression Cast Error - No coercion operator is defined between types
In my Data Repository I have a base class and derived class as below. ``` public abstract class RepositoryBase<T> : IRepository<T> where T : EntityBase { public async Task<T> FindOneAsync(Expressi...
- Modified
- 11 Aug at 18:48