CodeKeep C# Feed

ConnectionScope

Sat, 26 May 2012 19:45:55 GMT

Description: Create a disposable that will automatically close a connection when it goes out of scope

Link: http://www.codekeep.net/snippets/f4d9205b-e5af-4d7f-9f5f-0d9092154972.aspx

internal class ConnectionScope : IDisposable
{
    private readonly IDbConnection _connection;
    private readonly bool _needToClose;

    public ConnectionScope(IDbConnection connection)
    {
        if (connection == null)
            throw new ArgumentNullException("The parameter 'connection' cannot be null!", "connection");

        _connection = connection;
        if (connection.State != ConnectionState.Open)
        {
            connection.Open();
            _needToClose = true;
        }
    }

    ~ConnectionScope()
    {
        Dispose(false);
    }

    public IDbConnection Connection { get { return _connection; } }

    public void Dispose()
    {
        Dispose(true);
    }

    public void Dispose(bool disposing)
    {
        try
        {
            if (_needToClose && _connection.State == ConnectionState.Open)
                _connection.Close();
            if (disposing) GC.SuppressFinalize(this);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex);
        }
    }
}

Return a IDbConnection for a given ConnectonString name

Sat, 26 May 2012 19:31:53 GMT

Description: Uses DbProviderFactories to weave it's magic

Link: http://www.codekeep.net/snippets/f4da295e-75d4-46ec-a329-036bdd474c66.aspx

// reference System.Configuration.dll

private static IDbConnection GetConnection(string connectionStringName)
{
    var setting = ConfigurationManager.ConnectionStrings[connectionStringName];
    var factory = DbProviderFactories.GetFactory(setting.ProviderName);;
    var result = factory.CreateConnection();

    if (result == null)
        throw new DataException(string.Format("The data-provider '{0}' cannot create a connection!", setting.ProviderName));

    result.ConnectionString = setting.ConnectionString;
    return result;
}

Using a WebClient

Wed, 23 May 2012 10:41:46 GMT

Description: Simple demonstration on using a WebClient

Link: http://www.codekeep.net/snippets/bf4d5ff7-1c8a-42eb-88c0-501185dee953.aspx

private static string ReadWebPage(string url)
{
    string page = null;
    WebClient client = new WebClient();
    try
    {
        using (var stream = client.OpenRead(url))
        {
            if (stream != null)
                using (StreamReader sr = new StreamReader(stream))
                {
                    page = sr.ReadToEnd();
                }
        }
    }
    catch (WebException ex)
    {
        Console.WriteLine(ex);
        return null;
    }
    return page;
}

A simple routine to wait for an object to be assigned

Wed, 09 May 2012 16:03:38 GMT

Description: useful for testing purposes

Link: http://www.codekeep.net/snippets/3ab3b6f6-8ac3-40f3-b93b-a8916337129c.aspx

        private void WaitForAssignment(ref string obj, int millsecondTimeout = 2000)
        {
            DateTime start = DateTime.Now;
            while((DateTime.Now - start).TotalMilliseconds <= millsecondTimeout)
            {
                System.Threading.Thread.Sleep(1);
                if (obj != null) return;
            }
        }

Regex For Replacing Contents Between Tags

Mon, 07 May 2012 17:31:20 GMT

Description: A regular expression used for replacing content between HTML tags.

Link: http://www.codekeep.net/snippets/5df4d269-eaed-48d9-9cd1-b769d223d366.aspx

const string pattern = "(?<=<BEGIN_TAG_GOES_HERE>)(\n|\r|\r\n)(?<content>.+?)(\n|\r|\r\n)(?=</END_TAG_GOES_HERE>)";
var regex = new Regex(pattern);
var result = regex.Replace(fileContents, viewContent);

Object Detection

Mon, 30 Apr 2012 22:01:28 GMT

Description: Applies colour filters to Bitmap Image before using that Bitmap object for object detection which return a rectangle. This rectangle can then be used to track an object or used in a finite state machine for a bang bang robotic controller.

