This new release contains significant changes.  First and foremost, all the implementation classes have had their public scope removed, so you will now have to program exclusively against the interfaces.  I have also moved the IMiadoDao interface to IMiadoRepository in order to encourage composition and not force an inheritance hierarchy.  Combined with that change, I also moved the functionality from SimpleSql into IMiadoRepository, as well as making that interface the point where you access an IDbStatement, making the IMiadoRepository the main worker module of Miado.   Another change is that you need to use the MiadoRepositoryFactory to create an instance of the IMiadoRepository.

Enough with the talk, let's see some code...

public AdddressDao 
{
    private static readonly string INSERT_ADDRESS_SQL = 
        "insert into Address(Address1, Address2, City, State, ZipCode) " +
        "values(@Addr1, @Addr2, @City, @State, @ZipCode)";
        
    private static readonly string SELECT_ADDRESS_SQL = 
        "select AddressId, Address1, Address2, City, " +
        "State, ZipCode " +
        "from Address ";
    
    private static readonly string SELECT_ADDRESS_BY_ID = 
        SELECT_ADDRESS_SQL + "where AddressId = @Id ";
        
    private static readonly string SELECT_ADDRESS_BY_ZIP_CODE =
        SELECT_ADDRESS_SQL + "where ZipCode = @ZipCode ";
        
    private static readonly string SELECT_COUNT_BY_STATE = 
        "select count(*) from Address where State = @State ";

    // uses MiadoRepositoryFactory.CreateMiadoRepository()    
    public AddressDao() 
        : this(MiadoRepositoryFactory.CreateMiadoRepository(
                   SqlClientFactory.Instance, 
                   ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString)) {}

    public AdddressDao(IMiadoRepository repository) 
    {
        this.MiadoRepository = repository;
    }
    
    protected IMiadoRepository MiadoRepository 
    {
        get;
        set;
    }
    
    public void SaveAddress(Address addr)
    {
        // uses SQL right in IMiadoRepository
        this.MiadoRepository
            .ExecuteNonQuery(INSERT_ADDRESS_SQL, 
                             addr.Address1,
                             addr.Address2,
                             addr.City,
                             addr.State,
                             addr.ZipCode)
    }
     
    public ICollection<Address> FindAddressesByZipCode(string zipCode) 
    {
        // build IDbStatement and do the mapping in a lambda expression 
        ICollection<Address> addresses = 
            this.MiadoRepository
                .CreateDbStatement(SELECT_ADDRESS_BY_ZIP_CODE)
                .AddParameter("ZipCode", zipCode)
                .QueryForResults<Address>(
                    row => new Address() 
                    {
                        AddressId = row.GetValue<int>("AddressId"), 
                        Address1 = row.GetValue<string>("Address1"),
                        Address2 = row.GetValue<string>("Address2"),
                        City = row.GetValue<string>("City"),
                        State = row.GetValue<string>("State"),
                        ZipCode = row.GetValue<string>("ZipCode")
                    });
        return addresses;
    }
     
    public Address LoadAddress(int addrId) 
    {
        // uses delegate method to do the mapping
        return 
            this.MiadoRepository
                .CreateDbStatement(SELECT_ADDRESS_BY_ID)
                .AddParameter("Id", addrId)
                .QueryForOne<Address>(CreateAddress);
    }
     
    public int FindCountByState(string state) 
    { 
        return 
            this.MiadoRepository
                .CreateDbStatement(SELECT_COUNT_BY_STATE)
                .AddParameter("State", state)
                .QueryForOne<int>(row => row.GetValue<int>(0));
    }
     
    private static Address CreateAddress(IResultSetRow row) 
    {
        return 
            new Address() 
            {
                AddressId = row.GetValue<int>("AddressId"), 
                Address1 = row.GetValue<string>("Address1"),
                Address2 = row.GetValue<string>("Address2"),
                City = row.GetValue<string>("City"),
                State = row.GetValue<string>("State"),
                ZipCode = row.GetValue<string>("ZipCode")
            };
    }
    
}

Friday, May 30, 2008 10:57:03 PM (Eastern Standard Time, UTC-05:00)      Comments [0]  .Net | C# | Miado

This past weekend I attended the No Fluff Just Stuff conference here in Atlanta.  If you're not familiar with NFJS, it's a traveling conference that hits most of the major markets here in the US.  It's held over weekends so as not to disrupt your daily job, and it covers topics in Java and Agility. 

