Answer Posted / muthu kumar

DataSet d = new DataSet();
DataColumn parentDC = new
DataColumn(d.Tables["parentTable"].Columns["id"]);
DataColumn childDC = new
DataColumn(d.Tables["ChildTable"].Columns["id"]);
DataRelation ds = new DataRelation("relation name",
parentDC, childDC);
d.Relations.Add(ds);

Is entity framework better than ado.net?

990

---

Which name space is used to get assembly details?

969

---

How can we save all data from dataset?

982

---

What is difference between executequery and executeupdate?

974

---

What Is Difference Between Ado And Ado.net?

1014

---

What is the difference between sqlcommand and sqldataadapter?

978

---

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1047

---

Explain ODP.net

983

---

What are all the different authentication techniques used to connect to MS SQL Server?

1061

---

What is connected architecture in ado.net?

1041

---

What are the usages of the command object in ado.net?

1012

---

What is the use of connection object in ado.net?

1037

---

What provider ado.net use by default? Explain the role of data provider in ado.net?

953

---

What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)

988

---

How can we serialize the dataset object?

985

---