Accessing SQL Server Directly by Using SqlClient

If you can connect your device to your LAN, using WiFi or desktop passthrough (meaning your device uses ActiveSync to connect to a computer that is connected to the LAN), you can interact directly with a SQL Server 2000, SQL Server 2005, or SQL Server 2005 Express database server. Before you can connect to SQL Server from an application, you must add a reference in the Visual Studio .NET project to the SQL Server managed provider, which is listed in the Add Reference dialog box as System.Data.SqlClient. Alternatively, you can create a project data source that connects to your SQL Server and then drag it onto a form, in which case the designer adds the appropriate references to your project for you. ...

Get Microsoft® Mobile Development Handbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.