Posts

Reddit API OAuth C# .NET Example

Image
I had a need to connect to the Reddit API via C# .NET, and thought I'd put this little tutorial together since most I found were in java or python. Note: General Reddit OAuth API info:  https://www.reddit.com/dev/api/oauth 1. Go here and make an app:  https://www.reddit.com/prefs/apps 2. Use the values from the app you created above, in this code sample:   gist:  https://gist.github.com/aaronhoffman/b59585d507601b05d8db02493eaaf73e   more info:  https://github.com/reddit/reddit/wiki/OAuth2 3. Make API requests:   gist:  https://gist.github.com/aaronhoffman/b59585d507601b05d8db02493eaaf73e Check out the result here : interactive data visualization Hope this helps, Aaron

VirtualBox Right-Click Windows Taskbar On Mac

Using VirtualBox on my Mac (in windowed mode, not full screen), I noticed that right-click on the Windows taskbar was not working. I commonly use right-click on the task bar to launch an application as administrator, pin an application to the taskbar, etc. I could two-finger click on other windows to get the right-click menu to appear, but that did not work on the taskbar. To get the right-click menu to appear on the windows taskbar, I had to hold down the "host key" which for me was the left Mac command key, and single-finger click the item in the taskbar. Hope this helps! Aaron

ASP.NET MVC 5 User Admin

AKA (for google-fu): asp.net mvc 5 web site administration tool asp.net mvc 5 web configuration tool asp.net mvc 5 identity asp.net mvc 5 membership I have missed the asp.net Web Site Administration Tool that used to be included with Visual Studio. I created an alternative for asp.net mvc 4 you can find here . For asp.net mvc 5, I created an  Azure Site Extension  to provide the same functionality. It can be run from VS on your local machine as well as installed as a site extension on Azure. Links: extension:  https://www.siteextensions.net/packages/AspNetUserMaintenanceAzureSiteExtension/ github repo:  https://github.com/Stonefinch/AspNetUserMaintenanceAzureSiteExtension Hope this helps, Aaron UPDATE These are now published to nuget.org  https://www.nuget.org/packages/AspNetUserMaintenanceAzureSiteExtension/

Gather Metadata For Each Column of SQL Table

Image
Often when working with a new data set I'll run these queries to learn more about each column of data. https://gist.github.com/aaronhoffman/eb30805ee2f5cafc64152dd1def800bd For example, you can run a single query to union together aggregate data on each numeric column. Result looks something like this: Hope this helps, Aaron

Get Line Numbers In Exception Stack Trace

Image
If you want to ensure you get line numbers in your Exception Stack Trace, you need to make sure your project is set up to provide "full" debug info on build. By default, for "Release" configuration, this is set to "pdb-only". Steps to enable: In Visual Studio... 1. Ensure your project is set to "Release" Solution Configuration (or whichever config you use for deployments) 2. Go to Project > Properties > Build 3. Click the Advanced Button in the bottom right. 4. Under Output > "Debug Info", choose "full" from the dropdown. 5. Save all settings and build your project. You will now see line numbers in Exception Stack Traces. Hope this helps, Aaron