Link: http://www.codekeep.net/snippets/36f3bec5-35f7-4c98-92f0-11df32ff038a.aspx

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Net;
using System.IO;
using System.Threading;
using System.Runtime.InteropServices;
//Requires the AForge Library
using AForge.Imaging.Filters;

//Change to your namespace
namespace detectObject
{
    public class Detection
    {

        /// <summary>
        /// Get camera image and converts it to a bitmap
        /// </summary>
        /// <param name="camImg">Image, saved image from a camera</param>
        /// <returns>Bitmap Image</returns>
        public Bitmap getcamImg(Image newImg)
        {
            System.Drawing.Bitmap bImg = new System.Drawing.Bitmap(newImg);
            return bImg;
        }


        /// <summary>
        /// Filter the image froma HSV colour range
        /// </summary>
        /// <param name="image">Bitmap Image, any suitable image</param>
        /// <returns>Bitmap Image</returns>
        public Bitmap addFilters(Bitmap image)
        {
			//Instantiate new HSL filter 
            AForge.Imaging.Filters.HSLFiltering hslFilter = new AForge.Imaging.Filters.HSLFiltering();
			
			//Define HSL colour range (default colour is orange)
            hslFilter.Hue = new AForge.IntRange(0, 50);
            hslFilter.Saturation = new AForge.DoubleRange(0.7, 1);
            hslFilter.Luminance = new AForge.DoubleRange(0.2, 0.7);

	    //Instantiate new RGB filter 
            /*AForge.Imaging.Filters.ColorFiltering rgbFilter = new AForge.Imaging.Filters.ColorFiltering();
			
	    //Define RGB colour range (default colour is orange)
            rgbFilter.Red = new AForge.IntRange(60, 180);
            rgbFilter.Green = new AForge.IntRange(10, 80);
            rgbFilter.Blue = new AForge.IntRange(5, 25);*/

	    //Apply the HSL filter to the input image
            hslFilter.ApplyInPlace(image);
			
	    //Create a 5 by 5 matrix using a short array
            int rows = 5;
            int cols = 5;
            short[,] Matrix = new short[rows, cols];

            for (int i = 0; i < rows; i++)
                for (int j = 0; j < cols; j++)
                    Matrix[i, j] = 1;
			
			//Instantiate new dilate filter with the 5 by 5 matrix
			AForge.Imaging.Filters.Dilatation dilate = new AForge.Imaging.Filters.Dilatation(Matrix);
			//Apply the filter
			dilate.ApplyInPlace(image);

            return image;
        }

        /// <summary>
        /// Apply rectangle to image
        /// </summary>
        /// <param name="image">Bitmap, any suitable image</param>
        /// <returns>Rectangle</returns>
        public Rectangle DrawRectangle(Bitmap image)
        {
	    //Instantiate new blob counter
            AForge.Imaging.BlobCounter detectBlob = new AForge.Imaging.BlobCounter();

            //Get object by size
            detectBlob.ObjectsOrder = AForge.Imaging.ObjectsOrder.Size;
			
	    //Apply BlobCounter
            detectBlob.ProcessImage(image);

            //objects in an array.0
            Rectangle[] rects = detectBlob.GetObjectsRectangles();
			
	    //Create graphics from image
            Graphics g = Graphics.FromImage(image);

            try
            {
		//Draw rectangle around largest rectangle (default colour is red)
                g.DrawRectangle(new Pen(Color.Red), rects[0]);
				
		//Optional to save the result image to the startup directory
                //string startupPath = System.IO.Directory.GetCurrentDirectory();
                //image.Save(startupPath + @"\nameyourfile.jpg");
				
		//Return the rantngla
                return rects[0];

            }
            catch (IndexOutOfRangeException e)
            {
		//If no blobs return empty rectangle
                Rectangle rrr = new Rectangle(0, 0, 0, 0);
                return rrr;
            }


        }
    }

}

Test

Tue, 24 Apr 2012 10:09:10 GMT

Description: test face

Link: http://www.codekeep.net/snippets/bbefe6ee-b4b2-4780-98db-6b13886130d2.aspx

