Search Wiki:

Overview


SharePoint 2010 offers many new opportunities to developers, and especially with LINQ to SharePoint. This technology brings a greater flexibility to the developpement model to use more easily the data contains in the SharePoint lists. Now to make a query in a SharePoint list is as easy as making a query within a database table, thanks to a real object relational mapping process. This tool generates SharePoint classes (like the command line tool SPMETAL) directly in Visual Studio as a design schema (like LINQ to Entities). This new feature is an extension to Visual Studio for modeling LINQ to SharePoint entities. With this tool, it’s become possible to add a new kind of item in a VS project, called a LINQ to SharePoint schema (or LINQ to SharePoint data model).

Please note that the LINQ to SharePoint DSL Extension for VS2010 is not officially supported by Microsoft.

Support is provided only via the Issue tracker and the discussion forum in this project space.

You can found additionnal resources or tutorials about this tool on my MSDN blog.

Latest release


Latest stable version: v1.3.2 new.png
Complete release notes (05-12-2011)

Binaries
download_icon.gif Download: LINQ to SharePoint DSL Extention.v1.3.2.msi (4 311 Ko)

Documentation
xps.gif Download: LINQ to SharePoint DSL Extention.v1.3.2.xps (3 669 Ko)
pdf.gif Download: LINQ to SharePoint DSL Extention.v1.3.2.pdf (2 615 Ko)
zip.gif Download: AdventureWorksLT Sample Kit.zip (6 544 Ko)

Project description


LINQ to SharePoint DSL Extension project contains the following features:
  • Visual Studio 2010 Extension to manage *.l2sp schema files and to generate code
  • New "LINQ to SharePoint Data Model" Visual Studio item type
  • Wizard to build a mapping model
  • Preconstructed SharePoint site models including blank model, team site, blog, document workspace,...
  • Wizard to automatically load the model from an existing SharePoint 2010 web site
  • Visual LINQ to SharePoint entities designer
  • Automatic generation of code thanks T4 text templating technology
  • Support C# or VB.net
  • LINQ to SharePoint DSL Repository Generator Visual Studio item to generate a complete Repository layer from an existing model. The repository generated code is available for C# or VB.Net
  • Support remote connexions with SSL, with classical mode or with FBA claims based authentication mode
  • Automatic update feature from a site (to add or remove elements from schema)
  • Save schemas as BITMAP (bmp), JPEG (jpg), ENHANCED METAFILE (emf) or PORTABLE NETWORK GRAPHIC (png)
  • Support two classes generation modes: native with T4 or with SPMETAL
  • Schema to SPMETAL parameter XML file feature
  • Embedding SPMETAL classes generation process inside Visual Studio 2010
  • Support model import from SharePoint site with language packs (not only English site support)
  • EXPERIMENTAL BETA feature to automatically export a model to SharePoint definitions Visual Studio items (lists and content types definitions)
  • Adventure Works LT sample kit to show LINQ to SharePoint DSL features in action
  • new.png Support connection to Office 365 BETA web sites
  • new.png Support connection to anonymous SharePoint sites

This tool requires:
  • Visual Studio 2010 Pro/Ultimate RTM - English
  • SharePoint Server 2010 RTM (or Microsoft SharePoint Foundation 2010 RTM) - English or other languages

Screenshots


DSL Designer screenshots

Diagram_small.png LINQ to SharePoint DSL 11_small.png LINQ to SharePoint DSL 24_small.png
px50.gifzoom_icon.gifZoompx50.gifpx50.gifpx50.gifpx50.gifpx50.gifzoom_icon.gifZoom px50.gifpx50.gifzoom_icon.gifZoom

Wizard to import SharePoint site schema

LINQ to SharePoint DSL 06_small.png LINQ to SharePoint DSL 07_small.png LINQ to SharePoint DSL 08_small.png LINQ to SharePoint DSL 09_small.png
px50.gifzoom_icon.gif Zoom px50.gifpx50.gifpx50.gifzoom_icon.gifZoom px50.gifpx50.gifzoom_icon.gifZoom px50.gifpx50.gifpx50.gifzoom_icon.gifZoom

Wizard to update a schema from an existing SharePoint site

Update-01_small.png Update-02_small.png Update-03_small.png Update-04_small.png
px50.gifzoom_icon.gif Zoom px50.gifpx50.gifpx50.gifzoom_icon.gifZoom px50.gifpx50.gifzoom_icon.gifZoom px50.gifpx50.gifpx50.gifzoom_icon.gifZoom

SPMETAL code generation from schema

SPMETAL-01_small.png SPMETAL-02_small.png
px50.gifzoom_icon.gif Zoom px50.gifpx50.gifpx50.gifpx50.gifpx50.gifzoom_icon.gifZoom

Repository pattern generator

Repository-Item1-small.png Repository-Item2-small.png
px50.gifzoom_icon.gif Zoom px50.gifpx50.gifpx50.gifzoom_icon.gifZoom

Export model lists and content types to SharePoint definitions items

Export1-small.png Export2-small.png Export3-small.png Export4-small.png
px50.gifzoom_icon.gif Zoom px50.gifpx50.gifzoom_icon.gifZoom px50.gifpx50.gifzoom_icon.gifZoom px50.gifpx50.gifzoom_icon.gifZoom

AdventureWorks LT sample toolkit

AdventureWorks1-small.png AdventureWorks2-small.png AdventureWorks3-small.png
px50.gifzoom_icon.gif Zoom px50.gifpx50.gifpx50.gifzoom_icon.gifZoom px50.gifpx50.gifzoom_icon.gifZoom

