No Primary Key Defined adding a View to Entity Framework

4. October 2014 patrick (0)
The solution (if you want to call it that) to fix the issue "does not have primary key defined" when adding views to Entity Framework was posted on this link at StackOverflow. These annoyances in EF are having me look at nHibernate. 
  
SELECT
  ISNULL(MyPrimaryID,-999) MyPrimaryID,
  NULLIF(AnotherProperty,'') AnotherProperty
  FROM ( ... ) AS temp

jQuery Sticky Footer

18. August 2014 patrick (0)
The footer shown on the screen shot below will remain at the bottom of the page even if you re-size the page.

This is great if your site has a content area that is not that tall, and the site is displayed on a large monitor. This way the footer will be pushed to the bottom of the screen.  If content exceeds the screen height it will push the footer off the screen. A little tweak with jQuery to make the context dive scroll if you want the footer to be truly "sticky."

Open the example below in a new window. 

        function ResizeContent() {
            
            //Height of the available content area is  Page Height - (Header and Footer height. 
            //In this case 100px;
            var ContentHeight = Math.round($(window).height() - 100);
            ContentHeight = ContentHeight + "px";

            $("#MainContainer").css("min-height", ContentHeight);
        };


        $(function () {
            //Resize the content after page load or resize
             ResizeContent();

            window.onresize = function () {
                    ResizeContent();
              };
         });

ASP.NET Web Site Administration Tool

22. June 2014 patrick (0)

The ASP.NET Web Site Administration Tool / Membership Provider which is used along with the SQL Server Membership Database, is no longer available in VS 2013 because the Cassini web server is no longer supported. You can either get the Web Site Admin Tool up and running using a command window or set it up in IIS.  This post covers both cases (I prefer to use IIS vs. Command Window).

Other Tools: If you looking for a tool to manage users with ASP.NET Entity take a look at ASP.NET Membership Reboot.  At this link is another approach using Identity Manager and discusses Membership Reboot as well. 
 

 
1. Launch the Web Site Admin Tool using a command window:
  • Open a Command Window running it as a Admin
  • Change the folder to IIS Express cd C:\Program Files\IIS Express\
  • Run the following command to start up IIS Express
    • iisexpress.exe /path:C:\Windows\Microsoft.NET\Framework\v4.0.30319\ASP.NETWebAdminFiles /vpath:"/ASP.NETWebAdminFiles" /port:8082 /clr:4.0 /ntlm
  • Access the Admin Site via the following URL:
    • http://localhost:8082/asp.netwebadminfiles/default.aspx?applicationPhysicalPath=C:\[YOUR SITE PATH HERE]\&applicationUrl=/ 
 
2. Launch the Web Site Admin Tool using IIS:  You can try running the site from the Windows folder but after a couple of issues I just moved it to another folder.  The steps below cover that process.
  • Copy the Admin Site from the following folder: C:\Windows\Microsoft.NET\Framework\v4.0.30319\ASP.NETWebAdminFiles
  • Change the web.config to allow any user to access the site  <allow users="?" />
  • Setup the site in IIS. Set the Authentication as shown below.  Use the following URL to manage your ASP.NET site. 
  • http://localhost/ASPNetAdmin/default.aspx?applicationPhysicalPath=C:[YOUR SITE PATH HERE]\&applicationUrl=/