November 2007 – Emil's Lost & Found Archive

Retrieving the database id

Posted onNovember 19, 2007August 31, 2016AuthorEmilLeave a comment

It can sometimes be useful to know the id of a given database, e.g. for filtering events when profiling. Here are a few ways to do that:

-- Current database
select db_id()

-- Named database
select db_id('Northwind')

-- All databases
use master
select name, dbid from sysdatabases

Signalling events from a class

Posted onNovember 15, 2007May 4, 2008AuthorEmilLeave a comment

For easy reference, here’s how to create an event in a class that listeners can react to:

class DeleteSubOrderEventArgs : EventArgs
{
    public int SubOrderId;
    public DeleteSubOrderEventArgs(int subOrderId)
    {
        SubOrderId = subOrderId;
    }
}

class Foobar
{
    public delegate void DeleteEventDelegate(object sender, DeleteSubOrderEventArgs e);
    public event DeleteEventDelegate DeleteSubOrderClick;
    
    protected void DeleteButton_Click(object sender, ImageClickEventArgs e)
    {
        // Signal to listeners
        if (DeleteSubOrderClick != null)
        {
            DeleteSubOrderClick(this, new DeleteSubOrderEventArgs(SubOrder.SubOrderId));
        }
    }
}

How to embed an Xslt-file in an assembly

Posted onNovember 14, 2007May 4, 2008AuthorEmilLeave a comment

Problem
How do I embed an Xslt file into an assembly so that I won’t have to deploy the file together with the assembly, set configuration options to refer to the file, etc?

Solution

Create a resource (.resx) file in the project
In the resource designer, click “Add Resource” and choose “Add Existing File…”. Select the Xslt file.
Give the new resource a describing name, such as “FilterContentXslt”. The contents of the Xslt file will be available in a string property with this name in the Resource manager.

Code that performs the transformation:

// Parse the content into an XmlDocument
XmlDocument doc = new XmlDocument();
doc.LoadXml(xmlValue);

// Retrieve the embedded resource containing the XSLT transform
XmlDocument xsltDoc = new XmlDocument();
xsltDoc.LoadXml(Resources.FilterContentXslt);

XslCompiledTransform trans = new XslCompiledTransform();
trans.Load(xsltDoc);

// Perform the transformation
StringWriter writer = new StringWriter();
trans.Transform(doc, writer);
string newXmlValue = writer.ToString();

Simple, and it works.

/Emil