posts - 88 , comments - 3 , trackbacks - 0

ado.net

How to Access Data from a SharePoint List Based on a Custom View
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. ......

Posted On Friday, June 26, 2015 3:21 AM | Comments (0) | Filed Under [ ado.net sharepoint cdata ]

Connect to Nonstandard OData Services
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 ......

Posted On Friday, June 26, 2015 3:18 AM | Comments (0) | Filed Under [ ado.net odata cdata OData Services ]

Connect SharePoint to SQL Server through SSIS
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 ......

Posted On Tuesday, June 16, 2015 4:10 AM | Filed Under [ ado.net sharepoint cdata ssis SQL server ]

Creating Master-Detail Screens in LightSwitch
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 ......

Posted On Monday, February 3, 2014 5:44 AM | Comments (0) | Filed Under [ ado.net .net lightswitch quickbooks ]

Using the CData Data Providers with the DevExpress Data Grid
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 ......

Posted On Monday, February 3, 2014 5:44 AM | Comments (0) | Filed Under [ devexpress salesforce ado.net .net ]

Using SQL to Query Gmail
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 ......

Posted On Thursday, December 20, 2012 1:56 AM | Comments (0) | Filed Under [ ado.net google cdata jdbc gmail data ssis excel add-in sql ]

Call Stored Procedures from Script Components
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 ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ salesforce ado.net cdata ssis ]

Build an MVC Application with Connectivity to QuickBooks
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 ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ ado.net quickbooks cdata MVC ]

Working with QuickBooks using LINQPad
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 ......

Posted On Tuesday, November 27, 2012 8:36 AM | Comments (0) | Filed Under [ ado.net quickbooks cdata linqpad ]

Executing Stored Procedures in Visual Studio LightSwitch.
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, ......

Posted On Friday, September 21, 2012 3:04 AM | Comments (0) | Filed Under [ ado.net lightswitch cdata email ]

Full ado.net Archive

Powered by: