-
Developing Database Agnostic Applications with Entity Framework
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - March/April
Microsoft released Entity Framework, an ORM (Object Relational Mapping) tool, in 2008.Entity Framework gives developers the ability to be abstracted from the underlying relational database management system and allows them to talk to a database using familiar LINQ-based syntax.
-
Using the Amazon Web Service SDK for .NET
By:
Rod Paddock
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2010 - March/April
The richest set of cloud computing services comes from a little e-commerce company known as Amazon.com. Developers can access the Amazon Web Services (AWS) platform using numerous tools including the .NET platform.Amazon.com is a major player in the cloud computing space and has numerous services available to developers. In late 2009, Amazon released the AWS SDK for .NET. This article will demonstrate using the AWS SDK to create a custom backup service using the Amazon Simple Storage Service (S3).
-
The Baker's Dozen: 13 Productivity Tips for Database Development Using Transact-SQL
By:
Kevin Goff
Last updated: Tuesday, February 19, 2019
Published in: CODE Magazine: 2005 - March/April
Many application developers face the challenges of working with SQL Server 2000.These challenges include retrieving and grouping large amounts of data, building result sets, and tracking changes to data. All require professional strategies that hold water against a seemingly endless number of possibilities. This installment of "The Baker's Dozen" presents a variety of real-world database situations and how you can use Transact-SQL and SQL-92 to tackle these issues.
-
Testing SQL Server 2000: Inspecting Configuration Information
By:
Talmage, Ron
Last updated: Wednesday, February 20, 2019
Published in: CODE Magazine: 2002 - March/April
Testing SQL Server is an often-overlooked area of the software development process, because programmers primarily place testing focus on code residing in the middle tier or the client desktop, rather than the database. However, as SQL Server databases become a more important component of applications, they cannot be left out of the developer's testing process. An important place to start, to ensure your code works the way you want it to, is with SQL Server configuration.The focus of this column is to examine issues dealing with testing SQL Server 2000 databases using SQL Server's built in language, Transact-SQL, as the primary testing tool.
-
XPath Queries in SQL Server 2000
Last updated: Wednesday, December 8, 2021
Published in: CODE Magazine: 2001 - Issue 1
Imagine the potential of accessing your database without needing to know any specifics about how that data is stored.Imagine the possibility of allowing your DBA the freedom to change the database structure without affecting your software code. Impossible? Not with XPath Queries and XDR Schemas. Using these two methods, practically any developer can write a program to access data in SQL Server 2000, just by knowing the structure of the XML documents returned by the server.
- Home
Articles filed in category 'SQL Server 2000'