Object Oriented in Database applications

Dinesh Liyanage

Hi All,
I am trying to start a windows based database application with C# and SQL server. I am aware about the OOPs concepts in C# but I am unable to think of how I can bridge those concepts to my application development. Please advise ,,,,

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravi Shekhar13y ago
DO coding with opening connection adding data and closing the connection is a good practice for edit update.

Mark it as answer if it helped.
Dinesh Liyanage13y ago
tnx Ravi...I mean each table entries can be defined as an object ( say Customer in tblCustomer) and then write methods for that class for each add , delete , edit entries ...?
Rather coding with usual opening connection adding data and closing the connection (like in normal structured language) .
Is it the general practice ? Please advice...
Ravi Shekhar13y ago
There is no definition explain for edit, delete operation in oops concept.

and edit ,update is a task. which can perform using oops concept.
Dinesh Liyanage13y ago
Thanks Ravi...defining the connection as a class file and use it in every form with out re writing the same code is clear for me. But what about the add, edit records to the tables ? Can we think any solution through OOPs ?
Ravi Shekhar13y ago
Oops is a theoratical concept but when you make your application in .net or any oops standerd language. you will see your code reuse, Inheritance etc.

for example,

we have a common class file and a method below...

public bool ConnectToDatabase()
{
try
{
if (sqlCon.State == ConnectionState.Closed)
{
GstrConnectionString = "Data Source=" + DATASOURCE + " ; Initial Catalog= " + DATABASE + ";User ID=" + dbUSER + "; Password= " + PASSWORD;
sqlCon.ConnectionString = GstrConnectionString;
sqlCon.Open();
return true;
}
else
{
return true;
}
}
catch (Exception ex)
{
return false;
}
}

we can call above method from any page/form easily. I mean to say that there is no need to write code for database connectivity on every page. we can make these one in a common class file.and call on any page easily.

Regards,

ravi