I’m setting up a very basic demo of SQL Server Session State, but am having some trouble getting it working. I’m trying to test this out locally running Windows 7 with IIS 7.5 and SQL Server 2008 R2.
I am working with an application where we store our client data in separate SQL databases for each client. So far this has worked great, there was even a case where some bad code selected the wrong customer ids from the database and since the only data in the database belonged to that client, the damage was not as bad as it could have been. My concerns are about the number of databases you realistically have on an SQL Server.
I am trying to move all of my references to variables in SQL statements to the SqlParameter class however for some reason this query fails.
I have a general question on whether something can be done – and whether it will be the most efficient way of doing it !
I am currently storing normalized versions of strings in my SQL Server database in lower case. For example, in my Users table, I have a UserName and a LoweredUserName field. Depending on the context, I either use T-SQL’s LOWER() function or C#’s String.ToLower() method to generate the lower case version of the user name to fill the LoweredUserName field. According to Microsoft’s guidelines and Visual Studio’s code analysis rule CA1308, I should be using C#’s String.ToUpperInvariant() instead of ToLower(). According to Microsoft, this is both a performance and globalization issue: converting to upper case is safe, while converting to lower case can cause a loss of information (for example, the Turkish ‘I’ problem).
I’m using PBKDF2 in my application to store users passwords. In my Users table, I have a Salt and Password column which is determined like this:
I’m relatively new to MVC, and I’ve never had to deal with uploading a file (an image, specifically) to a SQL Server database. To be honest, I don’t know what I’m doing here.
I’ve noticed there’s a SignalR.SqlServer class on github.
https://github.com/paigecook/SignalR/tree/master/SignalR.SqlServer
I was wondering how I could get the columns of a database table and store each of them in a string or string array. I have the following code but I believe it does not work. I’m using the default table that is given in asp.net. I’ve been able to write to this table no problem but I cannot figure out how to select from it and save the values retrieved. here is what I have in my code behind
I want to use IIS impersonation to connecto to a SQL server database as the user who is currently accessing a website. This is for auditing and security reasons.