Read from database as I do from web.config

[brent]

Currently our application is reading from the web.config, and retrieves a
section, "softwareRequir ements". Because the section will begin to grow
dramatically, I'd like to place it in the SQL database instead. I've
imported the values, and am retrieving them as FOR XML AUTO in the stored
proc to mimic the structure in the web.config. I'm confused now - what data
type is being returned by
system.configur ation.configura tionsettings.ge tconfig()? It looks like it has
to be an array or xml, but I'm not experienced enough at .NET to determine
how to best handle it. I would like to just provide a different data source
and leave the rest of my code the same.

Current code to read web.config:

Public Shared Function SoftwareRequire ments() As
SoftwareRequire mentsView
Return
System.Configur ation.Configura tionSettings.Ge tConfig("softwa reRequirements" )
End Function

<Serializable() > _
Public Class SoftwareRequire mentView
Inherits UserProvisionin gData.SoftwareR equirement

Private _ctrlId As String

Public Sub New(ByVal name As String, ByVal value As String, ByVal prompt
As String, ByVal availableTo As String)
MyBase.New(name , value, prompt, availableTo)
End Sub

Public Property ControlId() As String
Get
Return _ctrlId
End Get
Set(ByVal Value As String)
_ctrlId = Value
End Set
End Property

Public ReadOnly Property AdditionalRequi rement(ByVal name As String) As
ItemDetail
Get
Dim result As ItemDetail
For Each req As ItemDetail In MyBase.Addition alRequirements
If req.Name = name Then
result = req
Exit For
End If
Next
Return result
End Get
End Property
End Class

I'm attempting to pass data in from SQL instead:

Public Function GetSoftwareConf iguration(ByVal divisionId As Integer,
ByVal brandId As Integer, ByVal operationId As Integer, ByVal branchId As
Integer) As ArrayList
Dim methodPerf As New FNF.Services.Co mmon.PerfAutoTr ace
Dim result As ArrayList =
DBCommon.GetDat aArray(GetType( UserProvisionin gData.SoftwareR equirement),
DBCommon.Connec tionString("myD B"), "get_SoftwareCo nfig", New Object()
{divisionId, brandId, operationId, branchId})
methodPerf.Disp ose()
Return result
End Function

Public Shared Function GetDataArray(By Val returnType As Type, ByVal
connectionStrin g As String, ByVal storedProcName As String, Optional ByVal
params() As Object = Nothing) As Object
Dim reader As SqlDataReader
Dim result As New ArrayList

Try
reader = SqlHelper.Execu teReader(connec tionString,
storedProcName, params)

