"ASP.NET database entry classic" - John Kauffman et al.
Yesterday, the high-end people continued to recommend a good textbook to me. It seems that he has found that my cast is too weak, the concept is too confusing, emphasizing that I look at the bottom of the stuff. (Mainly referring to the official STARTKIT of MS, even if it is also
). Due to the current limit of the network, I can't always be online, or I feel that the textbook that borrows a better thing is necessary. I don't know if I don't know, the book of our school library is too small, and this is more famous.
From today, this book will look from the head, because many things have been known before, so the speed is still quite fast. Today, I'm talking about the database base, just write some notes. Summarized as follows:
Development of DB interface technology:
ODBC (the earliest unified database access interface technology, now there are not many places in use) - "Ole DB (he is a new generation of ODBC, now there are many, it seems to be mainstream) -" then MS Our database products have launched DAO and RDO. (RDO-Remote Data Object, his unique remote access is not available, can be said to be DAO's strengthen) - "Due to DAO, RDO server is too strong, then MS feels that developing a new database access Technology to achieve unified access, ADO is born! - "ADO.NET based on .NET technology has greatly extended ADO on the structure of the function.
ADO.NET access to the object (5):
Connection ---------- Command -------------------- DataAdapter ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------- DataSet ----
(Submit for information) | |
| | |
| | |
| ---- Used to get information returned by the database ------- | ------------ DataReader
Connection: Connection String
Command: Connection / CommandText / CommandType
DataAdapter: selectcommand / updateCommand / InsertCommand / deleteCommand
This has a rough understanding of the operation of ADO.NET on the database.
Then ADO.NET's database connection provider:
1.ole db.net - The most used is very versatile.
2. SQL Server.net - Optimized for SQL Server.
* ODBC.NET - is very small, mainly providing connections to third-party databases.
Today's things are very chaotic, I have written some points, even if it is a summary of reading today.
