Monthly Archives: April 2014

SharePoint Excel Services debugging



I was surprised to find this but this is a gem for anyone struggling with Excel Services errors. Microsoft made a flow chart of what Excel Services does during a data refresh. This helped me debug errors that made no sense at one point.

Quote from the link above:

“Use this flowchart to better understand how Excel Services in Microsoft SharePoint Server 2010 refreshes data or to troubleshoot data connection errors from Excel Services.

The Excel Services Data Refresh Flowchart shows the sequence of actions performed by Excel Services when it refreshes data in a data-connected Microsoft Excel workbook that is being rendered by Excel Services. This includes sequences for the three available authentication options (Windows, Secure Store Service, and None), plus sequences for embedded connections and connections that use Office Data Connection files. The flowchart also includes the connection errors that can occur at each step, and it suggests configuration steps to avoid or correct the errors.”

Hope this helps someone.

Good to know!?: .NET – Accessing, Querying and Manipulating data with Entity Framework


I gathered some links and resources on data manipulation with the .NET Framework. Hope this helps and works as a reference card what is available:

Entity Framework
Configuring Parameters and Parameter Data Types
.NET Framework Data Providers
DataSet Class
Retrieving Data Using a DataReader
Entity Framework – Database First
Entity Framework- Code First to a New Database
ADO.NET Entity Data Model Designer
Entity Data Model Wizard
Create Database Wizard (Master Data Services Configuration Manager)
Update Model Wizard (Entity Data Model Tools)
Using the DbContext API
Table-per-Type vs Table-per-Hierarchy Inheritance
Relational database management system
ObjectContext Class
DBContext vs ObjectContexts
DbContext Class
ObjectContext management
How to: Use Lazy Loading to Load Related Objects
EntityObject Class
EdmEntityTypeAttribute Class
SerializableAttribute Class
DataContractAttribute Class
Entity Framework (EF) Documentation
OData protocol
Open Data Protocol by Example
WCF Data Services Overview
Using the REST Interface
Understanding Service-Oriented Architecture
WCF Data Services 4.5
Advanced using OData in .NET: WCF Data Services
ObjectCache Class
HttpContext.Cache Property
ASP.NET Application State Overview
ASP.NET Session State Overview
Understanding ASP.NET View State
CacheItemPolicy Class
CacheItemPriority Enumeration
ChangeMonitor Class
CacheDependency Class
System.Transactions Namespace
EntityTransaction Class
EntityCommand Class
EntityConnection Class
SqlTransaction Class
System.Data.EntityClient Namespace
IsolationLevel Enumeration
TransactionScope Class
System.Xml Namespaces
XmlWriter Class
XML Documents and Data
XmlDocument Class
XmlReader Class
XPath Examples
LINQ to XML [from BPUEDev11]
LINQ to XML Overview
XElement Class
LINQ (Language-Integrated Query)
DbContext.SaveChanges Method
DbContext.Set<TEntity> Method
Object-relational impedance mismatch
Loading Related Entities (Eager Loading,  Lazy Loading, Explicitly Loading)
Demystifying Entity Framework Strategies: Loading Related Data (Eager Loading,  Lazy Loading, Explicitly Loading)
Precompiling LINQ Queries
Entity Framework 5: Controlling automatic query compilation
Improve Performance with Entity Framework 5
Queries in LINQ to Entities
LINQ to Entities: Basic Concepts and Features
LINQ to Objects
SqlConnectionStringBuilder Class
ObjectQuery<T> Class
ObjectQuery Class
ObjectQuery.ToTraceString Method
System.Data.SqlClient Namespace
SqlConnection Class
SQL Server Connection Pooling (ADO.NET)
DataTable Class
DataSet Class
DataAdapter Class
SqlCommand Class
SqlCommand.CommandText Property
CommandType Enumeration
SqlDataAdapter Class
SqlCommand.ExecuteScalar Method
SqlCommand.ExecuteReader Method
SqlDataReader Class
SqlDataReader.Read Method
DbDataAdapter.Fill Method (DataSet)
DbDataAdapter.Update Method (DataSet)
DataAdapter.AcceptChangesDuringFill Property
Working with Datasets in Visual Studio
SqlParameter Class
EF Designer TPT Inheritance
Walkthrough: Mapping Table-per-Hierarchy Inheritance in Dynamic Data
Code First to an Existing Database
Model-First in the Entity Framework 4
ADO.NET Entity Data Model Designer
The ADO.NET Entity Framework Overview
ADO.NET Entity Data Model Tools
Plain Old CLR Object(POCO)
Working with POCO Entities

SharePoint SummeryLinks Webpart JQuery modifications – Make it into a “drop down” menu

Here is a small JQuery piece of code that you can use to minimize the space required on a page with summary links webpart. This will collapse the links listing under the webpart title. To make the links visible again you have to press the webpart title again.


jQuery(“table .dfwp-list”).slideUp();

jQuery(“table .dfwp-list”).closest(‘table’).hover(

The JQuery code above is tested on SharePoint 2010. The most important piece in this code is the CSS class named dfwp-list. When targeting this class you are targeting an UL LI HTML structure where the links exist. With a little modification you can use this code to add the each LI borders, colors and other styling to make it look more like a drop down menu.

Microsoft Forefront Unified Access Gateway a.k.a UAG modifications – custom look and styling


A simple post to those who are wondering how to modify the look of your UAG pages. The simplest tip is that seach under the UAG folder any folder named as “CustomUpdate”. Each web related attribute has its own CustomUpdate folder. Look below for example. Just navigate to that location and modify the files you need to. If the related file such as the template.css is missing you can use as your base the MS out of the box tempalte.css found one level up from the CustomUpdate folder.

Sample locations:

C:\Program Files\Microsoft Forefront Unified Access Gateway\von\InternalSite\css\CustomUpdate

C:\Program Files\Microsoft Forefront Unified Access Gateway\von\InternalSite\Languages\CustomUpdate

C:\Program Files\Microsoft Forefront Unified Access Gateway\von\InternalSite\Images\CustomUpdate

C:\Program Files\Microsoft Forefront Unified Access Gateway\von\InternalSite\CustomUpdate (this for ASP pages)

Related links on more information on how to do modifications:

UAG 2010 Custom Logon and Logoff Pages