-
Developing Database Agnostic Applications with Entity Framework
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.
-
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.
-
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.
-
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.
-
.NET and Oracle Java Stored Procedures - Bridging the Gap with XML
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.