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 […]
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 […]
MSSQL: Database diagram support objects cannot be installed because this database does not gave a valid owner.
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 […]
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 […]
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) […]
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 […]