Posts Tagged ‘Database’

LINQ to SQL

Chapter 56: LINQ to SQL What’s In This Chapter? Working with LINQ to SQL using Visual Studio 2010 Mapping LINQ to SQL objects to database entities Building LINQ to SQL operations without the O/R Designer Using the O/R Designer with custom objects Querying the SQL Server database using LINQ Stored procedures and LINQ to SQL […]

Tags:

Using the Python Database APIs

Using the Python Database APIs First, some history about Python and relational databases. Python’s support for relational databases started out with ad hoc solutions, with one solution written to interface with each particular database, such as Oracle. Each database module created its own API, which was highly specific to that database because each database vendor […]

Tags:

WordPress Database Queries, Operations, and Errors

WordPress Database Class WordPress features an object class with method functions for working with the database directly. This database class is called wpdb and is located in wp-includes/wp-db.php. Any time you are querying the WordPress database in PHP code you should use the wpdb class. The main reason for using this class is to allow […]

Tags:

Stored Procedures

Excerpt from Beginning VB.NET Databases By Thearon Willis A stored procedure is a group of SQL statements compiled into an execution plan and stored under a unique name in the database. It is then executed as a unit. Stored procedures in SQL Server and Oracle are similar to queries in Access. However, stored procedures are […]

Tags:

Database Design Basics

Excerpt from Professional Oracle Programming There is a common belief that database design is done by the database administrator (DBA), while program design is done by programmers. While this may seem like a natural division of labor, it is actually quite unfortunate. Applications are made up of two equal and interrelated parts: data and processes. […]

Tags: