This entry is part 5 of 4 in the series Sitecore: Track External Link with DMSThis article is part 3 of Sitecore How To: Track Exteral links with DMS series. Before starting with this step you need to be finished with Step 2. Otherwise you don’t have any report data. Show the outgoing links in a report The easiest way to generate a report is find a report that matches your needs, copy the report and change the datasource and layout. For this POC More Info »

In this article I’m going to explain how to convert .mrt reports from the Sitecore Online Marketing Suite (Sitecore 6.4) to the Sitecore Digital Marketing System (Sitecore 6.5). Report related changes between OMS and DMS Both the OMS and the DMS use .mrt reports for Analitics reporting. There are two mayor changes between the OMS and DMS reporting; a full redesign of the datamodel and the location of the SQL query for the report data. Mapping the datamodel of the OMS with More Info »

You have to specify which related-data you want to retrieve from a object so you can access them outside the Linq data-context. You can achieve this by using the LoadWith method of the DataLoadOptions Class. The LoadWith method accepts an lambda expression that specifies which object you want to retrieve. In the following example I have a employee table that has a relation with the company table. In my code I want to show the employee with the company name (outside the More Info »

For a customer I needed to do a review there database (MSSQL 2000 database). For this I wanted to create some database diagrams. When I tried to create a diagram with Sql Sever Management Studio I got the following message: "Database diagram support objects cannot be installed because this database does not gave a valid owner." To fix this problem you need to set the owner and change the Compatibility Level of the database. You can do this with the following steps within Sql Sever More Info »

When I was trying to publish a database to my shared hosting provider I encountered some problems with backup and restoring my database. To restore a database on my provider I needed a full Sql script (schema and data). After a few attempts with SQL comparer and Management studio I found a link to ‘Microsoft SQL Server Database Publishing Wizard 1.1’. The Publising Wizard does complete backups to SQL script (including data). When I tried running the Publishing Wizard on my Vista More Info »

Update 20 may 2009: New easy sollution Set the Connection -> Application Settings property True. This will generate a connection string in your app.config.   Copy this connection string to your web.config and your all set!   =================================================================  Old post:  If you want to use your connectionstring from the web.config with Linq to Sql (dbml) you have to add the following partial class to your project: [code:c#] namespace Your.Namespace {   partial class yourDataContext   {     partial void OnCreated()     { More Info »

Execute the next query to enable CLR.   [code:c#] // Turn advanced options on EXEC sp_configure 'show advanced options' , '1'; go reconfigure; go EXEC sp_configure 'clr enabled' , '1' go reconfigure; // Turn advanced options back off EXEC sp_configure 'show advanced options' , '0'; go [/code] More info about CLR on Microsoft MSDN.

When using an Linq Datasource (linq to sql) for a datagrid (Gridview, ListView, etc) you don't always want all rows from a table. To exclute data you can use the WhereParameters to add an where statement to your DataSource. You can do limited where statements with the Visual Studio Wizards. When you need more than a limited statement you can dynamicly create an Parameter to add to your Linq DataSource. The following examples shows how to filter the Linq Datasource that recovers all rows from the Post More Info »