More control over ConnectionManager


Author
Message
Edhy Rijo
E
StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Greg McGuffey (03/06/2009)
Wow, I didn't know that. That's very cool. BigGrin

Also a quick look at the dbeApplicationdData.vb will reveal all code needed to handle the XML file for things like the Server Settings for the Server Console application. w00t

Thanks Trent Hehe

Edhy Rijo

Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.3K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
Wow, I didn't know that. That's very cool. BigGrin
Trent Taylor
Trent Taylor
StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Well, you can talk to these files the same way that we do.  In the UI assembly there are two BOs that talk directly to the applicationkeys.dat and connection.dat files.  They wrap the encryption, etc.  So you could just create an instance of each to manipulate these files. 

Dim app As New DbeApplicationData()
Dim connections As New DbeConnectionData()
'-- Retrieve the application key record to which the connections are tied
app.FillWithActiveKey("MyApplicationKey")

If app.Count > 0 Then
    '-- Retrieve the connections
    connections.FillAll(app.app_pk)

    '-- At this point it is a BO...so you can add, remove, just like you would with any other BO

    '-- When ready to save, Call the SaveToXML method
    connections.SaveToXML()
End If


Leonard P.
Leonard P.
StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)
Group: Awaiting Activation
Posts: 65, Visits: 306
Alex Luyando (03/04/2009)



If the user is running multiple StrataFrame applications with different data sources this could be problematic, no?




That's a very good point Alex! Deleting connection.dat file just wiped out StrataFrame connection info on my dev machine. So, I had to reentered it again on VS .NET startup Wink
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.3K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
The connection strings don't get loaded into the connection store (connections.dat) when they are set directly via the DataLayer.DataSources.Add() method. They shouldn't need to as it sounds like the connection strings are known by the various assemblies.



Also, a little background. The ConnectionManager is really just a UI that allows the user to enter information that gets built into a connection string and then can store that connection string someplace (connections.dat) were it can be reused. The connections strings are stored by key, actually allowing multiple connections per type (so multiple apps can use the same file...so yes, deleting this file for one app would also delete the connections for other apps too, thus the user would have to reenter the connection info for those other apps). Check out ConnectionManager.ShowAvailableConnectionStrings().



The ConnectionManager then just uses the info to build the connection string and then add the data source using the exact same method you'd use to do it yourself (DataLayer.DataSources.Add()).



So, if your connection strings come from some place else, no need for ConnectionManager. It's job is to manage connection strings entered by the user...that's all. Here are some possible sources for the connection string:



- ConnectionManager prompts user for info, then uses the stored info next time the app opens.

- Connection string is set directly via DataSources.Add()

- Connection string is saved in a constant

- Connection string is retrieved via a property of a class

- Connection string is retrieved via a method of a class

- Connection string is retrieved form the App.Config file

- Connection string is retrieved from an XML file created using XmlBasics (SF tool)

- Connection string is retrieved from a Windows service, via TCP

- Connection string is retrieved from a web service

- etc.



In all cases, the connection string and a key are used to create the data source using DataLayer.DataSources.Add("key", "connection string").



I'm guessing that you would just use the connection manager to handle a limited number of connections and then get the other connection strings via method calls in the various assemblies.



You can allow the user to manage connections, by calling the ConnectionManager.ShowAvailableConnectionStrings(). They can add/remove connections as needed. I don't think there is a programmatic way to remove a connection though (and it would be hard, as the user actually can provide a name for the connection, which you wouldn't know).



Hope that helps! BigGrin
Alex Luyando
Alex Luyando
StrataFrame User (208 reputation)StrataFrame User (208 reputation)StrataFrame User (208 reputation)StrataFrame User (208 reputation)StrataFrame User (208 reputation)StrataFrame User (208 reputation)StrataFrame User (208 reputation)StrataFrame User (208 reputation)StrataFrame User (208 reputation)
Group: StrataFrame Users
Posts: 112, Visits: 1.2K
Trent L. Taylor (03/04/2009)
This will work fine. They should already have permissions to this folder location anyway, so this should not be an issue.




Trent -



If the user is running multiple StrataFrame applications with different data sources this could be problematic, no?

________________
_____/ Regards,
____/ al
Leonard P.
Leonard P.
StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)
Group: Awaiting Activation
Posts: 65, Visits: 306
' In SetDataSources, in AppMain.vb (program.cs)...

Microfour.Strataframe.Data.DataLayer.DataSources.Add(New SqlDataSourceItem("key","Data Source=myserver...")






That make sense?







Yes, but from what I've seen (and I could've been doing something wrong) adding new datasource does not persist connection string to the connection store.

Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.3K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
The simple answer is no, ConnectionManager requires user interaction. Once the information is collected, it is placed in an encrypted XML file (connections.dat). You might be able to pull this off...but you don't want to, there is a better way that isn't hard.



For those connections that are not user configurable, just setup the datasources directly, via code:



' In SetDataSources, in AppMain.vb (program.cs)...

Microfour.Strataframe.Data.DataLayer.DataSources.Add(New SqlDataSourceItem("key","Data Source=myserver...")




You'd add a data source for every one you need. Likely, you'd reference the appropriate method in the assembly to get its connection string. The "key" is then set on the BO so it knows were to get the data.



That make sense?



Leonard P.
Leonard P.
StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)StrataFrame Novice (79 reputation)
Group: Awaiting Activation
Posts: 65, Visits: 306
Hi Trent, Thanks for Replying,



Could you comment on the second part:



Second, is there a way to write a new connection string to Connection.bat without calling .SetConnection or .ShowAvailableConnectionsWizard (i.e. without user interaction), my FS application reference other assemblies that manager their own connection strings, and I wont to be able to store them in ConnectionManager.




Thanks
Trent Taylor
Trent Taylor
StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)StrataFrame Developer (9.8K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
This will work fine.  They should already have permissions to this folder location anyway, so this should not be an issue.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search