My very early .Net DAL framework...

djkav · 27 Apr 2014 at 22:11

I was part of a developer department of a web agency.

I was a senior placed in a team that was to conduct R+D on new web technologies, with the intention of moving our current now classic ASP and PHP coding, into the new ASP.NET framework.

I managed to get web services working from just the CLI version of .NET v1.0, before any IDEs were available.

I have included in this post a downloadable .zip file of my last R+D project to make a common web and data access layer framework to form the backbone of our future web projects. The work was done around 11 years ago and last compiled with .NET 2.0. Its lacking in comments, so I know it could have been better.

Our goal was for a database extraction layer that could be used for both MS SQL and MySQL with minimal code changes.

Its not perfect, and could probably be improved in many ways. It did provide the DAL for a few of my personal test projects for MS SQL and MySQL with only a couple of namespace reference changes for whichever server I targeted.

Anyway, here is my framework from many years ago.

I don't mind, if you think its good, bad, or whatever critique you provide. It was still in the R+D beta stage. Some might just find it an interesting browse around.

Download

Magik5 · 28 Apr 2014 at 13:58

If you're going to release it like this you may as well stick it on github

ocmanus · 28 Apr 2014 at 15:33

Magik5 said:
If you're going to release it like this you may as well stick it on github

I'd agree. Github or Bitbucket will get you a much larger audience.

Haircut · 28 Apr 2014 at 18:50

I'm not entirely sure what the purpose of the OP's post was, but being brutally honest the code is very much showing its age.
It's fairly idiomatic .NET 1.1 code, but really isn't of much use to anyone these days.

If someone wants simple SQL database access I'd say to use a micro ORM these days.

djkav · 28 Apr 2014 at 21:40

I didn't post it as a modern day DAL. It did it like a time capsule, a snapshot from that time frame. Like a piece of art work in a gallery, so to speak.

It has no use in this day an age, with Entity Framework and other object modelling frameworks.

Like I said, it was coded as an R+D project in 2003, for a purpose and direction. That is all, and nothing else.

robotSocks · 29 Apr 2014 at 13:49

dapper TBH

djkav · 29 Apr 2014 at 14:01

robotCocks said:
dapper TBH

Looks nice and quick. I always did wonder what overhead the Entity Framework would have, seeing as it does a lot of model building and reflection in the background.