ASSESSING DATABASES IN .NET - Comparing Approaches

Daniela da Cruz, Pedro Rangel Henriques

2009

Abstract

Language-Integrated Query (LINQ) appeared recently as the new language of the .NET framework — is the new kid of the town. This query-language, an extension to C# and Visual Basic, allows the query expressions to benefit from the features previously available only to imperative code — the rich metadata, IntelliSense, compile-time syntax checking, and static typing. In this paper, we intend to compare the methods provided by .NET to query databases (LINQ, SQL and Object). This comparison will be done in terms of performance and in terms of the approach used. To guide this comparison, a running-example will be used.

References

  1. Chamberlin, D. D. and Boyce, R. F. (1974). Sequel: A structured english query language. In FIDET 7874: Proceedings of the 1974 ACM SIGFIDET (now SIGMOD) workshop on Data description, access and control, pages 249-264, New York, NY, USA. ACM.
  2. Codd, E. F. (1970). A relational model of data for large shared data banks. Commun. ACM, 13(6):377-387.
  3. Microsoft (2009). Code generation tool. http://msdn. microsoft.com/en-us/library/bb386987.aspx.
  4. Powers, L. and Snell, M. (2008). Microsoft R visual studio 2008 unleashed. Sams, Indianapolis, IN, USA.
  5. Sheriff, P. D. (2002). Designing a .net application.
Download


Paper Citation


in Harvard Style

da Cruz D. and Rangel Henriques P. (2009). ASSESSING DATABASES IN .NET - Comparing Approaches . In Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8111-84-5, pages 278-282. DOI: 10.5220/0001953402780282


in Bibtex Style

@conference{iceis09,
author={Daniela da Cruz and Pedro Rangel Henriques},
title={ASSESSING DATABASES IN .NET - Comparing Approaches},
booktitle={Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2009},
pages={278-282},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001953402780282},
isbn={978-989-8111-84-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 11th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - ASSESSING DATABASES IN .NET - Comparing Approaches
SN - 978-989-8111-84-5
AU - da Cruz D.
AU - Rangel Henriques P.
PY - 2009
SP - 278
EP - 282
DO - 10.5220/0001953402780282