Archive for March, 2010

 

Asserting Facts to the Business Rules Engine from .NET

March 17th, 2010

Facts can be asserted to the BRE from .NET code simply by passing them as an argument to the policy’s execute method which takes a variable number of parameters. For example,
Microsoft.RuleEngine.Policy policy = new Microsoft.RuleEngine.Policy(“PolicyName”);
Policy.Execute(Object1, Object2,…);
There are three types of facts used by the BRE: An xml document, a Database table, and a [...]

Read full article | Comments Off

Paging with SQL Server 2000

March 17th, 2010

With Microsoft SQL Server 2005, paging on the database side is simple. There is a built-in ROW_NUMBER function designed specifically for this task. However, versions of SQL Server prior to 2005 do not have this capability. Below is one way to implement similar functionality in pre-2005 versions.
SELECT TOP X * FROM [...]

Read full article | Comments Off

ASP.NET Security Context

March 17th, 2010

Figuring out the credentials passed by an ASP.NET application hosted on an IIS server to a remote resource is a common question in the community forums. Typical errors associated with this type of enquiry are “Acces to the path ‘C:\YourFolder’ is denied” or “Login failed for user ‘username’. Reason: Not associated with a trusted SQL [...]

Read full article | Comments Off