Azure Cross Database Query and Comparison with LINQ

The cross database query in Azure SQL database helps significant improvements to elastic database queries. The elastic database query feature enables the user to run a Transact-SQL (T-SQL) query that spans multiple databases in Azure SQL Database. It allows the user to perform cross database queries to access remote tables, and to connect Microsoft and third party tools (Excel, PowerBI, Tableau, etc.) to query across data tiers with multiple databases. Using this feature, user can scale out queries to large data tiers in SQL Database and visualize the results in business intelligence (BI) reports [1]. The acronym LINQ is for Language Integrated Query. Microsoft’s query language is fully integrated and offers easy data access from in-memory objects, databases, XML documents and many more. It is through a set of extensions, LINQ ably integrate queries in C# and Visual Basic. LINQ allows writing queries even without the knowledge of query languages like SQL, XML etc. LINQ queries can be written for diverse data types [2]. In the present investigation, an attempt was made to (1) To enhance the performance of database queries arising from multiple data sources. (2) To analyze cross database queries in Azure using the elastic query techniques (3) Results of Azure Cross database queries were compared with LINQ with respect to performance considerations while dealing with multiple databases.