April 2012 Entries
Object-relational mapping (ORM) technique can bridge your logical business model with your physical storage model. Hibernate is a popular object-relational mapping library for Java, providing a framework for mapping object-oriented domain models to a traditional relational database. Note: Plese see the article Using LINQ with QuickBooks to see the ORM approach using Microsoft .NET. The RSSBus Salesforce JDBC Driver supports full integration with Hibernate.In this tutorial, we will generate an object-relational ......
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 QuickBooks ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from QuickBooks and/or QuickBooks Online into a Microsoft SQL Server database. The exact same ......
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 SalesForce ADO.NET Data Provider inside of a SQL Server SSIS workflow to transfer data directly from SalesForce account into a Microsoft SQL Server database. Step 1: Open Visual Studio and ......
This article walks through the process of using the SharePoint Data Provider and authenticating with SharePoint Online / Office 365. This tutorial covers how to perform this programmatically and with the Visual Studio Server Explorer. In addition to accessing lists from local installations of SharePoint server, the SharePoint Data Provider also supports accessing lists from SharePoint Online. SharePoint Online and Office 365 authentication requires a cookie based authentication. To connect to SharePoint ......
In this demo, we will demonstrate how to use LINQ to access tables in QuickBooks through the QuickBooks ADO.NET Data Provider. To do this we will LINQ to Entity Framework, which is used to generate the connection and can be used with any RSSBus ADO.NET Data Providers to access data via LINQ. Step 1: Open Visual Studio and create a new project. Step 2: Right click on the project and choose to add a new item. Select to add an ADO.NET Entity Data Model. Step 3: Choose to generate from database and click ......
The RSSBus Data Providers for ADO.NET include out-of-the-box support for Microsoft Visual Studio LightSwitch. In this demo, we will show you how to create a LightSwitch application that connects with QuickBooks and displays QuickBooks account data through the QuickBooks ADO.NET Data Provider. This exact same procedure outlined below can be used with any RSSBus ADO.NET Data Providers to integrate data with LightSwitch applications. Before We Begin QuickBooks provides no connectivity to its data over ......
By Mike Gold, November 30, 2010 This article was originally written and hosted on c-sharp corner Introduction The world is full of information and there are all kinds of ways to access it. The Microsoft .NET framework provides several convenient ways to access data from different data sources, whether it's an XML file, a web stream, or a database. For databases, Microsoft offers several techniques for retrieving the data. One of the simplest forms is through an ADO.NET Data Provider. The Data Provider ......
Are you looking for a quick and easy way to access your Google Docs from PowerShell? The Google Data Provider provides an easy-to-use ADO.NET interface that you can take advantage of with your PowerShell Scripts. Simply use the included SQL like .NET objects (GoogleConnection, GoogleCommand, GoogleDataAdapter, etc) in your PowerShell scripts to connect to your Google Apps accounts and synchronize, automate, download, and more! Using the Google Data Provider in PowerShell to List Google Docs: # Load ......
By i-programmer, January 24, 2011 This article was originally written and hosted on i-programmer Introduction Interacting with websites via the wide range of APIs that are on offer is attractive because it provides new possibilities but is slightly depressing because you have to find out how to do the job all over again for each API. Now there is a better way. RSSBus has implemented a range of common APIs as ADO.NET data providers - Google, QuickBooks, Salesforce and SharePoint, with more planned. ......
Charts can be essential when it comes to displaying critical information or making decisions based on the most recent information. Using the SalesForce ADO.NET Provider, you can easily chart your SalesForce Data in Visual Studio. This article demonstrates how easy it is to get your SalesForce data and databind it to a chart. For this example, we will use the Microsoft Charting controls available in .NET 3.5. The exact same procedure outlined below can be used with any RSSBus ADO.NET Data Providers ......
By Rich Dudley, ComponentOne, December 6, 2010 This article was originally written and hosted on the ComponentOne Community Site The RSSBus QuickBooks Connector abstracts the QuickBooks API into a familiar, database-like programming model. After installation, the QuickBooks connector is added as an ADO.NET Data Source, and QB now operates as a database of sorts. We can query "tables" containing customer, sales orders, invoice data and more. Since the data connection is two-way, we can also update ......