.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Are there any issues in SharePoint 2010 BCS when working with large data?

Posted By:      Posted Date: November 20, 2010    Points: 0   Category :SharePoint
 

Hi,

We are working on suggesting the best approach that would be suitable to support user data stored in SQL Server 2008. User data is huge (in Terabytes).

I need to understand if there are any issues using MOSS 2007 BDC or SharePoint 2010 BCS to interact with SQL Server 2008 database tables? I understand that BCS offers a no-code solution for interacting with SQL tables, however when handling such large data, can we have better performance if Stored Procedures and ADO.Net is used to fetch and update the data?

All in all I need to understand the pros and cons in both these approaches. Any pointers, specifically to related real world case studies shall highly be appreciated. Thanks much!




View Complete Post


More Related Resource Links

Are there any limitations in SharePoint 2010 BCS when working with large data?

  

Hi,

We are working on suggesting the best approach that would be suitable to support user data stored in SQL Server 2008. User data is huge (in Terabytes). I need to understand if there are any issues using MOSS 2007 BDC or SharePoint 2010 BCS to interact with SQL Server 2008 database tables? I understand that BCS offers a no-code solution for interacting with SQL tables, however when handling such large data, can we have better performance if Stored Procedures and ADO.Net is used to fetch and update the data?

All in all I need to understand the pros and cons in both these approaches. Any pointers, specifically to related real world case studies shall highly be appreciated. Thanks much!


format-number issues with the Data View Web Part in SharePoint 2010

  
I have a number column named @Year_x0020_1_x0020_Revenue in the data view web part in SharePoint Designer 2010. In the Xpath expression builder - @Year_x0020_1_x0020_Revenue previews "500,000" If I use the format-number in the Xpath expression builder ==> format-number(@Year_x0020_1_x0020_Revenue, '$#,##0.00;-$#,##0.00'), it returns NaN. Is there any reason? 

Accessing SharePoint 2010 Data with Server-Side APIs

  
Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010

  

SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010


In sharepoint excel working fine in office 2007 but not in office 2010

  

Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.

 

This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.

 

Can you let me know why is problem is coming and how to resolve this.

 

Thanks

Sanjeev Tiwari

 


Quick Note: Create Silverlight Applications to Access SharePoint 2010 Data

  
In this exercise, you will learn how to create Silverlight applications to display SharePoint 2010 lists inside DataGrid controls.

Quick Note: Create Silverlight Graphs with SharePoint 2010 Data by Using LINQ

  
In this exercise, you will learn how to create Silverlight applications to retrieve SharePoint 2010 list data using LINQ.

Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

  
Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Developer Training: Data Access in Technologies in SharePoint 2010

  
Learn about the new data access technologies in SharePoint 2010 and how they can help increase your productivity. This training module covers the basics of LINQ handling and how to use the Client OM and REST to access SharePoint 2010 information remotely.

Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ

  
In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.

Quick Note (Scenario): Getting Started with Data Access in SharePoint 2010

  
The goal of these exercises is to give you the steps that you need to access data from various sources by using web development tools and technologies such as SharePoint 2010 and Visual Studio 2010.

Sample: SharePoint Server 2010: Aggregating Data Using BCS and .NET Assemblies

  
Use the BCS Data Aggregation sample with BCS in SharePoint Server 2010 and to aggregate data from two external systems.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

  
Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Quick Note: Working with the SharePoint 2010 Ribbon User Interface

  
Learn to extend the Microsoft SharePoint 2010 ribbon by adding a custom button that executes server-side code.

Integrating External Data and Microsoft SharePoint 2010 Platform Services in Microsoft Office 2010 S

  
Microsoft Office 2010 integrates with SharePoint more closely than in previous versions. The resources here show you how to take advantage of the powerful collaboration infrastructure.

Video: Managing Data with SharePoint 2010

  
Learn how to manage data and create forms to support lists in SharePoint 2010. (Length: 11:52)
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend