(class diagram) UML, , , .
- . , , , . , , .. , .
(class) , , .
UML , (.28). , .
. 28.
, (. 28 ). (. 28 ) (. 28 ). (. 28 ) , , , . , , .
, , UML. 29. (. 29 ) , . (. 29 ) , . (. 29 ) , .
. 29.
, . , . UML, . , . , .
|
|
, , , . . , UML.
. UML .
(concrete class) , .
. .
(abstract class) , .
(). UML , , , . , UML.
, . - (::). : < >::< >. , , . , , : ::.
(attribute) , , .
, . . .
UML , . , , , , , , . :
< > < > []:
< > = < > {-}.
(visibility) , .
UML (visibility), 4- .
- " + " (public). , .
- " # " (protected). , .
- " - " (private). .
- , , " ~ " - (package). , - .
. , . , public private. : public, protected, private, package.
|
|
, . - , () .
(multiplicity) , .
, . , : [ .. ], . , () (). " * " (), , .. .
. - . , . : .
, . " * ", , . UML , . , UML [1..1], .. 1.
, , UML . UML , . , , .
. . , . , , .
|
|
, . , , .. ( static ).
. , - , . , . , . - , .
" / " , .
(derived element) , .
(operation) - , , , .
, . . UML . , , , , , - . :
< > < >(
):
< >
{-}
, , , , . " + " (public). " # " (protected). " - " (private). , , " ~ " (package).
. , . : public, protected, private, package.
|
|
, . - , () , , , .
, , , :
< > < >:
< > =
< >.
(parameter) , , .
, , . in, out inout in , . , . . , .
, . , . .
. . .
- , . - , .
. , . , , , () , () . .
OLE DB. .
OLEDB (Object Linking and Embedding Database - ) - (API), (Component Object Model - ) "" OLE DB.
OLE DB , ( SQL). OLE DB . OLE DB COM, OLE DB API . OLE DB , Microsoft SQL Server, Microsoft SQL Server, , ADO.
ADO (ActiveX Data Object) , , , . ADO OLE DB. ADO ODBC OLE DB.
ADO , , . , . , ADO , , . - . ADO - Connection, Command, RecordSet, Field.
|
|
ADO.NET , ADO, ADO.NET ADO, .
ADO.NET : Microsoft SQL Server, - ODBC, - , OLE DB.
, .NET.
System. Data - .
System.Data.Common - , ( ) .
System.Data.EntityClient - Entity Framework.
System.Data.Linq.SqlClient - LINQ to SQL.
System.Data.Odbc - Odbc.
System.Data.OleDb - OleDb.
System.Data.ProviderBase - .
System.Data.Sql - SQL Server.
System.Data.SqlClient - SQL Server.
System.Data.SqlTypes - SQL Server.
ADO.NET :
- ( DataSet) . ;
- ( DataProvider). , ( ).
ADO.NET.
ADO.NET ( ) , : .
, (, Connection, SqlConnection, OleDbConnection, ODBCConnection, , ). , . , (OLE DB, ODBC SQL Server).
Command - SQL .
CommandBuilder - SQL ( INSERT, UPDATE, DELETE) SELECT.
Connection - ADO.
DataAdapter - select, insert, update, delete, DataSet .
DataReader - .
Parameter - .
Transaction - , .
DataSet - , DataTable .
DataTable - , DataColumn, DataRow, .
DataRow - , .
DataColumn - (- ).
DataRelation - DataTable DataSet, " - ".
Constraint - DataColumn ( ), , .
DataColumnMapping - DataTable DataSet.
ADO.NET :
- ;
- ;
- Entity Framework.
(connected layer) . ADO.NET , .
(disconnected layer) DataTable ( DataSet), . DataSet . . DataSet, .
Entity Framework ( .NET 3.5SP1) LINQ - .