3-tier architecture

Question

how can I insert data in database using 3-tier architecture?

Anupam Singh · Answer

Hi Vejella, Now a days we dont prefer code ado.net library or other core database libraries instead we use ORM(Object Relational Mapping) frameworks like Entity Framework , nHibernate .. etc. in 3 tier we separate layers in UI,Business Layer and Database. Now your UI layer should not directly depend on Database instead you will have to use business layer to communicate database. so to insert data in table in responsibility of Business Layer, which will pass objects to ORM.

Saber Shaikh · Answer

Refer this Link http://aspnettutorialscode.blogspot.in/2013/11/3-tier-architecture-example-in-aspnet.html Thank You

Wim Sturkenboom · Answer

The very, very ....... basics A class for your database work class mydb { public static int updateUser(some parameters, out string errmsg) { // connect to database ... // execute query ... // return result of query; -1 on error (SQL exceptions), else number of affected rows ... } } A class for your business logic class mybll { public static int updateUser(some parameters, out string errmsg) { // validate parameters, return -1 on error ... // update user information in database return mydb.updateUser(some parameters, out errmsg) } } And the last class will be your web page with a method to update the user information (on a button click) protected void btnUpdUser_Click(object sender, EventArgs e) { string errmsg = ""; int affectedrows = mybll.updateUser(tbUsername.text, tbPassword.text, out errmsg); if(affectedrows == -1) { // error } } I don't do entity frameworks or whatever, just plain stuff.

3-tier architecture

Answers (3)