liarsParadox

The above function returns a DataSet object. After the initial set of variables are declared, the With statement-block is executed and certain attributes within the sqlCmd SqlCommand object are set accordingly. It’s probably important to note the if-else block within the With block. If the passed parameter determines the stored procedure’s name that is specified in the SqlCommand object’s CommandText.
After the With block has been finished, SqlDataAdapter is instantiated and...

liarsParadox

Data Providers
Data Providers are classes that for access to certain types of “data stores”. My guess is that the Database object shown in the above diagram is what the original author calls a “Data Provider”.
The .Net development libraries come “pre-built” with data providers that allow access to SQL Servers, OLE-DB sources, Oracle databases, and ODBC (the one that I have used with Java before). There are also other data providers out there which allow access to MySQL databases...

liarsParadox

Recordsets
As the name implies, it represents an entire set of records which would be returned by some SQL command. The main advantage of this is the ease that it provides in manipulating records and the fields within those records within the SQL database.
Cursors
Recordsets have a member called a “Cursor” within it. A cursor is the mechanism that allows the ease of modifiability of a recordset. There are four types of cursors for a recordset:

• Forward-only

...

liarsParadox

JNDI
The Java Naming and Directory Interface (JNDI) is a part of the Java platform library.
Context
An interface from the javax.naming library package, which, if implemented, is essentially a Hash-Table of “contexts”. For any of the methods declared in the Context interface, the name parameter is the name of the property within the environment’s context. If an empty name (cannot provide a null string) is passed to that method, then the method is performing an operation...

liarsParadox

Terms

• Common Language Specification (CLS): defines standard rules for editing .NET languages (1).
• Common Type System (CTS): a .NET standard that specifies how Type definitions and specific values of Types are represented in computer memory (2). Types that are supported by CTS are both references and values (1).
• Common Language Runtime (CLR): “a special run time environment” (3) and Virtual Machine (13) ”that provides the underlying infrastructure for Microsoft’s .NET framework.

...

liarsParadox