Please enable JavaScript.
Coggle requires JavaScript to display documents.
*ADO.Net Active X data object, Dapper IDb connection, ORM Micro- …
*ADO.Net
Active X data object
SQL Command
Constructor
sqlcommand() , sql command(string) , sqlcommand(s , connection) ...
Methods
Cancle() , Clone() , ExecuteReader() , ExecuteScalar() , ExecutenonQuery()
SQL Connection Class
Construcror
Sqlconnection() , Sqlconnection(string) ,Sqlconnection(string , sql credi)
Methods
open() , close() , changeDB(string) , Changepass(s1,s2) ...
Data Reader
Methods
Close() , Read() , NextResult()
Properties
Hasrows , IsClosed ...
Data Adapter
Constructor
DataAdaptor() ,DataAdaptor(DataAdaptor)
Methods
Fill() ,Update()
Data Set
Constructor
Dataset() , ...
Methods
Rest() ,clear() , copy()
Properties
Has errors , Tables ,..
Data table
Construcor
DataTable() ,..
Method
GetRowType()
Properties
Columns , rows ,TableName
TRY
Catch
Final
Sql Parameters
Technology
Entity Frame work
Dapper
IDb connection
Methods
Execute , Execute reader, execute scalar
Query
QueryFirst
QueryFirstOrDefault
QuerySingle
QuerySingleOrDefault
QueryMultiple
Parameters
Anonymous
Dynamic
List
String
Result
Anonymous
Strongly Typed
Multi-Mapping
Multi-Result
Multi-Type
Utilites
Async
Buffered
Transaction
Stored Procedure
ORM
Micro- Dapper (speed)
Entity Framework (slow)