I'd been to one NFJS a few years ago here in Atlanta and thought it was well worth it.  At that time, Bruce Tate was on the circuit. He was preaching (along with many of the other speakers at the time) about the bloat inherit in J2EE applications, and that Java developers should really be focusing their attention on lighter-weight J2EE alternatives such as Spring and Hibernate.  Mind you, this was long before either had become mainstream.  Having been a Rod Johnson disciple after reading his first book (the contents of which would eventually become Spring), I guess it's not surprising I enjoyed the conference so much.  Interestingly enough, Bruce, along with Stu Halloway and Justin Gehtland (who also spoke at that conference), are now big Ruby-On-Rails guys.

Now I've been doing .Net stuff almost exclusively for the last few years, so I had a slight reservation about attending this year's conference, given that I'm not doing Java day-to-day anymore and I wasn't sure how much would be relevant.  But given that I'm an independent consultant who should be up on such things, I thought it would be a good idea to at least re-familiarize myself with the goings on in the Java community. 

I really am technology agnostic, but I do find the language of Java to be extremely noisy, tedious, and verbose anymore, especially coming from C# 3.0.  Do you know how many language-level (not library-level) changes have gone into the JVM since 1.1.7?  Off the top of my head, I can remember:

• the new for loop (finally in 1.5!)
• the crappy implementation of generics
• annotations
• static imports
• enums
• varargs

That's not a whole lot (or really anything significant) for a language that is over 10 years old. 

And in case you are not following it, there is a huge debate in the Java world if/how closures should be implemented in the Java language.  Have you seen the candidates?  Good lord, they make the syntax for anonymous classes look simple!  Put me firmly in the camp of leaving Java the language itself good and well alone and concentrate your efforts on other languages that run on the JVM.

So given the stale nature of the Java language and the rise of my interest in dynamic languages, I figured this would be an excellent chance for me to explore Groovy and Grails.  I attended the sessions by Jeff Brown from G2One on both technologies the first day, and I was hooked right away on both.

Groovy compiles to native Java bytecode, and thus can be used interchangeably with standard Java classes (along with the innumerable number of Java frameworks out there).  Plus, it has strong support for the things I love in C# 3.0 - properties, extension methods, and closures.

Grails is rapid web application framework for Groovy similar to Rails.  It favors convention over configuration and uses a classic MVC architecture that allows for easy testability.  Under the hood, it uses best of breed Java technologies as plumbing infrastructure (e.g. Spring and Hibernate).  Just by creating a new project through scaffolding, it creates a nice project layout structure that provides a beautiful separation of concerns.  It really makes it easy for you to write unit tests (no more excuses!).  Basically, it creates a solid project architecture that would be roughly close to something a strong Java architect would formulate. 

I learned of a term from Scott Hanselman called "The Pit Of Success".  The concept is that you make it easy for developers to do the right thing and perform best practices.  Don't make them have to overcome the language or framework, but rather fall into success by default.  That's exactly what Grails does for you.

I stayed on the Groovy path the second day of the conference, attending sessions on meta-programming using Groovy.  Meta-programming in Groovy is quite powerful, which makes it damn easy to build DSLs.  One of the gems of the language is the simplicity in which you can create XML documents using a DSL in its XML builder.  If you've ever struggled over a unwieldy ant file (or jumped through hoops just to perform a simple "if" statement in the XML file), you really owe it to yourself to check out Gant.

My last day was my Neil Ford day.  I attended all four of Neil's sessions the last day.  The first two were on Agile project management and metrics while the last two on Ruby/JRuby.  Neil is a very entertaining speaker (and Atlanta resident the 10 days a year when he is not traveling).  Again, to reference Scott Hanselman, the joke is that Scott got hired on by Microsoft and now gets paid "to be Scott Hanselman".  I think Neil is exactly in the same camp.  He gets paid "to be Neil Ford".  Where do I get the gig "to be Chris Rauber"?

One last comment to make on NFJS.  One thing I like about Java conferences in general and No Fluff Just Stuff in particular is that they don't seem to favor "technology" over "methodology".  NFJS has a strong Agile underpinning, and offers a number of session on practicing Agile methodologies.  Where it did offer technology sessions, it seemed that it targeted as how a particular technology implements Agile.  For example, I mentioned in a previous post how Sun announced JavaFX at JavaOne this year (again).  This was a mere two weeks before the NFJS conference.  Yet there was hardly any mention of JavaFX at NFJS.  If this were a .Net conference, nearly half the sessions would be about this new technology.  Now, you could make the argument that JavaFX isn't really all that appealing to everyday Java developers, and truth to be told, you wouldn't get much argument from me.  But I thought it was very interesting nonetheless.

The bottom line - if NJFS comes to your town, I would highly recommend checking it out.  They really seem interested in providing top-notch speakers and giving you your money's worth in a conference. 

