Tech 'n' Tech Books


ADO.Net Architecture

»   What is ADO.Net?

Disconnected and connected architecture of data access

»   What does it mean by disconnected data access architecture of ADO.Net?
»   What does it mean by connected data access architecture of ADO.Net?
»   What's the difference between accessing data with dataset or data reader?
»   What are the performance considerations when using dataset?
»   How to select dataset or data reader?

XML support in ADO.Net

»   How XML is supported in ADO.Net?

Components of ADO.Net

»   What are the different components of ADO.Net?
»   What is a dataset?
»   What is a data adapter?
»   What is a database connection?
»   What is a database command?
»   What is a data reader?
»   How do different components of ADO.Net interact with each other when disconnected?
»   How do different components of ADO.Net interact with each other in connected architecture?

Dot Net Framework Data Providers

»   What does it mean by Dot Net Framework Data Provider?
»   What are the core objects that make up a dot net framework data provider?
»   What are the standard data providers Framework 1.1?
»   Why use a specialized data provider when a general data provider can be used?
»   What is the Dot Net Framework data provider for SQL Server?
»   What is the Dot Net Framework data provider for Oracle?
»   What is the Dot Net Framework data provider for OLEDB?
»   What is the Dot Net Framework data provider for ODBC?

Implementing Data Access with ADO.Net

»   What are the basic steps involved in data access with ADO.Net in disconnected environment?
»   Which namespaces I need to add to my project for each of the standard data provider?
»   How do I define a connection string for the database server?
»   How do I find the connection string for the database server?
»   How do I define the connection to database?
»   How do I create a command and supply the SQL query to ADO.Net?

Working in Disconnected Architecture of ADO.Net with DataSet

»   How do I define a data adapter?
»   How do I get the result of my command and fill it to the dataset?
»   How do I read records from the data tables?
»   How do I save the changes, made in the dataset, to the database?
»   How do I make my first “Hello, ADO.Net” Application in C#?
»   How do I make my first “Hello, ADO.Net” Application in VB.Net?
»   How do I navigate through the records?
»   How do I update tables in the dataset?
»   How do I use a CommandBuilder object to prepare the update commands in my dataset?
»   What are the general steps for updating the records in dataset?

Updating data with ADO.Net

»   How do I update the dataset with the updates in records?
»   How do I update the physical database with the changes in the dataset?
»   How do I update a record in the table using ADO.Net dataset?
»   How do I insert a record in the table using ADO.Net dataset?
»   How do I delete a record in the table using ADO.Net dataset?

Connected architecture of data access in ADO.Net

»   What is the architecture of connected environment of data access in ADO.Net?
»   How do I read data (or records) from database using data reader?
»   How do I insert records using data reader?
»   How do I update records using data reader?
»   How do I delete records using data reader?

Writing common code for different data providers

»   How do I write common code for different dot net framework data providers?

Using Stored Procedure

»   What is a stored procedure?
»   What is the advantage of using stored procedure over the SQL queries?
»   What do stored procedure look like, can you provide some sample stored procedures?
»   How do I call a stored procedure from my app using ADO.Net?
»   How do I make my first application to call stored procedure using ADO.Net?
»   What are the important points when developing a data access app with ADO.Net?

Using DataGrid with ADO.Net

»   What is data grid and what is the use of it?
»   How can I make my first application with DataGrid using the data from ADO.Net?
»   How can I make my data grid to view data from multiple related tables?

Deploying ADO.Net applications

»   What are the issues related to the deployment of data access application?
»   How do I solve the deployment issues (mentioned in the previous FAQ)?
»   How do I set the connection string at installation :specific data provider?
»   How do I set the connection string at installation :general data provider?
»   How do I supply the connection string during first run or during the regular execution?
»   How do I store / retrieve the connection string in / from a text file?
»   How do I store / retrieve the connection string in / from an XML file?
»   How do I make my first "Hello, Data Access Application Deployment" setup program?

More

»   How to use relation objects in a dataset?
»   DataReader Vs DataSet?
»   How do I access a SQL stored procedure?
»   Methods of the Command Objects with databases »   How do I display a data table in a data grid?
»   How do I insert data entered in a textbox into the database?
»   How do I access SQL server in VB.NET?
»   How to insert an image in Access Database?