Skip to content

Instantly share code, notes, and snippets.

@samjgriffin89
samjgriffin89 / DatabaseExtensions
Created May 1, 2015 21:45
Check to see if a column exists in a datareader
public static bool HasColumn(this IDataRecord dr, string columnName)
{
for (int i = 0; i < dr.FieldCount; i++)
{
if (dr.GetName(i).Equals(columnName, StringComparison.InvariantCultureIgnoreCase)) return true;
}
return false;
}
@samjgriffin89
samjgriffin89 / RsaEncryptionHelper
Created June 26, 2015 19:04
RSA Encryption/Decryption with X509 Certificates
private X509Certificate2 RsaCertificate
{
get
{
var store = new X509Store(StoreName.My, StoreLocation.LocalMachine);
store.Open(OpenFlags.ReadOnly);
var certs = store.Certificates.Find(X509FindType.FindBySubjectDistinguishedName, ConfigurationManager.AppSettings.Get("CertificateSubjectName"), false);
store.Close();
return certs[0];
public static DateTime Truncate(this DateTime dateTime, TimeSpan timeSpan)
{
if (timeSpan == TimeSpan.Zero) return dateTime; // Or could throw an ArgumentException
return dateTime.AddTicks(-(dateTime.Ticks % timeSpan.Ticks));
}