How To
How to import data to Excel using ODBC
In this article, we will discuss how to access data using ODBC driver in Microsoft Excel. We will examine in detail the data retrieving...
Use VirtualDataSet to Access Objects List via TDataSet Interface
TVirtualDataSet is a virtual dataset that can be used as an intermediate between data stored in an application and data-aware controls used in forms....
How to quickly generate documentation for your SQL Server database
In this blog post, we will learn how to quickly create a comprehensive documentation of an SQL Server database using SQL documentation tool from...
Installation & Configuration of Devart ODBC Driver for QuickBooks
The article describes installation and configuration of Devart ODBC Driver for QuickBooks on Windows, as well as authorization and connection to a QuickBooks...
Tidy SQL with SQL Complete
In this article, we will talk about how to keep SQL code clean and highly readable. We will also discuss how to stop suffering...
How to Combine Data from Several Sources Using SQL and VirtualQuery
The VirtualQuery component allows executing SQL queries to sources that are not a database, but a TDataSet or any of its descendants. It also...
Getting Real Currency Exchange Rates with SQL Server Data Generator
This article will demonstrate how to get live currency exchange rates with the help of Python and dbForge Data Generator for SQL Server.
The currency...
Migrating Entity Framework 6 projects to Entity Framework Core 1 (EF7)
For the purpose of this tutorial, we will use a test project from the "Entity Framework 6 Support for Oracle, MySQL, PostgreSQL, SQLite, DB2,...
Generating Related Data Elements with SQL Data Generator
Recently we got an interesting question from our user:
The docs don't address directly, but how can we generate three related data elements,...
MySQL Case Sensitive Search in Entity Framework
A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a...
