.NET developer blog

Migrating from Oracle to Azure SQL caveat – java.sql.Date does not represent time.

Published May 28, 2022 in Azure , Azure SQL database , Java , Oracle , Oracle database

My team recently migrated one of our main database from Oracle to Azure SQL database. In this and upcoming posts, I’m going to share a few things I have learned during the process. Specifically, in this post, I share an issue we ran into with storing date and time, after migrating the schema and data from our Oracle into azure SQL database.

Tags: ojdbc , sql-date , sql-timestamp , sqljdbc

Connect to Oracle database from .NET core application.

Published September 26, 2020 in .NET core , ASP.NET core , Database , Oracle - 1 Comment

In this post, I go over using Oracle .NET core libraries to connect to Oracle database. In particular, we’ll look at the Oracle.ManagedDataAccess.Core and the Oracle.EntityFrameworkCore.

Tags: dbcontext , entity-framework-core , oracle entity framework core , oracle managed data access core

All posts in "Oracle"

Migrating from Oracle to Azure SQL caveat – java.sql.Date does not represent time.

Connect to Oracle database from .NET core application.