Databinding
Data Object Model
- Comes from System.Data
- Hierarchical set of namespaces for handing different database schemas:
- SQL
- Oracle
- OleDB
- ODBC
- MySQL, DB2, PostgreSQL, etc. also available
- Uses ADO.NET instead of ADO
Data Structures
- DataSet
- DataReader
- DataAdapter
- xxxConnection
- xxxCommand
- xxxParameter
- DataTable
- DataRow
- XSD
DataSet
- Representation of database in memory
- Disconnected by default
- Contains: Datatables : DataRows , DataRelations
- Uses XML for serialization
Data Reader
- Read-only
- Forward-only
- Results stored in network buffer
- Retrieved using the “.Read” method
- Created using the “.ExecuteReader” method of a command object
- Must “Close” the reader once done
DataAdapter
- Object that is a set of
- Select and/or …
- Insert and/or …
- Update and/or …
- Delete commands
- Connection Object
- Fills a dataset and maintains two way relation with the database
DataTable, DataRow
- Equivalent memory structures to table and row of database
- Can be created for a particular data structure
- .NET automatically creates strongly typed datarow/table elements which can be directly used in code
maintain at it man, your almost there , thanks for the read!
Good day, A actually occupying document. Continue it up.
Excellent beat ! I wish to apprentice while you amend your website, how can i subscribe for a blog web site? The account aided me a acceptable deal. I had been a little bit acquainted of this your broadcast provided bright clear concept
You might get read many articles on various articles. However, about of the time you got to know that substance was not up to the mark. This clause is actually related to the matter and features unique info relevant to the theme of the article.
I truly like the fresh perpective you did on the issue. Really was not expecting that when I started off studying. Your concepts were easy to comprehend that I wondered why I never looked at it before. Glad to know that there’s an individual out there that certainly understands what he’s discussing. Fantastic job