Answer Posted / nitin kaushik

"select @@identity"
@@identity is used to get the current transaction value .

** Note: Over a given connection if any insert statement is
executed on a table with identity column , the back end
sql-server for the connection initializes a parameter by
name "@@Identity" with the value of Identity column for the
last inserted record.

What are the drawbacks of using ado.net?

967

---

Explain the differences between oledb sql server, oledbdotnet provider?

999

---

What is linq and entity framework?

996

---

How does ado.net work?

914

---

How do you implement locking concept for dataset?

991

---

What does ado stand for?

902

---

What is the full form of ado.net?

979

---

What are the namespaces used in ADO.Net to connect to a database?

1202

---

Explain the difference in record set and dataset?

931

---

What are the major challenges in accessing data from a database?

1015

---

how can implement dropdownlist in particular of dataset when try to update?

2774

---

What is the difference between executequery and executenonquery?

902

---

Define atomicity?

1016

---

Which is the best method to get two values from the database?

962

---

What are the different methods by which we can populate a dataset?

1227

---