21⟩ Explain What is the .NET datatype that allows the retrieval of data by a unique key?
.Net data type is a type of data. Which is use in query.
Data type as like interger, char, varchar, numeric, money, date etc.
dot Net Database
Home Microsoft .Net Technologies dot Net Database
“dot Net Database Frequently Asked Questions in various .Net Database Interviews asked by the interviewer. So learn dot Net Database with the help of this .Net Database Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any .Net Database Interview Question or answer by the comment feature available on the page.”
23 Dot Net Database Questions And Answers
22⟩ Explain What are good ADO.NET object(s) to replace the ADO Recordset object?
The differences includes
In ADO, the in-memory representation of data is the Recordset.
In ADO.net, it is the dataset
A recordset looks like a single table in ADO
In contrast, a dataset is a collection of one or more tables in ADO.net
ADO is designed primarily for connected access
ADO.net the disconnected access to the database is used
In ADO you communicate with the database by making calls to an OLE DB provider.
In ADO.NET you communicate with the database through a data adapter (an OleDbDataAdapter, SqlDataAdapter, OdbcDataAdapter, or OracleDataAdapter object), which makes calls to an OLE DB provider or the APIs provided by the underlying data source.
In ADO you cant update the database from the recordset. ADO.NET the data adapter allows you to control how the changes to the dataset are transmitted to the database
23⟩ Explain How do we separate business logic while creating an ASP.NET application?
There are two level of asp.net debugging
1. Page level debugging
For this we have to edit the page level debugging enable the trace to true in the line in the html format of the page.
%@ Page Language="vb" trace="true" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="WebApplication2.WebForm1">
2. You can enable the debugging in the application level for this
Edit the following trace value in web.config file
Enable trace enabled=true.
