Webcast: SQL Server and SharePoint Data Integration
SharePoint’s Data View web part can do much more than just view data. It can serve as a complete front-end to your SQL Server (and other data store) information allowing you to create robust applications without writing code. In this session, you will see just how to create such an application including conditional graphics. You’ll even learn how to pass data from SQL Server into a SharePoint Designer workflow for business process automation.
Presented by: Ricky Spears
> Register Now
> Live date: 10/6/2010 at 12:00 Pacific
Featured White Paper(s)
Did You Know? It’s Easy to Simplify SQL Server Management: Helpful SQL Server Tips: A Quest E-book
Optimizing SQL Server performance isn’t easy. There’s a lot of information about solving performance problems, but not much a… (read more)
Featured Script
dba3_REBUILD_LOG
Rebuild a transaction log (for problem databases only!) put the DB into bypass recovery mode then drop all TL extents, and cr… (read more)
LINQ to SharePoint
This is the SQL Server and SharePoint Worldwide Users Group. For too long I have been concentrating on SQL Server topics. So I decided to dig in to something for SharePoint today.
LINQ (Language Integrated Query), as you probably know, is an extremely useful tool for managing sets of data. It comes with many providers allowing it to run SQL like queries against almost anything that can be enumerated (sets, collections, dictionaries, tables, lists, containers).
Lists are one of the key features of SharePoint. LINQ to SharePoint is a data provider allowing you to traverse lists in SharePoint and enumerate them using LINQ Syntax. There is a downside; in order to use LINQ to SharePoint, you have to create a class variable defining the contents of the list before you can run the LINQ query.
The upside, you don’t have to access the SharePoint data from the hosting database, or understand the schema behind the site. Moreover, since you access the data through the URL you don’t even have to know where the data or base is hosted. As long as you have access to the list you can enumerate it with a LINQ query and a custom Class defining the list.
Interested, take a look at the C# example at Microsoft (sorry, VB is not supported for this).
Drop me a note with your SharePoint questions or solutions. Send them to btaylor@sswug.org.
Cheers,
Ben
Attend a *Real* Virtual Conference… (70 sessions, 20 speakers!)
with NO travel, – top presenters, top content, just focus on learning. Awesome technical sessions from some of the best and most well-known technical presenters out there. We have a spot saved for you at the SSWUG.ORG Virtual Conference – are you confirmed yet? Check out the sessions, speakers and schedules here on the site, then be sure to register ASAP for the best rates going.
> Register Now