Dapper ORM .NET Quick Start

I have been using NHibernate for large corporate projects for a while now, but wanted to leverage a lighter ORM for some personal projects.  I did not want the overhead of configuring NHibernate and wanted something "lighter".

I have heard many developers discuss Dapper. I was interested in looking into it, but I do not like InLine SQL. I would rather use LINQ. On GitHub there is a package called SQLinq for Dapper!

The screen shots below (and ZIP file Download) shows using Dapper with Inline SQL and LINQ over a SQL Server Northwind Database. This project is a console app built in Visual Studio 2015.

If you decided to use this sample project you will need to update your connection string. (To keep this simple I am not documenting the connection method here)

1. Create a Customer Entity

2. Dapper Inline SQL Example

3. Dapper LINQ Sample

4. Console App Results

 Download DapperSample.zip C# Console App Source

Alternative for Exchange by TouchDown Android App Symantec

I have been frustrated with the performance of the Exchange TouchDown for Andriod after Symantec bought it out in 2016. When the Exchange TouchDown app was developed and maintained by NitroDesk it was really top notch. Symantec really made a mess of the app. Instead of fixing it, they are shutting it down.

Symantec released an end of life statement "Symantec Corporation hereby informs you that we will be discontinuing the availability of Touchdown by Symantec.  End of Product Life (EOL) 7/3/2017"

THERE IS GOOD NEWS: I have been using the last version 8.5.00086 before Symantec made a huge mess of the Exchange TouchDown for Andriod app.  An alternative to NitroDesk you can use the Outlook app by Mircorsoft for Android (personally I still prefer the NitroDesk TouchDown for Andriod app).

Touchdown Before Symantec: You can download the APK of the last version published by NitroDesk from the link below. This is the free version. If you paid for the full version your key will still work since this is the last version developed by NitroDesk with NO Symantec features at all!

com.nitrodesk.touchdown_v8.5.apk (9.13 mb)

Investing in Bond Funds vs. S&P 500

This post looks at investing in Bond Funds vs. the Stock Market. 

For investors that invest in bonds (not bond funds) they will argue that you should put your money in bonds because bonds mature and bond funds do not. This means if you buy a bond and it sinks in value (as long as it is good quality) the bond will mature and you will get all of your principal back plus the interest earned.   This is very true, but when it comes to 401K Investing you are limited to of course the funds in your 401K.

Setup: Looking at 3 portfolios using Vanguard Bond Funds and SPY.  (one bond fund, two bond funds, and the S&P 500) we will examine returns.

What we see over the long haul is what are are familiar with, that is, the Stock Market has the highest return.  But when you look under the covers what you see are gut-wrenching downturns, and measures that look at investment risk / reward the stock market has a worst risk / return ratio than simple buy and hold bond funds. 

Read More at MTRIG.com