Now ... anybody looking to hire a Groovy consultant???

Friday, May 23, 2008 12:08:33 AM (Eastern Standard Time, UTC-05:00)      Comments [0]  Conferences | Java

Igor Ostrovsky recently published a great blog post about 7 tricks for using LINQ to simplify your programs.  Posts like this really make me re-evaluate how I am writing my code in C# 3.0.  For example, I had written a piece of code for my current project that generates a random confirmation number for a reservation system.  After reading Igor's post, I built off one of his examples and refactored my code to use LINQ to build my confirmation number.  I must admit, the refactored code is much more elegant:

private static readonly char[] AVAILABLE_CHARS =
    "ABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890123456789".ToCharArray();

private static string GenerateConfirmationNumber(int length) 
{
    int lastIndex = AVAILABLE_CHARS.length - 1;
    Random rand = new Random();
    var confNbr = 
        Enumerable.Repeat<int>(0, length) // loop N times
                  .Select<int, int>(loopNbr => rand.Next(0, lastIndex)) // get a random index
                  .Select<int, char>(index => AVAILABLE_CHARS[index]) // pull a char
                  .ToArray(); // project the results to a char[]
    return new String(confNbr);
}

I think it's important to remember that LINQ is much, much more than just LINQ-to-SQL (which is what most people immediately think of when you refer to LINQ).  In fact, none of the examples in Igor's post have anything to do with SQL.  Take a look at his post (and other LINQ examples online) and hopefully it will give you ideas on how to code using more of a dynamic language type syntax.

Wednesday, May 21, 2008 9:42:57 AM (Eastern Standard Time, UTC-05:00)      Comments [0]  .Net | C# | Linq

In an earlier post, I showed you how you could add a trim() method to the String class in Javascript.  Well, as I found out late last week, if you are using the ASP.Net Ajax framework, they have already done this work for you (as well as a few more methods).  Here are the extension methods for the String class that are provided to you:

One other nice thing it provides is a StringBuilder class similar to .Net's System.Text.StringBuilder class.  This is especially nice when creating big chunks of HTML to throw in an innerHTML property.

<input type="button" name="btn1" value="Click Me!" onclick="javascript:changeText();"><br />
<span id="myText"></span>

<script type="text/javascript">

function changeText() {
  var sb = new Sys.StringBuilder(); // thank you, ASP.Net Ajax!
  sb.append('<h1>How cool is this?</h1>');
  sb.append('<br />');
  sb.append('You just clicked my button.  ');
  sb.append('Now we will change some text');

  $get('myText').innerHTML = sb.toString();
}

</script>

Saturday, May 17, 2008 10:32:30 PM (Eastern Standard Time, UTC-05:00)      Comments [0]  Ajax | ASP.Net | Javascript

In my last post, I showed an example of how you can create an extension method on an existing class in javascript.  Well, C# 3.0 has now added the exact same functionality.  And it just so happens that today I needed to create one, so I thought I would post an example of how it's done in C#.

public static class StringExtensions 
{
    public static byte[] ToByteArray(this string s) 
    {
        return ASCIIEncoding.UTF8.GetBytes(s); 
    } 
}

Extension methods act like static methods on existing classes, and as such they can only be declared in static classes. To mark a method as an extension method, you must preface the declaration of the first parameter in the method signature with the keyword "this". The compiler will then add the method to the type of class declared in the first parameter. Any other parameters declared after the first one will become the signature to the extension method.

Now we can call the extension method we added to the String class:

public class Program 
{
    public static void Main(string[] args) 
    {
        string myString = "Foo";
        byte[] bytes = myString.ToByteArray(); 
    } 
}

The other cool thing is that Visual Studio provides full Intellisense on all extension methods!  So in the example I provided, ToByteArray() is now offered up as a potential method anytime I reference a string.

Wednesday, May 14, 2008 12:43:26 AM (Eastern Standard Time, UTC-05:00)      Comments [0]  .Net | C#

Curiously, the String class in javascript does not natively expose a trim() method.  Not a problem!  Since it is a dynamic language, javascript allows you the ability to crack open a class and add new functionality to it.

<script language="javascript" type="text/javascript">

String.prototype.trim = function() {
  return this.replace(/^\s+/,"").replace(/\s+$/,"");
}

var s = new String("  Test me!  ").trim();

alert("'" + s + "'");

</script>

The prototype keyword indicates that you are adding functionality to an existing class. In this case, we are adding a method called trim() to the String class that uses regular expressions to find any spaces  (\s+ = one or more whitespace characters) at the beginning (^ = match at the START of a line) and then the end ($ = match at the END of a line) of the string, and replace the spaces we find with an empty string ("").

