Some useful Extension Methods
Back to basics… A couple of useful Extension methods if you are checking if a string is a valid integer or decimal. public static bool IsInteger(this string value) { if (String.IsNullOrEmpty(value)) return false; Int32 tmpNo; return Int32.TryParse(value, out tmpNo); } public static bool IsDecimal(this string value) { if (String.IsNullOrEmpty(value)) return false; Decimal tmpNo; return Decimal.TryParse(value, [...]
OrderBy making null records come last Entity Framework and Linq
Ever want to sort your result set but make sure the records with a null sorting column appear last? See the example below var results = (from x in EntityObjectContext.MyTable select x into grp [...]
Finding StoreGeneratedPattern value in EdmProperty in T4 Template
If you need to find out if a primary key in your conceptual model which is using the Identity value from the property StoreGeneratedPattern, you can use the following code: (NOTE: This is used within a T4 template) string inputFile = @"..\EntitiesModel.edmx"; EdmItemCollection ItemCollection = loader.CreateEdmItemCollection(inputFile); string annotationNamespace = "http://schemas.microsoft.com/ado/2009/02/edm/annotation"; foreach (EntityType entity in ItemCollection.GetItems<EntityType>().OrderBy(e [...]
Open XML – OLE Automation Date Issues
If you are exporting a date from C# to Excel using 2007, you probably will use the following: Math.Round(DateTime.Now.ToOADate(), 12).ToString() This exports the date as a OLE Automation date recognized by Excel 2007. How ever, in Excel 2010 this was causing issues, every time I exported to Excel 2010, it said that it has to [...]
Fixing the EF Tracing and Caching Provider Wrapper Issue
If you have been using the Tracing and Caching Provider Wrappers for the ADO.NET Entity Framework 4.0, you might of come across this error message when creating POCO objects, adding them to a Data Context and commiting them to the database using the Caching Wrapper: [NotImplementedException: The method or operation is not implemented.] EFCachingProvider.EFCachingDataReaderCacheWriter.GetName(Int32 ordinal) [...]
Random number of items from a Generic List extension method
Here is a code snippet for returning N number of items from a generic list using a extension method. This requires .NET 3.5. public static class Extensions { /// <summary> /// method for returning N number of random items from a generic list [...]
The custom tool ‘MSLinqToSQLGenerator’ failed. Unspecified error
I kept getting this error “The custom tool ‘MSLinqToSQLGenerator’ failed. Unspecified error. For me, this was caused when I was using partial classes and had several using statements at the top of the file: using System.Data.Linq; using System.Data.Linq.Mapping; using System.Data; using System.Collections.Generic; using System.Reflection; using System.Linq; using System.Linq.Expressions; using System.ComponentModel; using System; {namespace} {code} To [...]
Modify a Word 2007 Open XML document via C#
Interesting problem that I came across here…A client requested that their system was to have the ability to load in a Word 2007 Document, perform some text manipulation routines and save the document back to the server. Firstly, you can rename a docx document to docx.zip and you can extract all of the files in [...]
Best Coding Practices – TIP 3
The use of partial classes can help improve coding for the following reasons: As you can split code into seperate physical files, its easier to seperate UI and Business Logic that may belong in a single class Produces clean and organised code No performance hit… The compiler groups all partial classes into one entity during [...]
Using ContextMenuStrip and NotifyIcon classes with WPF
There are many ways to get a notification icon displaying in the system tray, this is how I managed to get it working using Windows Presentation Framework: public partial class ClassName : Window { private System.Windows.Forms.NotifyIcon m_notifyIcon; private System.Windows.Forms.ContextMenuStrip m_contextMenu; public ClassName() { InitializeComponent(); //Initalize the context menu strip m_contextMenu = new System.Windows.Forms.ContextMenuStrip(); System.Windows.Forms.ToolStripMenuItem mI1 [...]
-
-
-
CodeLab Twitter- codelabnz: @bartekmarnane some info on micro orms http://t.co/UDfv5ML7 February 5, 2012
- codelabnz: @bartekmarnane depends on the project, but i found u have 2 be very careful with EF and the type of SQL it generates February 5, 2012
- codelabnz: @bartekmarnane I have been using EF for awhile, good for building apps quickly, but found it performs bad on higher traffic web applications February 5, 2012
- codelabnz: stuff it, I give up on Entity Framework, going to a micro ORM, back to writing SQL queries! I would rather do this than have a slow app! February 5, 2012
- codelabnz: Been too busy for tweeting lately January 21, 2012
- codelabnz: Blog Post: Setting the screen position when visiting previous page with jQuery http://t.co/evuKxVv0 January 17, 2012
- codelabnz: is anyone using Godaddy Cloud hosting? can someone provide their website so I could do a speed test? January 9, 2012
- codelabnz: Blog Post: Magento Fontis Paymate Module Fix for Not Passing Data Issue http://t.co/tgaDjmHv December 28, 2011
- codelabnz: first attempt upgrading magento from 1.4 to 1.6 fail. worst upgrade documentation. time to bring out the hack ninja December 27, 2011
- codelabnz: We would like to wish everyone a Merry Christmas and a Happy new year for 2012. Thank you all for your support... http://t.co/IGB5FlzO December 23, 2011