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 exploit 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.

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.

Latest release


Latest stable version : v1.3 new.png
Complete release notes (04-16-2011)

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

Documentation
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)

Project description


LINQ to SharePoint DSL Extension project contains the following features:
  • Visual Studio 2010 Extension to manage *.l2sp schema files and generate code
  • New "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
  • 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 SPMETAL feature
  • Schema to SPMETAL parameter XML file feature
  • Embedding SPMETAL classes generation process inside Visual Studio 2010
  • new.png New: New 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
  • new.png New: Support model import from SharePoint site with language packs (not only English site support)
  • new.png New: EXPERIMENTAL BETA feature to automatically export a model to SharePoint definitions Visual Studio items (lists and content types definitions)

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

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

Previous versions


Version : v1.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)

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)


History


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 Apr 16 2011 at 7:55 PM  by OlivierCarpentier, version 92
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