Screencasts


Screencast #1: Extension overview
Date: (04-29-2010)
Available language: English & French
Duration: 00:10:00
Format: WMV HD
screencast1-en.png screencast1-fr.png
zoom_icon.gif Download (EN) zoom_icon.gif Download (FR)

Previous versions


Version 1.3.1
Complete release notes (05-02-2011)
download_icon.gif Download: LINQ to SharePoint DSL Extention.v1.3.1.msi (4 303 Ko)
xps.gif Download: LINQ to SharePoint DSL Extention.v1.3.1.xps (3 523 Ko)
pdf.gif Download: LINQ to SharePoint DSL Extention.v1.3.1.pdf (2 504 Ko)
zip.gif Download: AdventureWorksLT Sample Kit.zip (6 544 Ko)

Version 1.3
Complete release notes (04-16-2011)
download_icon.gif Download: LINQ to SharePoint DSL Extention.v1.3.msi (4 301 Ko)
xps.gif Download: LINQ to SharePoint DSL Extention.v1.3.xps (4 768 Ko)
pdf.gif Download: LINQ to SharePoint DSL Extention.v1.3.pdf (3 496 Ko)
zip.gif Download: AdventureWorksLT Sample Kit.zip (3 496 Ko)

Version 1.3 Beta
Complete release notes (03-15-2011)
download_icon.gif Download: LINQ to SharePoint DSL Extention.v1.3.Beta.msi (4 278 Ko)
xps.gif Download: LINQ to SharePoint DSL Extention.v1.3.Beta.xps (15 418 Ko)
pdf.gif Download: LINQ to SharePoint DSL Extention.v1.3.Beta.pdf (4 667 Ko)

Version 1.2
Complete release notes (11-14-2010)
download_icon.gif Download: LINQ to SharePoint DSL Extention.v1.2.msi (3 984 Ko)
xps.gif Download: LINQ to SharePoint DSL Extention.v1.2.xps (3 060 Ko)
pdf.gif Download: LINQ to SharePoint DSL Extention.v1.2.pdf (2 104 Ko)

Version 1.1
Complete release notes (11-08-2010)
download_icon.gif Download: LINQ to SharePoint DSL Extention.v1.1.msi (3 899 Ko)
xps.gif Download: LINQ to SharePoint DSL Extention.v1.1.xps (2 567 Ko)
pdf.gif Download: LINQ to SharePoint DSL Extention.v1.1.pdf (1 764K Ko)

Version 1.0
Complete release notes (05-14-2010)
download_icon.gif Download: LINQ to SharePoint DSL Extention.v1.0.msi (1 978 Ko)
xps.gif Download: LINQ to SharePoint DSL Extention.v1.0.xps (2 373 Ko)
pdf.gif Download: LINQ to SharePoint DSL Extention.v1.0.pdf (1 621 Ko)

Version 1.0 CTP (Community Technology Preview)
Complete release notes (04-29-2010)
download_icon.gif Download: LINQ to SharePoint DSL Extention.v1.0CTP.msi (494 Ko)
xps.gif Download: LINQ to SharePoint DSL Extention.v1.0CTP.xps (2031 Ko)
pdf.gif Download: LINQ to SharePoint DSL Extention.v1.0CTP.pdf (1 352 Ko)

History


05-02-2011 Release version: 1.3.1
04-16-2011 Release version: 1.3
03-15-2011 Release version: 1.3 Beta
11-14-2010 Release version: 1.2
11-08-2010 Release version: 1.1
05-14-2010 Release version: 1.0
04-29-2010 Release version: 1.0 CTP
03-03-2010 Release version: 0.9
02-02-2010 Release version: 0.8.1 Alpha
01-30-2010 Release version: 0.8 Alpha
Last edited May 12 2011 at 3:03 PM  by OlivierCarpentier, version 118
Comments
Goddard wrote  Nov 27 2010 at 6:04 AM  
This is a true Gem!!! You have done a fantastic job on this and I stumbled upon it only after writing my own VSIX project to generate classes with SPMetal. You've done a bang-up job on the class designer. I was really hoping to see support for external content types, which is actually how I came across this great developer productivity tool! Is there any plan to incorporate this with the default build of VS?

Thanks for this great tool!

SteveB_ wrote  Jun 27 2012 at 12:56 PM  
This tools would benefits from going opensource, on hosted that encourage collaborative and community development (I think github, but codeplex wit git also).

From a production perspective, it's hard to work with a project maintained by only one guy. Microsoft does not support it. The source code is not available. So what's happen if tomorrow a major issue appears with this software and Olivier Carpentier is not able to fix (or does not have time, or have better things to do with o15, or ... or ...).

I'm not religiously saying that open source is the way to think today. But I think software should either be commercial and supported or open source.

Hope my call will be hear.

chees
steve

OlivierCarpentier wrote  Aug 24 2012 at 1:49 PM  
Hi SteveB_, I'm agree with you and I tried to move this project on codeplex with an open source license some month ago. But for very specific legal requirements, I can not do that. I'm really sorry for that. So the project is now available "as is" with a lot of whitespaces and bugs. My release roadmap is very slow and to be honnest, is as "a best effort". If you're using this tool and that it's working fine it's good for you. But if you're planning to use it on a new project on a production project, think about these limitations.

Regards,

Olivier

Updating...
Page view tracker