Link to home
Start Free TrialLog in
Avatar of bbkevin
bbkevin

asked on

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

SOLUTION
Avatar of Luis Pérez
Luis Pérez
Flag of Spain image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of bbkevin
bbkevin

ASKER

I do not want the Visual Studio modify any data in the existing database.
Also, I am using SQL2005 without LINQ...
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bbkevin

ASKER

freeware is better...
Microsoft Entity framework cannot handle vendor-specific database.