Encrypt Connections Strings While Also Making Them Editable (using Enterprise Library)?
Jul 28, 2009
we are using the Enterprise Library data access application block in our data layer for an application. We must be doing something wrong though because we cannot seem to get encryption and the ability to reconfigure connection strings working well. For example, when the application starts, it checks if the connection strings are "Protected", and if they are not, we encrypt them using the following function:
[Code]...
Then comes another issue. If a user installs an update for the application, the first time it runs, nothing can connect if the config file was previously encrypted. A restart of the application (second time running) will fix the issue. with all of the battles we are fighting here, I wanted to ask if we are doing this right? How should we be encrypting and allowing updates. If you need to see the exceptions thrown, I can provide those upon request (will need to change some code to get them again, but it is doable).
Our app allows admins to connect to a different database, which means we need to temporarily decrypt the app.config's connection strings, re-write them, then re-encrypt it. Here's my current 'simplified' code showing how we do all 3 tasks:
Dim config As Configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None) Dim section As ConfigurationSection = config.GetSection("connectionStrings")
In my shop we currently develop what I would consider small to medium sized projects.We have been investigating the Enterprise Library and how it may be able to help us in development.I have particularly been looking at the Logging block and comparing it with Log4Net.It seems to me that the Enterprise Library blocks would be an extremely over-engineered solution for something like simple application logging.That being said. Are you using the Enterprise Library and on what size projects? What are your thoughts on the Enterprise Library as a whole?
I just got finished watching a short video on logging using some of the built in concepts in Visual Studio 2005. This seems to do a good job. My question is why do people look for other solutions to logging such as Enterprise Library or Log4Net when there is a simple solution out of the box?
The video I watched primarily used the following for logging.
I'm trying to use the Enterprise Library RangeValidator attribute to validate that a decimal value is greater than zero:
<RangeValidator(GetType(Decimal), "0.00", RangeBoundaryType.Exclusive, "1", RangeBoundaryType.Ignore, "MyMessage", "", Nothing, False, "", "")> _ Public Property Holding() As Decimal
[Code]....
As far as I can see I am using the overload correctly. It works fine if I remove the messageTemplate related parameters but I want to be able to specify a custom message.
how to use the Enterprise Library 5 connecting to a MS Access database using VB.NET 2010 on a windows forms application. Looking for quick code samples on how to add, select, update, delete records from an Access database.I'm trying to adopt Enterprise Library in my applications but I'm not finding much information on it.
i'm trying to debug an application i'm currently developing but somehow i'm now getting the following exception The type initializer for 'SupervisorProducao.MdlConstantes' threw an exception. the exception occurs when i reach this
I'm getting a design time NullReferenceException on Dim db As Database = DatabaseFactory.CreateDatabase()and I can't figure out what to do about it. Has anyone experienced this problem or know the solution?
I have a form that when a user clicks on a button that it opens a new window with a dataset. Is it possible to be able to edit that dataset and have messagebox.shows along with that for approval?
I have a ComboBox that is databound to an ObservableCollection of strings. The ComboBox is also editable, so you can either enter in your own value or select one from the list. The issue I'm running into is the index of SelectedItem seems to be the index of the last item you selected when you've entered in your own value in the ComboBox, though it's -1 when you have IsTextSearchEnabled set to true. The problem is, if someone entered their own value and then decide to instead select the item on the ComboBox that had been selected before, the index doesn't change so the SelectionChange event doesn't fire. How could I get an event to fire in this situation?
I am coding this app on my home pc, but when complete it will be run on individual pc(s) (each pc has it oun HD) on a local network. I have a world of questions but right now how do I set the path to my database? is there a way to set a default if its not found.Database(s) that the app use's are stored in a folder on the server. i.e.: P:MyServerNameDeptFolderData for example.OLEDB or TableAdapters which would be the better choice.I understand that MS Access DB is rather resticting.
I'm attempting to create a little library to encrypt and decrypt Files with AES. There are loads of examples of how to do this on the internet so coding is not a problem. There are however a few questions regarding cryptography and AES in general.
#1 Does the IV need to be kept a secret like the key ? #2 Can I just hash a string with SHA512 to make a key for AES ? or do I need to use PasswordDeriveBytes ? #3 In the case of me using PasswordDeriveBytes Do I need to keep the salt a secret ?(or do I need to keep it at all) #4 Can I generate the IV from the same password that the Key is derived from ?(if so How ?)
making a general functions class library that will be used in several applications and asp pages, sometimes running at the same time.I've looked at a lot of samples on the web and they all show you to create an instance of the classlibrary namespace or the classlibrary class.
IE. dim obj2 as new mycompany.mynamespace.myclass dim n2 as integer n2 = obj2.somefunction(...)
What I did was create my class library and put a class in it and declared a function as sharred, then created my dll.I don't have to create an instance of it and I can use it like the net framework by just coding
The net framework does this, I mean once I imports it I don't have to make an instance of it in every function.All the samples I've seen about class libraries do not use the shared keyword.
Using VB.Net and SQL Server 2008 R2: I have recently had a database that using sp_who2 reflects a connection ".Net SqlClient Data Provider" is still active even though the .Net application has closed and disposed of all connections.
What the Win32 API is? I have looked around but no where really outlines what it is. Is it basically a set of procedures, outlined by Microsoft for programmers in order to get services from the operating system? In essence is it the equivalent to making system calls abd and library calls in UNIX? And yes I now Windows makes library calls too.
Say I have a List(Of Tag) with Tag being an object. One member of Tag, Tag.Description, is a string, and I want to make a comma-separated concatenation of the Description members.Is there an easier way to do this than to read the Description members into a List(Of String) and then use the Join function?
I have a Visual Basic Class Library project. It generates a DLL. Is there a method to generate a static .LIB to which I can do a static link?Alternatively, can I do a static link against a DLL?
I want to create an enterprise wide dataset so that my function will call this same dataset from any of the webpage. I've created shared code in the App_Code folder. In it, there's are dataset properties. Will the pages extract info from these dataset properties each time I call the shared program or will create new property for each page.I'm trying to emulate an Enterprise Java Bean type of coding.
This is a Visual Studio forum but can you help me regarding Visual Basic 6.0 Enterprise Edition? I cannot find the CRYSTL32.exe in Visual basic 6.0 Enterpise Edition installation cd. I already some articles and it says that i can find it through this path CommonToolsVBCrysReptCrystl32.exe I alre cd.I saw in my installation cd this path (when I open the cd) Common/Tools... and there is no VBCrysReptCrystl32.exe VBCrysRept so that i can run the Crystl32.exe? I'll be needing it for my programming project which has Official Receipt issuance and somebody told me that i can use crystal report for pie Chart. Is that true that I can use Crystal report for pie Chart? Please also help me to find tutorial regarding crystal report. I am using Visual basic 6.0.
include sql enterprise in setup project?how to include sql enterprise when it's not appear in prerequisites of the setup projectand if it's not possible do i have install the full enterprise edition on the client machine?i use visual studio 2010 and sql enterprise 2008.i'm a database beginner and i always used to use sql express edition but now data base getting grow fast and the limitations of the sql express for 4gb make
