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)
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; }
}
}
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER
I do not want the Visual Studio modify any data in the existing database.
Also, I am using SQL2005 without LINQ...
Also, I am using SQL2005 without LINQ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
freeware is better...
Microsoft Entity framework cannot handle vendor-specific database.
Microsoft Entity framework cannot handle vendor-specific database.