Tuesday, May 13, 2008 11:07:44 AM (Eastern Standard Time, UTC-05:00)      Comments [0]  Javascript

Microsoft announced today the release of the first public beta of Service Pack 1 for Visual Studio 2008 and the 3.5 version of the .Net framework.  Rather than an extended re-hash of what's included in the release, I'll defer to the experts:

• Scott Guthrie
• Brad Abrams
• Scott Hanselman

Some of the highlights for me are:

• Rails-like "Scaffolding" support via ASP.Net Dynamic Data (I need to play around with this and see if there's a need to get Miado to work with this)
• ASP.Net AJAX script combining to reduce the number of requests to the server
• ASP.Net AJAX back button support!
• Improved Javascript intellisense and formatting
• Support for ADO.Net Data Services (the project formerly known as Astoria), which aids in the creation of a data access layer using REST-ful web services
  

Since this is a *beta* version of a service pack, at this point I personally wouldn't install this in anything but a VM.

Monday, May 12, 2008 4:45:45 PM (Eastern Standard Time, UTC-05:00)      Comments [0]  .Net | Visual Studio

From The Office (of course):

"Andy Bernard, Cornell '95"

I need to look for him at the next reunion...

Thursday, May 08, 2008 11:21:04 PM (Eastern Standard Time, UTC-05:00)      Comments [0]  Cornell | Humor | TV

In a stunning move at this year's JavaOne conference, Sun announced the upcoming release of JavaFX, its framework for building Rich Internet Applications (RIAs).  Stunning, you see, because they announced the same thing at *last year's* JavaOne conference.

I read the headline and thought to myself, "Hmm ... this must be some mistake."  But, no, it was not.  Apparently, 2007 was *not* the year of Java on the desktop, and we are forced to endure Sun's desperation pleas of, "All is well!!!" for one more year.  Now, they enter an increasingly crowded field of RIA frameworks, with Flash firmly entrenched and Silverlight gaining momentum.

Java has never had a strong success story when it comes to building GUI applications, despite the ironic fact that the initial vision of Java was that its strength would be on the client-side due to its "write once, run anywhere" cross-platform JVM.  The thought being you could write one client application and distribute that application across Windows, Mac, Linux, etc...  Well, that vision has never materialized.  Swing applications were cumbersome, buggy, resource intensive, slow (with horrendous start-up times), and let's face it, just down right ugly.  Users wanted native-looking apps, and Swing was like a herd of pink flamingos poised conspicuously in the desktop front yard.

Swing has come a long way since its initial inception, but unfortunately for Sun, they haven't been able to shake users' initial perceptions.  In another ironic fact, perhaps the weaknesses of building rich UIs in Java led to its unbelievable success in the late 1990s/early 2000s as a server-side language and for developing web-based applications.  The browser turned out to be a better cross-platform GUI than Swing, plus it required no installation or deployment concerns.

Now, here we are in 2008, and Java is looking a little long in the tooth, even for building web-based applications.  Steve Jobs famously declared Java as being dead (i.e. your act is about as fresh as a Foghat concert) as his reasoning for not including it in the iPhone.  I wouldn't go that far.  Java is so entrenched (especially in Fortune 500 companies) that I'd venture to say that it's going to outlive me.  Ha!  Take that, Steve Jobs!  But as far as building next-generation UIs, as a developer I am left scratching my head as to why the world needs a Java-based RIA so late in the game when Java has never had success in that space in the first place.

Let's hope in 2009, the JavaOne crowd is not left asking, "Thank you, sir, may I have another?" as Sun announces, "JavaFX - this time we *really* mean it!".

Thursday, May 08, 2008 9:36:44 PM (Eastern Standard Time, UTC-05:00)      Comments [0]  Conferences | Java | Silverlight

Wil Wheaton is fantastic.  This quote is from one of his recent posts questioning his own thoughts on JJ Abrams' promise to "re-invent" the Star Trek series with the new movie:

"Speaking as a lifelong geek, my knee-jerk reaction when I hear someone talking about 'reinventing' something like Trek is that it will be a tower of suck, built out of an endless supply of Jar-Jars and midichlorians."

Monday, May 05, 2008 9:45:29 PM (Eastern Standard Time, UTC-05:00)      Comments [0]  Humor

When I first starting developing in .Net, I had been a Java programmer for many years.  I remember when I first started the transition, a long-time VB developer told me how much I was going to *love* Visual Studio.  It was as if programming Java in Eclipse was akin to living in the stone age and he had suddenly granted me the programming gift equivalent to fire.  "Here you go ... but use this power wisely.  With great power, comes great responsibility."  Hey, it's not like I was using vi on an terminal emulator!  (by the way, have you seen any old school guys program in vi (and still choose to do it)?  It's *scary* how fast they are.)

