• On Life and Love

    SqlBulkCopy Matching Columns

    If you’re trying to do a SqlBulkCopy using a DataTable and getting lots of column type (integer, string) mismatches, it’s probably because you haven’t mapped not only the column types, but also the column names. SqlBulkCopy assumes that your DataTable is going to have its columns in the same order as the database table, which will cause mismatches when it tries to send your (string) Name field into your (int) Age column. Just having your DataTable column names match the table isn’t enough, either. There must be a manual mapping. But if your DataTable column names are the same as the table column names, a simple method can take care…

  • On Life and Love

    Brain Twist: .NET MVC 3, Entity Framework 4.1, and TDD

    Talk about taking a large bite. In the interests of pushing my .NET knowledge, I began migrating the Geist character sheet project that I’d started in Django to .NET MVC 3. I hadn’t done MVC in .NET since MVC 1 was beta’d, but hey, MVC is MVC is MVC. Right? So in the interests of making things more interesting and more testable, I decided to dive into the Entity Framework 4. My beginning read of POJOs in Action, along with my previous experience with .netTears–I mean, .netTiers–had me generally familiar with the concepts of entities, contexts, and repositories. Kicker is, POJOs is just a book (and one I’ve barely dived…

  • On Life and Love

    Quasi-daily linkage

    Welcome! – Okay, nevermind on the link below. This intro provides some good insight into the Tiny Living thing, which is more than just 60 sq. ft houses. Not sure that I want to downsize my house in particular, but it's an interesting movement. Tiny House In Asheville – I'm increasingly fascinated by this Tiny House movement (and need to do more research on it), although it initially strikes me as a fairly artificial constraint on living. a series of rants – Auntie Pixelante gives good rants. On a non-game-related note (but relevant), I really should stop saying "fail". If I talk to you in person, help me stop saying…

  • On Life and Love

    Quasi-daily linkage

    10 Weird Miniature Versions of Normal Animals – Weird Worm – These are quite adorable. Puppy! – Joel on Software – "Although I appreciate that many people find Twitter to be valuable, I find it a truly awful way to exchange thoughts and ideas. It creates a mentally stunted world in which the most complicated thought you can think is one sentence long." Don't know if I'd be as grumpy about it, but Twitter strikes me as yet another source of digital noise in an already noisy world. I may be done with it soon. "5 Browsers and the Modes of Transportation They Resemble" by Caldwell Tanner on CollegeHumor –…

  • On Life and Love

    Quasi-daily linkage

    My Java Experience – This is a great post on a .NETer taking a course in Java EE. I haven't done Java EE development before, but this makes me want to try it out of masochism. "All in all, I find myself unimpressed by the amount of work that was shuffled to the tools, it doesn’t seem right. And it seems like a justification of a bad practice. When I consider my own design principles (Zero Friction!) in light of this, I am much happier that I am mainly working in the .NET world. But I think that having this understanding is going to be very helpful moving forward." Coding…