Articles filed in category 'Oracle'

Developing Database Agnostic Applications with Entity Framework

By: Sergey Barskiy (Tyler)

Last updated: Wednesday, August 31, 2022

Published in: CODE Magazine: 2010 - March/April

Microsoft released Entity Framework, an ORM (Object Relational Mapping) tool, in 2008.Entity Framework gives developers the ability to be abstracted from the underlying relational database management system and allows them to talk to a database using familiar LINQ-based syntax.

• C#
• Design Patterns
• Entity Framework
• Oracle
• SQL Server
• SQL Server 2000
• SQL Server 2005
• SQL Server 2008

NHibernate Succinctly

Last updated: Wednesday, February 20, 2019

Published in: Book Excerpts, Newsletters

Master a powerful and flexible ORM with support for database engines including Microsoft SQL, Oracle, MySQL, and more.

• Book Excerpts
• MySQL
• NHibernate
• Oracle
• ORM

Oracle SQL and PL/SQL 2nd Edition for Developers; Chapter 2

Last updated: Tuesday, February 19, 2019

Published in: Book Excerpts, Newsletters

In the last chapter, you learned about some of the SQL statements that you can use to work with the data in a relational database. Before you learn the details of coding these statements, however, you need to learn how to work with an Oracle database and how to use Oracle SQL Developer to enter and execute SQL statements. It's also helpful to know how to use the SQL Reference manual.

• Book Excerpts
• Data
• Oracle
• SQL Server

Oracle SQL and PL/SQL 2nd Edition for Developers; Chapter 3

Last updated: Tuesday, February 19, 2019

Published in: Book Excerpts, Newsletters

This section teaches you the essential SQL coding skills for working with the data in an Oracle database. The first four chapters show you how to retrieve data from a database using the SELECT statement. In chapter 3, you’ll learn how to code the basic clauses of the SELECT statement to retrieve data from a single table.

• Book Excerpts
• Data
• Oracle
• SQL Server

.NET and Oracle Java Stored Procedures - Bridging the Gap with XML

By: Hilts, Jeff

Last updated: Wednesday, February 20, 2019

Published in: CODE Magazine: 2003 - November/December

Using Oracle as your database in the .NET environment is relatively simple, except when returning JDBC ResultSets from Java stored procedures. The Microsoft and Oracle .NET data provider drivers allow for easy access to data from SQL queries and PL/SQL stored procedures. There is not, however, a simple interface to return ResultSet data from a Java stored procedure to a .NET client.

• .NET Framework
• Data
• Oracle
• XML