using DataContext 
{
	DBContext context=new DBContext();
}

Create a C-style union

Tue, 24 Apr 2012 08:54:26 GMT

Description: This Visual C# code snippet uses the ExplicitLayout attribute to layout a struct explicitly and create a C-style union.

Link: http://www.codekeep.net/snippets/d8e84db3-b835-478b-9e45-d48c459f6307.aspx

using System.Runtime.InteropServices;
...
[StructLayout(LayoutKind.Explicit)]
internal struct Union
{
   [FieldOffset (6)] internal byte byteData;
   [FieldOffset (0)] internal string stringText;
   [FieldOffset (4)] internal short unionShort;
   [FieldOffset (4)] internal byte lowByte;
   [FieldOffset (5)] internal byte highByte;
}
 
public class TestUnion
{
   public static void Main( )
   {
      Union union = new Union ();
      union.stringText = "Union";
      union.byteData   = 0xFF;
      union.lowByte    = 0x01;
      union.highByte   = 0x01;
      Console.WriteLine (union.unionShort + " = " + 
         (union.highByte * 256 + union.lowByte).ToString());
   }			
}

C# Case Insensitive String Replace

Tue, 17 Apr 2012 20:13:21 GMT

Description: Replace string A inside string B using string C, no attention is paid to the case.

Link: http://www.codekeep.net/snippets/89332015-9377-4390-8571-2d2f40df9b51.aspx

        #region " Case-Insensitive String Replace "

        /// <summary>
        /// replace text in a string without consideration for the case of the input
        ///   string or the find string
        /// </summary>
        /// <param name="input">the string to search</param>
        /// <param name="oldText">the text to find and replace</param>
        /// <param name="newText">the text that replace the 'old' text</param>
        /// <returns>a new string with the replaced text</returns>
        public static string ReplaceText(string input, string oldText, string newText)
        {
            if (string.IsNullOrEmpty(input))
                return input;
            if (string.IsNullOrEmpty(oldText))
                return input;

            // build the case insensitive regx to use
            var regxBuilder = new StringBuilder("(");
            for (var i = 0; i < oldText.Length; i++)
                regxBuilder.AppendFormat("[{0}{1}]", oldText.Substring(i, 1).ToLower(), oldText.Substring(i, 1).ToUpper());
            regxBuilder.Append(")");

            // perform the replacement
            var result = System.Text.RegularExpressions.Regex.Replace(input, regxBuilder.ToString(), newText);
            return result;
        }

        #endregion

Get Date From String with SQL Min check

Wed, 04 Apr 2012 19:00:11 GMT

Description: Get Date From String with SQL Min check

Link: http://www.codekeep.net/snippets/2bed0d69-b15e-4204-a522-617d083f0a14.aspx

        public static DateTime GetDateFromDateString(string date, out string resultMessage)
        {
            resultMessage = String.Empty;
            DateTime resultDate;
            // Do the Parsing first in order to fill-in the resultDate variable
            if (!DateTime.TryParse(date, out resultDate))
            {
                // Badly formatted dates or text in date fields will not parse
                resultMessage = "Improperly formatted Date.";
            }
            else if (resultDate > new DateTime(DateTime.Parse("12/31/9999 11:59:59 PM").Ticks) || resultDate < new DateTime(DateTime.Parse("1/1/1753 12:00:00 AM").Ticks))
            {
                // MSSQL date Min and Max differ from DateTime Min and Max. Eventhough the object creates without error,
                // the SQL will raise Exception on date range
                resultMessage = "Date must be between 1/1/1753 and 12/31/9999";
            }

            return resultDate;
        }

Load DataTable to Crystal Report

Fri, 30 Mar 2012 23:05:10 GMT

Description: Load DataTable to Crystal Report

Link: http://www.codekeep.net/snippets/f1b43cc2-a18d-4671-88a4-e7508892601b.aspx

my_rpt objRpt;
            // Creating object of our report.
            objRpt = new my_rpt();

            String ConnStr = "SERVER=mydb;USER ID=user1;PWD=user1";

            OracleConnection myConnection = new OracleConnection(ConnStr);

            String Query1 = "select a.PROJECT_ID,a.PROJECT_NAME,b.GROUP_NAME from 
            tbl_project a,tbl_project_group b where a.group_code= b.group_code";

            OracleDataAdapter adapter = new OracleDataAdapter(Query1, ConnStr);

            DataSet Ds = new DataSet();

            // here my_dt is the name of the DataTable which we 
            // created in the designer view.
            adapter.Fill(Ds, "my_dt");

            if (Ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("No data Found", "CrystalReportWithOracle");
                return;
            }

            // Setting data source of our report object
            objRpt.SetDataSource(Ds);

            CrystalDecisions.CrystalReports.Engine.TextObject root;
            root = (CrystalDecisions.CrystalReports.Engine.TextObject)
                 objRpt.ReportDefinition.ReportObjects["txt_header"];
            root.Text = "Sample Report By Using Data Table!!";

            // Binding the crystalReportViewer with our report object. 
            crystalReportViewer1.ReportSource = objRpt;

Export Crystal Report to PDF

Fri, 30 Mar 2012 23:04:20 GMT

Description: Export Crystal Report to PDF

Link: http://www.codekeep.net/snippets/6fd44e27-2581-4b02-8fa3-f6a28ed0f4d6.aspx

try
            {
                ExportOptions CrExportOptions ;
                DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
                PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
                CrDiskFileDestinationOptions.DiskFileName = "c:\\csharp.net-informations.pdf";
                CrExportOptions = cryRpt.ExportOptions;
                {
                    CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
                    CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
                    CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
                    CrExportOptions.FormatOptions = CrFormatTypeOptions;
                }
                cryRpt.Export();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

Switch & Enum

Fri, 30 Mar 2012 15:02:01 GMT

Description: How use switch with enum

Link: http://www.codekeep.net/snippets/1578ab10-1a99-4036-8370-a5f41fd993b9.aspx

enum Action
{
  NoAction,
  Save,
  Load,
  Open
}
 
Hashtable keybinds = new HashTable();
 
keybinds.Add(Keys.S, Action.Save);
keybinds.Add(Keys.O, Action.Save);
// .. and so on
 
switch (keybinds[pressedKey])
{
  case Action.Save:
    // do stuff
    break;
  // and so on
}

CreateSalt

Thu, 29 Mar 2012 19:09:39 GMT

Description: Create a salt for password hash

Link: http://www.codekeep.net/snippets/41088e1b-1626-4a03-b3fa-1218b1140400.aspx

private static string CreateSalt(int size)
{
  // Generate a cryptographic random number using the cryptographic
  // service provider
  RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
  byte[] buff = new byte[size];
  rng.GetBytes(buff);
  // Return a Base64 string representation of the random number
  return Convert.ToBase64String(buff);
}

HashString

Thu, 29 Mar 2012 19:03:29 GMT

Description: Hash a string

Link: http://www.codekeep.net/snippets/03455414-e9ce-411e-9f0b-c8691d860f3d.aspx

public static string HashString(string inputString, string hashName)
{
    HashAlgorithm algorithm = HashAlgorithm.Create(hashName);
    if (algorithm == null)
    {
        throw new ArgumentException("Unrecognized hash name", "hashName");
    }
    byte[] hash = algorithm.ComputeHash(Encoding.UTF8.GetBytes(inputString));
    return Convert.ToBase64String(hash);
}

Entities

Wed, 28 Mar 2012 03:05:44 GMT

Description: Entities m?u

Link: http://www.codekeep.net/snippets/7f478f67-6483-4f34-8515-0a111d515442.aspx

public class BankTransactionEntities : BaseTransactionEntities
    {
        #region Public Properties
        /// <summary>
        /// Gets or sets bank transaction item list
        /// </summary>
        public BOSList<ACBankTransactionItemsInfo> BankTransactionItemList { get; set; }
        #endregion

        #region Constructor
        public BankTransactionEntities()
            :base()
        {
            BankTransactionItemList = new BOSList<ACBankTransactionItemsInfo>();
        }
        #endregion

        #region Init Main Object,Module Objects functions
        public override void InitMainObject()
        {
            MainObject = new ACBankTransactionsInfo();
            SearchObject = new ACBankTransactionsInfo();
        }

        public override void InitModuleObjects()
        {
            ModuleObjects.Add(TableName.ACBankTransactionItemsTableName, new ACBankTransactionItemsInfo());
        }

        public override void InitModuleObjectList()
        {
            BankTransactionItemList.InitBOSList(
                                                    this,
                                                    TableName.ACBankTransactionsTableName,
                                                    TableName.ACBankTransactionItemsTableName,
                                                    BOSList<ACBankTransactionsInfo>.cstRelationForeign);
            BankTransactionItemList.ItemTableForeignKey = "FK_ACBankTransactionID";
        }

        public override void InitGridControlInBOSList()
        {
            BankTransactionItemList.InitBOSListGridControl();
        }

        public override void SetDefaultMainObject()
        {
            base.SetDefaultMainObject();
            ACBankTransactionsInfo objBankTransactionsInfo = (ACBankTransactionsInfo)MainObject;
            objBankTransactionsInfo.FK_GECurrencyID = BOSApp.CurrentCompanyInfo.FK_GESaleCurrencyID;
            objBankTransactionsInfo.ACBankTransactionExchangeRate = BOSApp.CurrentCompanyInfo.CSCompanySaleExchangeRate;
        }

        public override void SetDefaultModuleObjectsList()
        {
            try
            {
                BankTransactionItemList.SetDefaultListAndRefreshGridControl();
            }
            catch (Exception)
            {
                return;
            }
        }

        #endregion

        #region Invalidate Main Objects functions
       
        public override void InvalidateMainObject(int iObjectID)
        {
            base.InvalidateMainObject(iObjectID);

        }

        public override void InvalidateModuleObjects(int iObjectID)
        {
            BankTransactionItemList.Invalidate(iObjectID);
        }
        #endregion

        #region Save Module Objects and Main Object functions
        public override int SaveMainObject()
        {
            return base.SaveMainObject();
        }
        public override void SaveModuleObjects()
        {
            BankTransactionItemList.SaveItemObjects();
        }
        #endregion

        #region Accounting
        public override bool CreateAccountingData()
        {
            bool isComplete = AccountHelper.SaveAccountAndRelativeAccount(this, ACDocumentList);
            return isComplete;
        }
        #endregion
    }

Generating an Dictionary of XElement

Tue, 13 Mar 2012 00:55:37 GMT

Description: a LINQPad script

Link: http://www.codekeep.net/snippets/dfe8fa85-9329-433f-a075-017b86b7fdd3.aspx

var dictionaryDeclarationStatement = new CodeVariableDeclarationStatement (
    typeof(Dictionary<int, XElement>),
    "EXElementDictionary",
    new CodeObjectCreateExpression ( typeof(Dictionary<int, XElement>) ) );
    
var provider = CodeDomProvider.CreateProvider("CSharp");
provider.GenerateCodeFromStatement(dictionaryDeclarationStatement, Console.Out, null);

Using a CodeIndexerExpression

Tue, 13 Mar 2012 00:51:48 GMT

Description: a LINQPad script

Link: http://www.codekeep.net/snippets/61f3d462-51df-487d-b91b-0076dc94216b.aspx

var typeRef = new CodeTypeReference(typeof(List<XElement>));
var typeRefExpr = new CodeTypeReferenceExpression(typeRef);
var provider = CodeDomProvider.CreateProvider("CSharp");
provider.GenerateCodeFromExpression(typeRefExpr, Console.Out, null);

Console.WriteLine();

var indexerExpr = new CodeIndexerExpression(new CodeSnippetExpression("EXElement"), new CodePrimitiveExpression(2));
provider.GenerateCodeFromExpression(indexerExpr, Console.Out, null );

XPath parsing with regular expressions 2

Tue, 13 Mar 2012 00:49:06 GMT

Description: Parse an XPath expression using regular expressions XPathAtomRegex is a compiled Regex using the expression in the preceding comment

Link: http://www.codekeep.net/snippets/847a80c0-3ead-445e-b5aa-7d313adbfefc.aspx

var path = "A/B[0]";
//var re = new Regex(@"(?<elementName>\w+)(?<subscript>\[(?<position>\d+)\])?", RegexOptions.Compiled);
var re = new XPathAtomRegex();

var matches = re.Matches(path);
var lastMatch = matches[matches.Count - 1];

path.Substring(0, lastMatch.Groups["elementname"].Index).Dump("elementName");
lastMatch.Value.Dump("lastMatch.Value");
var g = lastMatch.Groups["subscript"];
path.Substring(0, g.Index).Dump("elementPath");
lastMatch.Groups["position"].Dump("position group");

lastMatch.Dump();

Convert Base64 String to File

Sun, 11 Mar 2012 15:27:56 GMT

Description: A LINQPad snippet for converting a Base64 string to a file

Link: http://www.codekeep.net/snippets/49dfdfc5-39a6-4df9-b814-467969b0f7fe.aspx

void Main()
{
	ConvertFromBase64String();
}

void ConvertFromBase64String()
{
	string fileName = GetSaveFileName();
	if ( fileName == null )
	{
		MessageBox.Show("No file name specified");
	}
	else
	{
		ConvertFromBase64String(fileName);
	}
}

void ConvertFromBase64String(string saveFileName)
{
	ConvertFromBase64String(Clipboard.GetText(), saveFileName);
}

void ConvertFromBase64String(string input, string saveFileName)
{
	var contents = Convert.FromBase64String(input);
	
	using (var fs = new FileStream(saveFileName, FileMode.Create, FileAccess.Write))
	{
		fs.Write(contents, 0, contents.Length);
		fs.Flush();
	}
}

string GetFileName(FileDialog fd)
{
	bool? result = fd.ShowDialog();
	if ( result != null && result.Value )
	{
		return fd.FileName;
	}
	return null;
}

string GetOpenFileName()
{
	var ofd = new OpenFileDialog { Title = "Select text file", Filter = "All files (*.*)|*.*",
		RestoreDirectory = true };
	return GetFileName(ofd);
}

string GetSaveFileName()
{
	var sfd = new SaveFileDialog { Title = "Save file as", Filter = "All files (*.*)|*.*",
		RestoreDirectory = true };
	return GetFileName(sfd);
}

3rd Party Assembly Signing

Fri, 09 Mar 2012 09:02:07 GMT

Description: When referencing a 3rd party dll that is not signed you will not be able to sign your project. Use the following instructions to sign the 3rd party assembly.

Link: http://www.codekeep.net/snippets/015cb5e2-1e18-45fc-bbf6-fd68f1e95b1c.aspx

Signing an unsigned Assembly

1. Open VS Console

2. Change DIR to location of dll to sign

3. Disassemble
	ildasm /all /out=AssemblyName.il AssemblyName.dll

4. Reassemble using your snk
	ilasm /dll /key=SNKNAME.snk AssemblyName.il
	
Where AssemblyName is the name of your assembly.

DONE...!

Get ASPX page Name

Thu, 08 Mar 2012 20:14:27 GMT

Description: Gets name of a web page file ending with .aspx

Link: http://www.codekeep.net/snippets/bc4b156c-e8a8-42e9-b049-eb62d06f093b.aspx

        /// <summary>
        /// Returns the ASPX page name
        /// </summary>
        /// <param name="Pg">The HTTP webpage object</param>
        /// <returns>name of the page as in "Orders.aspx"</returns>
        /// <remarks>Used for IRIS_GUIComponets table where each page can have components enabled, disabled, and so on.. controlled by the Database</remarks>
        public static string GetASPXPageName(Page pg)
        {
            string sPath = pg.Request.Url.AbsolutePath;
            string[] strarry = sPath.Split('/');
            int lengh = strarry.Length;
            string sRet = strarry[lengh - 1];
            return sRet;
        }

How to Save Code First Using Store Procedures in the Entity Framework

Fri, 02 Mar 2012 09:07:05 GMT

Description: Shows how I managed to get the entity framework to save entities via a store procedure. As a side note also shows you how to stop an entity from being deleted by accident.

Link: http://www.codekeep.net/snippets/e409b993-5d9a-45cb-a06b-3927cfd9b713.aspx

public class MyContext : DbContext
{
        public override int SaveChanges()
        {
            int result = 0;

            var entities = ChangeTracker.Entries<MyEntity>();
            result += SavEntity(entities );

            return result + base.SaveChanges();
        }

        private int SaveCards(IEnumerable<DbEntityEntry<MyEntity>> cards)
        {
            int result = 0;

            foreach (var entry in entities)
            {
                if (entry.State == EntityState.Added)
                {
                    var storeProc = new SaveEntityProcedure(Database.Connection.ConnectionString);
                    var exResult = storeProc.Execute(entry.Entity);
                    if (exResult == 0)
                        throw new Exception(String.Format("The save command for MyEntity '{0}' failed!", entry.Entity.Id));
                    result += 1;

                    entry.State = EntityState.Unchanged;

                    if (Tracing.TraceSwitch.TraceVerbose) Trace.TraceInformation(string.Format("Added MyEntity Id {0}", entry.Entity.Id));
                }
                else if (entry.State == EntityState.Modified)
                {
                    var storeProc = new UpdateCardStoreProcedure(Database.Connection.ConnectionString);
                    var exResult = storeProc.Execute(entry.Entity);
                    if (exResult == 0)
                        throw new CardDataException(String.Format("The update command for MyEntity '{0}' failed!", entry.Entity.Id));
                    result += exResult;
                    
                    // trick to ensure the entity framework doesn't 'undo' changes when State is set to unchanged.
                    entry.State = EntityState.Added;
                    entry.State = EntityState.Unchanged;

                    if (Tracing.TraceSwitch.TraceVerbose) Trace.TraceInformation("Updated MyEntity Id {0}", entry.Entity.Id);
                }
                else if (entry.State == EntityState.Deleted)
                {
                    throw new Exception(string.Format("Cannot delete a MyEntity ({0})!", entry.Entity.Id));
                }
            }

            return result;
        }
}

Get the PropertyInfo via an Expression

Wed, 29 Feb 2012 09:21:54 GMT

Description: Retrieves the PropertyInfo for a given lambda expression

Link: http://www.codekeep.net/snippets/f72550cf-3a81-4825-99a0-3b1f27ebf91f.aspx

MemberExpression memberExpression = expression.Body as MemberExpression;
if (memberExpression == null)
{
    UnaryExpression ubody = (UnaryExpression)expression.Body;
    memberExpression = ubody.Operand as MemberExpression;
} 
if (memberExpression == null || (memberExpression.Member as PropertyInfo) == null)
{
    throw new ArgumentException(string.Format("The Expression {0} is not a member expression for a property", expression));
}

C# PLINQ File / Directory Delete Routine

Thu, 23 Feb 2012 08:12:08 GMT

Description: Parallel delete routine using PLINQ.

Link: http://www.codekeep.net/snippets/a1338f86-8123-473e-b047-c464d25dfe78.aspx

        /// <summary>
        /// use PLINQ to delete files from the system (1 operation per cpu core)
        /// </summary>
        /// <param name="directoryPath">the top level path to delete</param>
        /// <returns>the number of deleted files on success (0+), or -1 for failure</returns>
        public static int DeleteDirectory(string directoryPath)
        {
            try
            {
                var del = new List<string>(Directory.GetFiles(directoryPath, "*.*", SearchOption.AllDirectories));
                Parallel.ForEach(del, d => { File.SetAttributes(d, FileAttributes.Normal); File.Delete(d); });
                return del.Count;
            }
            catch (Exception)
            {
                return -1;
            }
        }