http://www.sqlservercentral.com/Articles tagged .Net posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Data access is an important aspect of developing applications with the Microsoft® .NET Compact Framework for Windows Mobile® devices. By using the existing architecture to send and receive data between your mobile application and your application server, you can pass data with either DataSets, custom objects, or scalar values.http://www.sqlservercentral.com/redirect/articles/61837/2008/01/18http://www.sqlservercentral.com/redirect/articles/61837/When we talk about something being reliable, we're referring to it being dependable and predictable. When it comes to software, however, there are other key attributes that must also be present for the code to be considered reliable.http://www.sqlservercentral.com/redirect/articles/61562/2007/12/07http://www.sqlservercentral.com/redirect/articles/61562/With WPF, you can perform data manipulation using Microsoft® .NET Framework code, XAML, or a combination of both.http://www.sqlservercentral.com/redirect/articles/61561/2007/11/28http://www.sqlservercentral.com/redirect/articles/61561/Some common and not so common connection strings for the .NET SqlConnection object. The article includes .NET sample code and some tricks to increase the supportability of your application.http://www.sqlservercentral.com/redirect/articles/61559/2007/11/26http://www.sqlservercentral.com/redirect/articles/61559/Windows® SharePoint® Services (WSS) 3.0 offers developers many significant improvements for building custom business solutions based on SharePoint sites. One of the biggest developer-focused enhancements has to do with a new infrastructure for handling server-side events.http://www.sqlservercentral.com/redirect/articles/61427/2007/11/23http://www.sqlservercentral.com/redirect/articles/61427/This handy control gives you everything you need to control how users input usernames, passwords, select servers, and choose connection types. http://www.sqlservercentral.com/redirect/articles/61418/2007/11/20http://www.sqlservercentral.com/redirect/articles/61418/This article looks at fuzzy testing and how to build a provider for your own use.http://www.sqlservercentral.com/redirect/articles/61426/2007/11/16http://www.sqlservercentral.com/redirect/articles/61426/Interacting with SQL Server from .NET is a radical change from the old OLEDB/ODBC method. Raj Vasant brings us some easy ways to work with parameters passed in with the ADO SQLCommand. http://www.sqlservercentral.com/articles/.Net/workingwithsqlparameterinnet/2311/2007/11/09http://www.sqlservercentral.com/articles/.Net/workingwithsqlparameterinnet/2311/Not every application needs a full-featured enterprise-scale database. In such cases, you can reduce costs and save resources by using a small-footprint database.http://www.sqlservercentral.com/redirect/articles/3198/2007/08/29http://www.sqlservercentral.com/redirect/articles/3198/You can easily build Wiki Web sites with ASP.NET and SQL Server and provide your teams with one of the most powerful ways of collaborating on the Web. http://www.sqlservercentral.com/redirect/articles/3187/2007/08/23http://www.sqlservercentral.com/redirect/articles/3187/LINQ may be getting the most attention in the forthcoming .NET 3.5, but there are also several new language features that add functionality and make life easier for the programmer. http://www.sqlservercentral.com/redirect/articles/3151/2007/08/09http://www.sqlservercentral.com/redirect/articles/3151/A web look up of a huge list of stock symbols from an MS SQL database.http://www.sqlservercentral.com/redirect/articles/3100/2007/07/30http://www.sqlservercentral.com/redirect/articles/3100/This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal.http://www.sqlservercentral.com/redirect/articles/3078/2007/07/27http://www.sqlservercentral.com/redirect/articles/3078/This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.http://www.sqlservercentral.com/redirect/articles/3099/2007/07/25http://www.sqlservercentral.com/redirect/articles/3099/Do you wish callers of your library could describe their types to you programmatically? Read a little about reflection in CLR Programming.http://www.sqlservercentral.com/redirect/articles/3077/2007/07/20http://www.sqlservercentral.com/redirect/articles/3077/This article describes how to provide full text search using Microsoft Indexing Service in .NET applications.http://www.sqlservercentral.com/redirect/articles/3098/2007/07/20http://www.sqlservercentral.com/redirect/articles/3098/In this article, I'll show you how to create a generic scheduler that runs on a Windows Service. The scheduler will be able to accept pluggable actions that we can develop later implementing a custom interface. Backgroundhttp://www.sqlservercentral.com/redirect/articles/3097/2007/07/17http://www.sqlservercentral.com/redirect/articles/3097/One of the major productivity benefits that the common language runtime (CLR) offers developers of managed code is that the garbage collector (GC) makes sure any memory allocated on the managed heap is cleaned up after it is no longer needed.http://www.sqlservercentral.com/redirect/articles/3076/2007/07/13http://www.sqlservercentral.com/redirect/articles/3076/This article walks through the basics of debugging stored procedures using Visual Studio 2005. It covers breakpoints, watches and stepping through code.http://www.sqlservercentral.com/redirect/articles/3056/2007/07/05http://www.sqlservercentral.com/redirect/articles/3056/If you would like to learn how to build and customize your very own Windows service to retrieve posts from multiple RSS feeds, and then store those posts in a SQL Server database, let John Papa guide you through his tutorial.http://www.sqlservercentral.com/redirect/articles/3013/2007/05/25http://www.sqlservercentral.com/redirect/articles/3013/The .NET Framework 2.0 introduces a very handy new class in the System.Data.SqlClient namespace called SqlBulkCopy that makes it very easy and efficient to copy large amounts of data from your .NET applications to a SQL Server database. You can even use this class to write a short .NET application that can serve as a "middleman" to move data between database servers.http://www.sqlservercentral.com/redirect/articles/2991/2007/05/09http://www.sqlservercentral.com/redirect/articles/2991/Should you store dynamically generated web-site graphics in a database or is the file system the better option? Dino illustrates how to make this decision in ASP.NEThttp://www.sqlservercentral.com/redirect/articles/2961/2007/04/17http://www.sqlservercentral.com/redirect/articles/2961/Damon Armstrong presents an extremely powerful and flexible token replacement mechanism for your ASP.NET applications. It is based on regular expressions so allows you to search for dynamic text, instead of just a static token, in a given string. http://www.sqlservercentral.com/redirect/articles/2813/2007/01/26http://www.sqlservercentral.com/redirect/articles/2813/One of the best benefits of the .NET Framework over lower level programming is that it enables developers to create very complex, custom solutions, without writing low-level code. Zach Smith explores how you could take advantage of the built-in .NET Framework functionality to develop a simple object oriented database in less than 140 lines of code.http://www.sqlservercentral.com/redirect/articles/2811/2007/01/19http://www.sqlservercentral.com/redirect/articles/2811/Keeping track of the performance of your SQL Servers requires metrics. There are many methods for doing this, but some type of automated process is essential these days with DBAs managing many servers. New author Allen White brings us a technique for doing this using SMO, the replacement for DMO in SQL Server 2005. http://www.sqlservercentral.com/articles/Performance+Tuning/2692/2006/11/22http://www.sqlservercentral.com/articles/Performance+Tuning/2692/What does a SQL Server developer care about the Enterprise Library? SQL Server guru David Poole is starting to work with .NET and brings us his perspective on what this library is and how it benefits those who develop against SQL Server. http://www.sqlservercentral.com/articles/.Net/2559/2006/08/21http://www.sqlservercentral.com/articles/.Net/2559/As server-side .NET development becomes more prevalent, Application Performance Management tools are becoming available to fine-tune .NET applications. And, as in the past, it seems that the ability to build new and more sophisticated applications always stays ahead of the ability to manage them.http://www.sqlservercentral.com/redirect/articles/2539/2006/08/09http://www.sqlservercentral.com/redirect/articles/2539/As a DBA you might not need to build connection strings for your servers very often, but developers certainly need to build these all the time and might contact you for help. Author Raj Vasant takes a look at the new capabilities of .NET 2.0, which can really help make this easier. http://www.sqlservercentral.com/articles/.Net/connectionstringbuildersinnet20/2500/2006/08/01http://www.sqlservercentral.com/articles/.Net/connectionstringbuildersinnet20/2500/An in-depth, fully explained case study on how to design and create a data access layer for your .NET applications. http://www.sqlservercentral.com/redirect/articles/2508/2006/07/24http://www.sqlservercentral.com/redirect/articles/2508/Enter to win a Ms Pacman/Galaga arcade machine when you download and register a free version of Microsoft Visual Studio Express Editions (free learning resources included).http://www.sqlservercentral.com/redirect/articles/2478/2006/07/03http://www.sqlservercentral.com/redirect/articles/2478/