Anyway, it's 2004 and I start my era as a .Net developer using Visual Studio.  Dare I say, I actually begin to *miss* some things that were in Eclipse.

Example - In Java, you have "import" statements at the top of every class you write.  They are very similar to "using" declarations at the top of a C# class.  They basically tell the compiler what packages (i.e. namespaces in .Net) you need to compile the class.  Whereas in .Net you only can include an entire namespace, in Java you have the ability to import an entire package:

import java.util.*;

or individual classes within a package without having to import the entire package:

import java.util.Calendar;
import java.util.Date;
import java.util.List;

Flash back to circa 2002 or so.  I was working on a J2EE project with a team of developers.  Another developer and I were working on a couple of the same files.  After he checked a file in and I was going to work on it, I would do a diff on the file to see what he had changed.  I noticed every time he checked a file in, along with the changes he had made, he would rearrange the import statements.  Now, the usual ordering of imports in a java class are that all the java.* classes go first, then the javax.*, followed by any org.*, and finally your application classes last.  The project we were working on was for the state of Georgia, so some of our application packages started with gov.*.  Well, he would always move those imports above the java.* packages.  I would move them back to the bottom (where they actually belonged).  When he checked it back in, they would be right back at the top.  I thought to myself, "Man, this guy must be really anal to go through the effort of expanding out and ordering all the imports statements that way.  I wonder why."

One day I finally asked him about it.  "Why do you re-order the imports statements every time you check a file in and put the gov ones first?"  He looked at me with a puzzled look.  "Huh?"  Then he realized what was happening.  "Oh, I just hit Ctrl-Shift-O every time before I save a file to organize the imports."  And he showed it to me.  In Eclipse, you could use that keyboard shortcut (or access it through the menu) to automatically figure out your individual class imports and arrange them via a configuration of your choice (since he hadn't set up the gov ones in any order, it defaulted them to be first alphabetically).

Wow!  Pretty cool!  This was 6 years ago mind you.  So I got in the habit every time I saved a file: Ctrl-Shift-O, Ctrl-S ... Ctrl-Shift-O, Ctrl-S ... Ctrl-Shift-O, Ctrl-S.  I quickly became a "creature of habit".

Back to starting out in Visual Studio in 2004 ...  Let's see, I'd like to organize my using declarations.  Ok, Ctrl-Shift-O doesn't do that.  Hmm ... I wonder where that setting *is* in Visual Studio ...  Looks of looking, lots of googling ... Nothing.  Well, damn.  That kinda sucks.  You mean I actually have to manage this myself?!?!?  I think to myself, "Am I the only one out there who is wanting this sort of thing???"

Time passes, I am surviving by organizing my usings by hand (barely).  The more and more .Net blogs I read, I start hearing about people using and loving ReSharper.  Last year, after going solo and starting my own company, I finally decided to pull the trigger and buy myself a copy.  And boy, was I glad I did!  Along with a bunch of other great things, I notice that it let's you sort and remove unused usings.  "There it is, there it is!!!"  Ctrl-Alt-O!  Organize and remove usings!

Last year, Visual Studio 2008 comes out, but damn - ReSharper is not quite ready for it.  Well, work still needs to get done so I need to carry on, albeit without ReSharper for the time being.  I am playing around with Visual Studio 2008, and I notice a new menu option under Edit->Intellisense.  Whoa, what's this?  "Organize Usings".  I click on it, and lo and behold, there it is - three options: 1) Remove Unused Usings; 2) Sort Usings; 3) Remove and Sort.  Finally!!!

There is no native keyboard shortcut mapped to the "Remove and Sort".  Well, we can change that easily enough:

There, I've mapped Ctrl-Alt-O to Remove and Sort.  I'm back baby!  Ctrl-Alt-O, Ctrl-S!  Let's see it in action ...

Before:

And after:

The bottom line is - yes, Visual Studio is a great IDE.  But don't fool yourselves .Net developers.  Eclipse, IntelliJ, and even NetBeans (my preferred IDE for working in Ruby) are all very strong IDEs that in reality actually do some things (gasp!) *better* than Visual Studio.

Saturday, May 03, 2008 2:52:09 PM (Eastern Standard Time, UTC-05:00)      Comments [0]  .Net | Eclipse | Java | ReSharper | Visual Studio