Data Tier Generator for C#

I currently tried to design a 3-tier Architecture website in .NET. (Not multiple projects)
Now I create a BLLUser.cs, DALUser.cs and MUser.cs classes and type the logic manually.
Start from GET SET properties for each field according the column in the database.
Do you know any tools able to create those code by type in the database table name? (Famous and experts recommended tools)
public class MUser
{

    private int id;
    private string username;
    private string password;
    private string email;

    public int ID
    {
        set { this.id = value; }
        get { return this.id; }
    }

    public string UserName
    {
        set { this.username = value; }
        get { return username; }
    }

    public string Password
    {
        set { this.password = value; }
        get { return this.password; }
    }

    public string Email
    {
        set { this.email = value; }
        get { return this.email; }
    }
}

Open in new window

bbkevinAsked:
Who is Participating?
 
binaryevoConnect With a Mentor Commented:
How are you interacting with your data, stored procedures?  Entity framework can handle that.  Its up to you as the developer to interact with the data the way you want to.  This is still probably the quickest way to get the "DL" mapped and then you can utilze a Repository pattern to force rules on how you do the interaction with data.  There are a great many benefits to utilizing linq in the right context.
0
 
Luis PérezConnect With a Mentor Software Architect in .NetCommented:
0
 
binaryevoCommented:
Why dont you give Microsofts Entity Framework a go.  It's cool and works wonders in terms of "creating the datalayer" per say.   See this link:  http://msdn.microsoft.com/en-us/library/aa697427(v=vs.80).aspx
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
bbkevinAuthor Commented:
I do not want the Visual Studio modify any data in the existing database.
Also, I am using SQL2005 without LINQ...
0
 
bbkevinConnect With a Mentor Author Commented:
I found the following generators quite useful...
CodeAuthor
http://www.codeauthor.org/

MyGeneration
www.mygenerationsoftware.com
0
 
bbkevinAuthor Commented:
freeware is better...
Microsoft Entity framework cannot handle vendor-specific database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.