Thursday, November 12, 2009

My new, FREE app to generate VB.NET, SQL Server , and HTML code

So. I wanted to stop being a monkey.

I spent too many hours writing the same code over and over again.

I am a VB.Net Developer and my style is very N-Tiered. I work for a company that has many different clients coming and going, and with that, I find myself creating new databases, schemas, and projects from scratch.

It always happened the same way...

1. Create the database, tables, and stored procedures
2. Create a DAL object for each table with the standard CRUD operations.
3. Create Biz objects for those DAL objects along with properties, variables, constructors, conversion methods, and methods that call the DAL CRUD methods.
4. Create front end markup with data controls that call the Biz methods. Usually containing listviews, forms to add, and forms to edit the custom objects.

In every case, 90% of this code followed a pattern.

What a waste of time.

I knew that some of my colleagues were using off the shelf tools that would generate code based on their tables. However, I never liked the idea of being held captive by some software that created this stuff for me. What happens if I want to do something to a DAL method? what happens when someone else works on my code? I don't like things being hidden from me, and I don't like not having complete control over my work.

So it finally hit me. Why not just build a winforms app that writes all this stuff for me? DUH.

All my app would do is spit out code in a multiline textbox that could be copied and pasted into my project. How sweet would that be?

So I built the app and it works! It's already saved me tons of time and I was so excited, I had to blog about it. For now, it's totally free. Maybe someday I'll figure out how to make a few bucks off of it (doubtful).

Here's the link

By the way, in order to actually use the code, you'll need 3 or 4 custom classes that I have written. Namely OperationStatus and DataAccess which consolidate CRUD operations. Both of these classes are referenced in the generated code.

If you want these files, shoot me an email.

No comments:

Post a Comment