After about 3 hours of frustrating debugging, I came across a quirk/bug when using: MVC .NET 2.0 / 3.5 Model binding a collection Imagine you have a collection of, say User objects. And you would like to bind that collection to your view, but you only want to display some of the users. For example, only admin users. Your … More Model binding a collection with MVC and .NET 2.0
Improving unit testing, and use some sleek OOP too. Let’s say that we want to test a call to a basic stored procedure, where @ClientID is required. EXEC MYDB.MYSCHEMA.GetClients @ClientID = 10001 Now we want to test the database call in a unit test. If we don’t pass in @ClientID, we should expect a SqlException, … More Unit Testing: Using Extension Methods for better Exception Catching
You can use ToString on any indexed value in a DataRow, and it will return null if the field is DBNull: string myNullableField = row[“MyField”].ToString(); However, if you try to cast that same field as a string, you’ll get an exception: string myNullableField = (string)row[“MyField”]; //InvalidCastException! But, the good thing about the InvalidCastException being thrown, … More DBNull – Using ToString() vs. Casting
Tired of all of those crazy-long namespaces all over your view? Add the using statement to your view if you are using the Razor engine: @using My.Namespace.Path @{ ViewBag.Title = “My Page”; … } <html goes here> … </html> OR Add the import statement If you are using the ASP.NET (C#) engine: <%@ Import Namespace=”My.Namespace.Path” %> <html goes here> … More How to include / import a namespace in an MVC View
