StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Quite the mix there ... first some explanations ... </p> <p>1) SQL Client An SQL client is an application that connects to a SQL Database for the purpose of querying / managing / working with the data in an SQL Database. (any program accessing a database, phpAdmin, SQLite Administrator, etc...). </p> <p>2) ORM is object-relational mapping. Its a way to convert different types of data when data types are incompatible. Think about a car class that incorporates four instances of a tire class. This type of structure doesn't translate well directly to the types available in database design and may be a reason to use ORM. (To relate the objects (car, tires, etc..) into the plain database types (integer, float, blob, etc..) </p> <p>3) OLE (pronounced Olay) DB Is the Microsoft method (API) for connecting to Database using COM. OLE DB is part of the MDAC Stack (grouping of MS technologies working together in a framework for data access).</p> <p>4) ODBC is Open Database Connectivity and its an alternate API for for Database Management Systems (DBMS). Where OLE DB is a COM (Component Object Model) way to integrate with databases, ODBC aim's to be language independent. </p> <p>5) ADO.NET is a set of base classes (API) for use in the .NET languages to connect to and communicate with Databases. </p> <p>I would suggest starting with ADO.net for your C# background, OLE is typically for older (VB classic) applications, There is a good beginner tutorial here <a href="http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx" rel="noreferrer">http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx</a></p> <p>Don't let all the terminology scare you off, once you jump in and start tinkering you will understand all of the answeres provided better... </p> <p>Best of Luck in your coding!! :-) </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload