ado.net
The CData ADO.NET Providers for SharePoint you to integrate live SharePoint data with other applications. For example, Visual Studio provides built-in support for ADO.NET data sources. This article shows how to use Server Explorer in Visual Studio to access the data screened by a SharePoint custom view.Implementing Access Control with a Database QueryThe CData ADO.NET provider's data model exposes each SharePoint list as a separate table; all custom views are available by querying the Views table. ......
The CData ADO.NET Provider for OData enables you to expose Web services as a fully managed ADO.NET data source. It allows you to access almost any OData service from native ADO.NET tools. You can follow the procedure below to access OData sources that do not conform exactly to the OData protocol. This article will add support for the Microsoft Research service, which does not implement some common functionality, including support for retrieving metadata.Define a Custom Schema FileThe CData providers ......
Using SQL Server as a backup for critical business data provides an essential safety net against loss. In addition, backing up data to SQL Server enables business users to more easily connect that data with features like reporting, full-text search, analytics, and more.This example demonstrates how to use the SharePoint ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from SharePoint and/or SharePoint Online into a Microsoft SQL Server database. The exact same ......
LightSwitch provides support for using relationships between tables in a data source. However, QuickBooks does not natively expose relationships that can be used in LightSwitch. This article will walk you through the steps to set up a LightSwitch master-detail screen using simple queries.Connect to QuickBooksIf you are connecting to QuickBooks Desktop edition, use the included Remote Connector application. You can use the Remote Connector to connect to local and remote instances of QuickBooks. The ......
The CData ADO.NET providers are standards-based libraries that can be used with various third-party components and tools. You can use the DevExpress controls with any of the CData providers to visualize data from a wide variety of sources.In this article, you will use the Salesforce provider to databind to the DevExpress Windows Forms and Web controls. The standard ADO.NET process for databinding can be followed to enable bidirectional access to live data from UI controls. This article shows how ......
The Gmail Data Provider makes it easy to search email from a Gmail account. Instead of learning the details of the IMAP search command, you can simply use the simple SQL syntax. However, the full IMAP search specification is supported. You can also search based on multiple criteria at the same time. This article will demonstrate how to use SQL to execute simple and advanced IMAP searches. Message FieldsFor simple searches, such as searching for all emails from a particular person, you can use message ......
The source task and the destination task are the easiest ways to transfer data in SSIS. You can use source and script components to output data to the data flow.This article shows how to create a script component that functions as a source in the data flow: It passes data returned from Salesforce to downstream components. You will execute the CreateJob and CreateBatch stored procedures available in the Salesforce SSIS Component.Stored procedures can be used to search, update, and modify data. Stored ......
This article shows how to use wizards in Visual Studio to create a simple MVC (model, view, controller) project and execute CRUD (create, read, update, and delete) commands to QuickBooks using the Entity Framework methods.Establish a ConnectionBefore getting started, you will need to establish a connection to QuickBooks.To connect to QuickBooks Desktop, use the Remote Connector application included with the installation. The Remote Connector is a lightweight, stand-alone server that enables you to ......
The CData ADO.NET Providers can be used from many applications and development environments. This article shows how to use LINQPad to connect to QuickBooks using the CData ADO.NET Provider for QuickBooks. Although this example uses the QuickBooks Data Provider, the same process applies to any CData ADO.NET Providers.Create the Data ModelIn a new console project in Visual Studio, create a data model using the ADO.NET Entity Data Model wizard.Select an existing connection or click New Connection to ......
The CData ADO.NET Data Providers enable you to visualize and manipulate information from disparate data sources in LightSwitch applications. This entry demonstrates how to execute stored procedures in LightSwitch. This article uses the CData Email Data Provider, but the same process will work with any CData ADO.NET Data Provider.Create the RIA ServiceOpen Visual Studio 2010 and create a new WCF Service Library Project.Add a new Domain Service Class to the .Web project.In the new Domain Service Class, ......
Full ado.net Archive