While (reader.Read)
Dim item As Object = returnType.Invo keMember("New",
Reflection.Bind ingFlags.Create Instance, Nothing, Nothing, New Object()
{reader})
result.Add(item )
End While
Catch ex As FNFException
Throw
Catch ex As Exception
Dim newEx As New FNFException("E rror getting data from
database", New Object() {connectionStri ng, storedProcName} , ex)
ExceptionManage r.Publish(newEx )
Throw newEx
Finally
If Not (reader Is Nothing) Then reader.Close()
End Try

Return result
End Function

Public Shared Function getFromSQLInste adOfWebConfigTe st() As Object
Dim data As UserProvisionin gData.DataReque st
Return data.GetSoftwar eConfiguration( 1, 1, 1, 1)
End Function

When I try to load the page I get an exception when calling my

Dim softReqView As Object =
SoftwareRequire mentsConfigSect ion.SoftwareReq uirements 'calling the
web.config & works great.
Dim softReqViewFrom SQL As Object =
SoftwareRequire mentsConfigSect ion.getFromSQLI nsteadOfWebConf igTest 'calling
sql and throws exception

Exception is:
Exception Type: System.NullRefe renceException
Message: Object reference not set to an instance of an object.

Any help would be appreciated.

Thanks,

Brent

[Peter Rilling]

You cannot because the framework itself loads the config when the app domain
starts. You cannot load it from a different location.

The object returned by GetConfig is dependent on the configuration handler
that is parsing the web.config XML. The reason for GetConfig is that you
can have an arbitrary XML structure in the config file that gets processed
and wrapped by some handler. That is why GetConfig returns an Object type.

"brent" <br***@newsgrou p.nospam> wrote in message
news:u6******** ******@TK2MSFTN GP10.phx.gbl...

Currently our application is reading from the web.config, and retrieves a
section, "softwareRequir ements". Because the section will begin to grow
dramatically, I'd like to place it in the SQL database instead. I've
imported the values, and am retrieving them as FOR XML AUTO in the stored
proc to mimic the structure in the web.config. I'm confused now - what data type is being returned by
system.configur ation.configura tionsettings.ge tconfig()? It looks like it has to be an array or xml, but I'm not experienced enough at .NET to determine
how to best handle it. I would like to just provide a different data source and leave the rest of my code the same.

Current code to read web.config:

Public Shared Function SoftwareRequire ments() As
SoftwareRequire mentsView
Return
System.Configur ation.Configura tionSettings.Ge tConfig("softwa reRequirements" ) End Function

<Serializable() > _
Public Class SoftwareRequire mentView
Inherits UserProvisionin gData.SoftwareR equirement

Private _ctrlId As String

Public Sub New(ByVal name As String, ByVal value As String, ByVal prompt As String, ByVal availableTo As String)
MyBase.New(name , value, prompt, availableTo)
End Sub

Public Property ControlId() As String
Get
Return _ctrlId
End Get
Set(ByVal Value As String)
_ctrlId = Value
End Set
End Property

Public ReadOnly Property AdditionalRequi rement(ByVal name As String) As ItemDetail
Get
Dim result As ItemDetail
For Each req As ItemDetail In MyBase.Addition alRequirements
If req.Name = name Then
result = req
Exit For
End If
Next
Return result
End Get
End Property
End Class

I'm attempting to pass data in from SQL instead:

Public Function GetSoftwareConf iguration(ByVal divisionId As Integer,
ByVal brandId As Integer, ByVal operationId As Integer, ByVal branchId As
Integer) As ArrayList
Dim methodPerf As New FNF.Services.Co mmon.PerfAutoTr ace
Dim result As ArrayList =
DBCommon.GetDat aArray(GetType( UserProvisionin gData.SoftwareR equirement),
DBCommon.Connec tionString("myD B"), "get_SoftwareCo nfig", New Object()
{divisionId, brandId, operationId, branchId})
methodPerf.Disp ose()
Return result
End Function

Public Shared Function GetDataArray(By Val returnType As Type, ByVal
connectionStrin g As String, ByVal storedProcName As String, Optional ByVal
params() As Object = Nothing) As Object
Dim reader As SqlDataReader
Dim result As New ArrayList

Try
reader = SqlHelper.Execu teReader(connec tionString,
storedProcName, params)

While (reader.Read)
Dim item As Object = returnType.Invo keMember("New",
Reflection.Bind ingFlags.Create Instance, Nothing, Nothing, New Object()
{reader})
result.Add(item )
End While
Catch ex As FNFException
Throw
Catch ex As Exception
Dim newEx As New FNFException("E rror getting data from
database", New Object() {connectionStri ng, storedProcName} , ex)
ExceptionManage r.Publish(newEx )
Throw newEx
Finally
If Not (reader Is Nothing) Then reader.Close()
End Try

Return result
End Function

Public Shared Function getFromSQLInste adOfWebConfigTe st() As Object
Dim data As UserProvisionin gData.DataReque st
Return data.GetSoftwar eConfiguration( 1, 1, 1, 1)
End Function

When I try to load the page I get an exception when calling my

Dim softReqView As Object =
SoftwareRequire mentsConfigSect ion.SoftwareReq uirements 'calling the
web.config & works great.
Dim softReqViewFrom SQL As Object =
SoftwareRequire mentsConfigSect ion.getFromSQLI nsteadOfWebConf igTest 'calling sql and throws exception

Exception is:
Exception Type: System.NullRefe renceException
Message: Object reference not set to an instance of an object.

Any help would be appreciated.

Thanks,

Brent

[brent]

Okay - now I know why it wasn't working! Thanks Peter.
"Peter Rilling" <pe***@nospam.r illing.net> wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l...

You cannot because the framework itself loads the config when the app
domain
starts. You cannot load it from a different location.

The object returned by GetConfig is dependent on the configuration handler
that is parsing the web.config XML. The reason for GetConfig is that you
can have an arbitrary XML structure in the config file that gets processed
and wrapped by some handler. That is why GetConfig returns an Object
type.

"brent" <br***@newsgrou p.nospam> wrote in message
news:u6******** ******@TK2MSFTN GP10.phx.gbl...

Currently our application is reading from the web.config, and retrieves a
section, "softwareRequir ements". Because the section will begin to grow
dramatically, I'd like to place it in the SQL database instead. I've
imported the values, and am retrieving them as FOR XML AUTO in the stored
proc to mimic the structure in the web.config. I'm confused now - what

data

type is being returned by
system.configur ation.configura tionsettings.ge tconfig()? It looks like it

has

to be an array or xml, but I'm not experienced enough at .NET to
determine
how to best handle it. I would like to just provide a different data

source

and leave the rest of my code the same.

Current code to read web.config:

Public Shared Function SoftwareRequire ments() As
SoftwareRequire mentsView
Return

System.Configur ation.Configura tionSettings.Ge tConfig("softwa reRequirements" )

End Function

<Serializable() > _
Public Class SoftwareRequire mentView
Inherits UserProvisionin gData.SoftwareR equirement

Private _ctrlId As String

Public Sub New(ByVal name As String, ByVal value As String, ByVal

prompt

As String, ByVal availableTo As String)
MyBase.New(name , value, prompt, availableTo)
End Sub

Public Property ControlId() As String
Get
Return _ctrlId
End Get
Set(ByVal Value As String)
_ctrlId = Value
End Set
End Property

Public ReadOnly Property AdditionalRequi rement(ByVal name As String)

As

ItemDetail
Get
Dim result As ItemDetail
For Each req As ItemDetail In MyBase.Addition alRequirements
If req.Name = name Then
result = req
Exit For
End If
Next
Return result
End Get
End Property
End Class

I'm attempting to pass data in from SQL instead:

Public Function GetSoftwareConf iguration(ByVal divisionId As Integer,
ByVal brandId As Integer, ByVal operationId As Integer, ByVal branchId As
Integer) As ArrayList
Dim methodPerf As New FNF.Services.Co mmon.PerfAutoTr ace
Dim result As ArrayList =
DBCommon.GetDat aArray(GetType( UserProvisionin gData.SoftwareR equirement),
DBCommon.Connec tionString("myD B"), "get_SoftwareCo nfig", New Object()
{divisionId, brandId, operationId, branchId})
methodPerf.Disp ose()
Return result
End Function

Public Shared Function GetDataArray(By Val returnType As Type, ByVal
connectionStrin g As String, ByVal storedProcName As String, Optional
ByVal
params() As Object = Nothing) As Object
Dim reader As SqlDataReader
Dim result As New ArrayList

Try
reader = SqlHelper.Execu teReader(connec tionString,
storedProcName, params)

While (reader.Read)
Dim item As Object = returnType.Invo keMember("New",
Reflection.Bind ingFlags.Create Instance, Nothing, Nothing, New Object()
{reader})
result.Add(item )
End While
Catch ex As FNFException
Throw
Catch ex As Exception
Dim newEx As New FNFException("E rror getting data from
database", New Object() {connectionStri ng, storedProcName} , ex)
ExceptionManage r.Publish(newEx )
Throw newEx
Finally
If Not (reader Is Nothing) Then reader.Close()
End Try

Return result
End Function

Public Shared Function getFromSQLInste adOfWebConfigTe st() As Object
Dim data As UserProvisionin gData.DataReque st
Return data.GetSoftwar eConfiguration( 1, 1, 1, 1)
End Function

When I try to load the page I get an exception when calling my

Dim softReqView As Object =
SoftwareRequire mentsConfigSect ion.SoftwareReq uirements 'calling the
web.config & works great.
Dim softReqViewFrom SQL As Object =
SoftwareRequire mentsConfigSect ion.getFromSQLI nsteadOfWebConf igTest

'calling

sql and throws exception

Exception is:
Exception Type: System.NullRefe renceException
Message: Object reference not set to an instance of an object.

Any help would be appreciated.

Thanks,

Brent

[Kevin Spencer]

If you're reading a set of name=value pairs from a database, why does it
have to be XML? Create a table, put 2 columns in it, one for name, and one
for value. Pull the table, and use the records in it. No need for XML.

A configuration file is, by definition, an XML file. This is the way these
files were created. However, all they do is store data, just like a
database. An XML file is a good database, but unless you need to translate
the data into some form of cross-platform-compatible data source (like XML)
there's no need to use XML IN your database.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"brent" <br***@newsgrou p.nospam> wrote in message
news:u6******** ******@TK2MSFTN GP10.phx.gbl...

Currently our application is reading from the web.config, and retrieves a
section, "softwareRequir ements". Because the section will begin to grow
dramatically, I'd like to place it in the SQL database instead. I've
imported the values, and am retrieving them as FOR XML AUTO in the stored
proc to mimic the structure in the web.config. I'm confused now - what
data type is being returned by
system.configur ation.configura tionsettings.ge tconfig()? It looks like it
has to be an array or xml, but I'm not experienced enough at .NET to
determine how to best handle it. I would like to just provide a different
data source and leave the rest of my code the same.

Current code to read web.config:

Public Shared Function SoftwareRequire ments() As
SoftwareRequire mentsView
Return
System.Configur ation.Configura tionSettings.Ge tConfig("softwa reRequirements" )
End Function

<Serializable() > _
Public Class SoftwareRequire mentView
Inherits UserProvisionin gData.SoftwareR equirement

Private _ctrlId As String

Public Sub New(ByVal name As String, ByVal value As String, ByVal
prompt As String, ByVal availableTo As String)
MyBase.New(name , value, prompt, availableTo)
End Sub

Public Property ControlId() As String
Get
Return _ctrlId
End Get
Set(ByVal Value As String)
_ctrlId = Value
End Set
End Property

Public ReadOnly Property AdditionalRequi rement(ByVal name As String) As
ItemDetail
Get
Dim result As ItemDetail
For Each req As ItemDetail In MyBase.Addition alRequirements
If req.Name = name Then
result = req
Exit For
End If
Next
Return result
End Get
End Property
End Class

I'm attempting to pass data in from SQL instead:

Public Function GetSoftwareConf iguration(ByVal divisionId As Integer,
ByVal brandId As Integer, ByVal operationId As Integer, ByVal branchId As
Integer) As ArrayList
Dim methodPerf As New FNF.Services.Co mmon.PerfAutoTr ace
Dim result As ArrayList =
DBCommon.GetDat aArray(GetType( UserProvisionin gData.SoftwareR equirement),
DBCommon.Connec tionString("myD B"), "get_SoftwareCo nfig", New Object()
{divisionId, brandId, operationId, branchId})
methodPerf.Disp ose()
Return result
End Function

Public Shared Function GetDataArray(By Val returnType As Type, ByVal
connectionStrin g As String, ByVal storedProcName As String, Optional ByVal
params() As Object = Nothing) As Object
Dim reader As SqlDataReader
Dim result As New ArrayList

Try
reader = SqlHelper.Execu teReader(connec tionString,
storedProcName, params)

While (reader.Read)
Dim item As Object = returnType.Invo keMember("New",
Reflection.Bind ingFlags.Create Instance, Nothing, Nothing, New Object()
{reader})
result.Add(item )
End While
Catch ex As FNFException
Throw
Catch ex As Exception
Dim newEx As New FNFException("E rror getting data from
database", New Object() {connectionStri ng, storedProcName} , ex)
ExceptionManage r.Publish(newEx )
Throw newEx
Finally
If Not (reader Is Nothing) Then reader.Close()
End Try

Return result
End Function

Public Shared Function getFromSQLInste adOfWebConfigTe st() As Object
Dim data As UserProvisionin gData.DataReque st
Return data.GetSoftwar eConfiguration( 1, 1, 1, 1)
End Function

When I try to load the page I get an exception when calling my

Dim softReqView As Object =
SoftwareRequire mentsConfigSect ion.SoftwareReq uirements 'calling the
web.config & works great.
Dim softReqViewFrom SQL As Object =
SoftwareRequire mentsConfigSect ion.getFromSQLI nsteadOfWebConf igTest
'calling sql and throws exception

Exception is:
Exception Type: System.NullRefe renceException
Message: Object reference not set to an instance of an object.

Any help would be appreciated.

Thanks,

Brent

[brent]

It does. Thanks, Kevin.

"Kevin Spencer" <ke***@DIESPAMM ERSDIEtakempis. com> wrote in message
news:eg******** ******@TK2MSFTN GP14.phx.gbl...

If you're reading a set of name=value pairs from a database, why does it
have to be XML? Create a table, put 2 columns in it, one for name, and one
for value. Pull the table, and use the records in it. No need for XML.

A configuration file is, by definition, an XML file. This is the way these
files were created. However, all they do is store data, just like a
database. An XML file is a good database, but unless you need to translate
the data into some form of cross-platform-compatible data source (like
XML) there's no need to use XML IN your database.

--
HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Neither a follower nor a lender be.

"brent" <br***@newsgrou p.nospam> wrote in message
news:u6******** ******@TK2MSFTN GP10.phx.gbl...

Currently our application is reading from the web.config, and retrieves a
section, "softwareRequir ements". Because the section will begin to grow
dramatically, I'd like to place it in the SQL database instead. I've
imported the values, and am retrieving them as FOR XML AUTO in the stored
proc to mimic the structure in the web.config. I'm confused now - what
data type is being returned by
system.configur ation.configura tionsettings.ge tconfig()? It looks like it
has to be an array or xml, but I'm not experienced enough at .NET to
determine how to best handle it. I would like to just provide a
different data source and leave the rest of my code the same.

Current code to read web.config:

Public Shared Function SoftwareRequire ments() As
SoftwareRequire mentsView
Return
System.Configur ation.Configura tionSettings.Ge tConfig("softwa reRequirements" )
End Function

<Serializable() > _
Public Class SoftwareRequire mentView
Inherits UserProvisionin gData.SoftwareR equirement

Private _ctrlId As String

Public Sub New(ByVal name As String, ByVal value As String, ByVal
prompt As String, ByVal availableTo As String)
MyBase.New(name , value, prompt, availableTo)
End Sub

Public Property ControlId() As String
Get
Return _ctrlId
End Get
Set(ByVal Value As String)
_ctrlId = Value
End Set
End Property

Public ReadOnly Property AdditionalRequi rement(ByVal name As String)
As ItemDetail
Get
Dim result As ItemDetail
For Each req As ItemDetail In MyBase.Addition alRequirements
If req.Name = name Then
result = req
Exit For
End If
Next
Return result
End Get
End Property
End Class

I'm attempting to pass data in from SQL instead:

Public Function GetSoftwareConf iguration(ByVal divisionId As Integer,
ByVal brandId As Integer, ByVal operationId As Integer, ByVal branchId As
Integer) As ArrayList
Dim methodPerf As New FNF.Services.Co mmon.PerfAutoTr ace
Dim result As ArrayList =
DBCommon.GetDat aArray(GetType( UserProvisionin gData.SoftwareR equirement),
DBCommon.Connec tionString("myD B"), "get_SoftwareCo nfig", New Object()
{divisionId, brandId, operationId, branchId})
methodPerf.Disp ose()
Return result
End Function

Public Shared Function GetDataArray(By Val returnType As Type, ByVal
connectionStrin g As String, ByVal storedProcName As String, Optional
ByVal params() As Object = Nothing) As Object
Dim reader As SqlDataReader
Dim result As New ArrayList

Try
reader = SqlHelper.Execu teReader(connec tionString,
storedProcName, params)

While (reader.Read)
Dim item As Object = returnType.Invo keMember("New",
Reflection.Bind ingFlags.Create Instance, Nothing, Nothing, New Object()
{reader})
result.Add(item )
End While
Catch ex As FNFException
Throw
Catch ex As Exception
Dim newEx As New FNFException("E rror getting data from
database", New Object() {connectionStri ng, storedProcName} , ex)
ExceptionManage r.Publish(newEx )
Throw newEx
Finally
If Not (reader Is Nothing) Then reader.Close()
End Try

Return result
End Function

Public Shared Function getFromSQLInste adOfWebConfigTe st() As Object
Dim data As UserProvisionin gData.DataReque st
Return data.GetSoftwar eConfiguration( 1, 1, 1, 1)
End Function

When I try to load the page I get an exception when calling my

Dim softReqView As Object =
SoftwareRequire mentsConfigSect ion.SoftwareReq uirements 'calling the
web.config & works great.
Dim softReqViewFrom SQL As Object =
SoftwareRequire mentsConfigSect ion.getFromSQLI nsteadOfWebConf igTest
'calling sql and throws exception

Exception is:
Exception Type: System.NullRefe renceException
Message: Object reference not set to an instance of an object.

Any help would be appreciated.

Thanks,

Brent