I have a requirement to retrieve DOMAIN\UserName credentials here on my intranet for several web applications written in Cold Fusion. Needless to say getting this variable has proven cumbersome until recently. My question is, does DNN have something in the core already that provides the following functionality?  It's an awesome addition to my arsenal. I'm not the author or creator of this functionality so please review the source here.

My stored procedure's Select statement in my custom module requires my LOGON credentials to query an external database. I created an ExpressionBuilder.vb file and placed it in the App_Code directory.

Imports System.Web.Compilation
Imports System.CodeDom
<ExpressionPrefix("Code")> _
Public Class CodeExpressionBuilder
Inherits ExpressionBuilder
Public Overloads Overrides Function GetCodeExpression(ByVal entry As BoundPropertyEntry, ByVal parsedData As Object, ByVal context As ExpressionBuilderContext) As CodeExpression
Return New CodeSnippetExpression(entry.Expression)
End Function
End Class

 Finally, my SelectParameter for the Stored Procedure looks like this.

If DNN has something similar I would rather use the core to accomplish this task. If anyone has any insight on a better solution for retrieving this information for an Intranet environment please share. For now this is what I have.

Jon

Yes I did. Until the Authentication Provider gets seperated from the core and works flawlessly in child sites it's not an option. Unfortunately, this is all tied to external databases with web sites having anonymous turned off.

DNN's maturity for Intranets is evolving, albeit too slowly. Unfortunately, with many large organizational consolidation efforts (particularly DoD) and DNN's competition from Sharepoint my ability to continue leveraging DNN in my environment is becoming more difficult to sell.