Akses Terhadap Sistem Basis Data Tersebar Menggunakan Teknologi Ado.Net, Prosedur Tersimpan ( Stored Procedure) dan LINQ (Language Integrated Query)

Abstract

In applications that use the distributed database system which spread across computer networks, access to tables in the database (CRUD operations [Create-Read/Retrieve-Update-Delete]) consistent happened. In this case, application's developers that use Microsoft Corp. technology, have three options to deal with the tables in the database system, namely ADO.NET (SQL-based), SQL commands in the stored procedure/function form, and LINQ (Language Integrated Query). This paper aims to make the conceptual comparison that related to the access and manipulation of tables that stored in the database using all three technologies. Operations that will be explored are the operations that run on multiple tables at once because sometimes (on distributed database systems) the main table partitioned (vertical or horizontal partitioning) into a secondary tables.