Contents tagged with SQL Server
-
C# MVC3 Razor Entity Framework & LINQ Custom Membership Provider with Custom Role Provider
This C# project demonstrates how to create an MVC3 Razor Entity Framework & LINQ Custom Membership Provider with Custom Role Provider. Perhaps you are working with a legacy database or you prefer working with a database that uses numeric identity keys instead of Guids. The example UserProfile table in this project uses an integer UserId as the primary key and various other fields that aren't in the default ASP.NET User table. Use the Log On Link in the project and the Register link to create your own account.
-
SQL Server Express and VS2010 Web Application .MDF file errors
I installed SQL Server 2008 as well as SQL Server Express 2008 on my new Windows 7 development environment, along with Visual Studio 2010. I could get SQL Server 2008 to work fine, but I could not use Express .MDF databases within sample web application projects without receiving the below error:
-
Adding a SQL Server Membership Provider using the aspnet_regsql.exe Utility
You may add a SQL Server Membership Provider using the aspnet_regsql.exe Utility on either your SQL Server Express local database or on a full-blown SQL Server database. In both implementations, you would use the aspnet_regsql.exe utility. This tool is installed when you install your .NET Framework. To use this on your SQL Server 2008 database server, for instance, you would need to first download and install the .NET Framework onto your server.
-
.NET Framework 4 Custom ODBC Membership Provider Implementation in C# and VB.NET
Here is a great link to .NET Framework 4 Custom ODBC Membership Provider Implementation and Sample Membership Provider Implementation. Source code is in both C# and VB.NET.
-
PLINQO LINQ to SQL and nHibernate ORM Code Generators
In my quest for the perfect Object Relational Mapper (ORM) for a major upcoming project utilizing SQL Server 2008, I was torn between using LINQ to SQL versus nHibernate.
-
Fix for Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Are you getting this error? Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
-
Filtering Parameters in a SQL 2008 Stored Procedure
Ash explains the concept of Filtering Parameters in a Stored Procedure in this blog post.
-
SQL Server 2008 Web Edition and Express Edition Errors Resolved
Since I had purchased the SQL Server 2008 Web Edition for my database server, I decided to also install it on my development box. But when I tried to install the Management Tools, it errored with:
-
SQL Server: Copying a Database, including Constraints, Keys, Indexes...
In SQL Server, if you wish to copy the structure of an entire database, including the Constraints, Keys, Indexes, etc., don't use the Import option, as it does not include the constraints, keys, indexes, etc. Instead, within SQL Server Management Studio, right click a database, select Tasks, then "Generate Scripts."
-
Membership Provider Connections to remote database in IIS7 Windows 2008 Web Server
I recently went through a nightmare with getting the Membership Provider Login and any other Membership Provider methods to work using Windows 2008 Web Server and IIS7 connecting to a remote SQL Server 2008 database.