If you are looking for free online tutorials to learn ASP.NET MVC 3 basics then you should check out ASP.NET MVC site. Microsoft has made arrangements with Pluralsight to provide many on-demand videos free of charge.
Link: ASP.NET MVC
8. Leveraging the ASP.NET Runtime
10. Deployment & Configuration
If you hate that slight flicker in IE browser between page transitions then you will find this snippet useful.
When user navigate from one page to another in IE, there is slight “white out” before this transition. Whereas in Firefox and other browsers this page transition is very smooth. IE browser will show blank page for very short duration before showing content of next page. User experience this effect more like flicker on the browser. If your web application has more post backs then it become more annoying to users.
To reduce this flicker in IE, simple add below META tags in HEAD section of your page.
<META http-equiv="Page-Enter" content="blendTrans(Duration=0.05)" /> <META http-equiv="Page-Exit" content="blendTrans(Duration=0.05)" />
By reducing the duration between fading previous content and revealing new content, user experience relatively smooth transition between pages.
This snippet has only impact on IE and not on other browsers.
Here is small javascript snippet you will find useful for your web application. It will automatically logout user after specific time of inactivity.
<script type="text/javascript"> var timer; var wait=10; document.onkeypress=resetTimer; document.onmousemove=resetTimer; function resetTimer() { clearTimeout(timer); timer=setTimeout("logout()", 60000*wait); } function logout() { window.location.href='Logout.aspx'; } </script>
Code is self explanatory. We are using setTimeout method which will call a function (logout function in above case) after specified delay in milliseconds. With that, we also resetting that again and again for every user movement on page.
You just need to drop this code in all pages (except login and unsecured pages) of your application. Master page is good place instead for easy maintenance.
Before login off user from application, you may also like to alert user first. So let’s extend above code further. This gonna be bit tricky as we cannot use simple javascript alert to show this message. Instead we will create a DIV layer in the page and use it for showing alert message. Any user interaction will hide this alert message. After specific time of inactivity, user will navigate to Logout.aspx page where you can provide actual implementation to logout user and clear all session objects.
Here is modified code:
<html> <head runat="server"> <title>Default Page</title> <script type="text/javascript"> var timer1, timer2; document.onkeypress=resetTimer; document.onmousemove=resetTimer; function resetTimer() { document.getElementById('timeoutPopup').style.display='none'; clearTimeout(timer1); clearTimeout(timer2); // waiting time in minutes var wait=10; // alert user one minute before timer1=setTimeout("alertUser()", (60000*wait)-1); // logout user timer2=setTimeout("logout()", 60000*wait); } function alertUser() { document.getElementById('timeoutPopup').style.display='block'; } function logout() { window.location.href='Logout.aspx'; } </script> <style type="text/css"> #timeoutPopup { display:none; position:absolute; top:0; right:0; bottom:0; left:0; width:30%; height:30%; margin:auto; padding:4px; border:solid 1px #999999; background-color:#dddddd; text-align:center; } </style> </head> <body> <form id="form1" runat="server"> <div id="timeoutPopup"> Your session is about to expire if there is no additional activity. </div> </form> </body> </html>
I just released TinySQL code generator v2.0 with few bug fixes and a new feature of using separator tag for loop statement. You can now use {sap}{/sap} tags to place your separators inside loop.
Here is the example of using {sap}{/sap} tags in TinySQL template:
** Generate DATA Provider: UPDATE/v2.0 CREATE PROCEDURE [dbo].[usp_Update$table]{loop} @$field = $sp_type{sap},{/sap}{/loop} AS BEGIN UPDATE dbo.$table WITH (ROWLOCK) SET {loop}$field = @$field{sap},{/sap} {/loop} WHERE --TODO RETURN -1 END
And generated code from above template will be like:
CREATE PROCEDURE [dbo].[usp_UpdateAction] @Id = NUMERIC, @Action = VARCHAR(250), @ProjectId = NUMERIC, @IsNextAction = BIT, @IsWaitingFor = BIT, @WaitingForNotes = VARCHAR(1000), @RemindOn = DATETIME, @IsDefer = BIT, @DeferDate = DATETIME, @IsDone = BIT, @Sequence = INT AS BEGIN UPDATE dbo.Action WITH (ROWLOCK) SET Id = @Id, Action = @Action, ProjectId = @ProjectId, IsNextAction = @IsNextAction, IsWaitingFor = @IsWaitingFor, WaitingForNotes = @WaitingForNotes, RemindOn = @RemindOn, IsDefer = @IsDefer, DeferDate = @DeferDate, IsDone = @IsDone, Sequence = @Sequence WHERE --TODO RETURN -1 END
Download: TinySQL v2.0
You can also read my previous blog to learn more about TinySQL tool.
TinySQL Code Generator
Hope you will find this tool useful.
TinySQL is small and handy SQL script which can quickly generate consistent code snippet that you can paste in your project. It basically operates by reading schema of provided table and applying template to each column of table in order to generate code snippet.
With TinySQL, you can create complete or specific portion of business class, business service, or data access layer. You can also generate repetitive code snippet like storing all DataReader columns into respective property of business object, or passing all object properties to SqlParameter in data access layer, or creating stored procedures for a table or creating simple update or insert statement in stored procedure etc.
TinySQL is part of my daily development practice. I am using early version of TinySQL for 2 years now and found myself more productive with this tool. I usually keep SQL Management Studio open (like most Microsoft application developers) all the time with a dedicated query pane for TinySQL. Whenever I need to write any repetitive code based on schema of any table, I simply provide table name, tweak template per my requirement and execute the script. I then copy and paste generated code in my project. Yes, I do require making minor changes sometime in generated code to make it usable in my project but still TinySQL serves its purpose.
TinySQL is definitely not a replacement of sophisticated code generation tools like CodeSmith, TierDeveloper, LLBLGen etc. Those tools are very advance and can generate code for whole project including user interface, business layer, data access layers and even store procedures. TinySQL can only generate basic code snippet that you can use in your existing code or project.
Download Link: TinySQL
Implementation of TinySQL is very simple and straight forward. It reads schema definition of all columns of provided table and template; it then render code by rotating loop for each column. Variable you have to take care in TinySQL are:
@TableName: table name for which you want to generate code
@PrintTableName: how above table name should display in generated code. You may have table “tblCategories” but you want “Category” for class name.
@Template: Template for generated code
Open TinySQL in SQL Management Studio, provide table name and template, press F5 to execute TinySQL and you will have generated code in result pane. Now you just have to copy generated code from result pane and paste in your project.
To make customization of template more flexible, I have used few tags as placeholder for rendering respective entity. These tags are:
$table : TABLE name $field : COLUMN Name $type : .NET DATA Type $default : .NET DEFAULT Value $sp_type : SQL DATA Type $length : COLUMN Max Length
{loop} : Start Loop {/loop} : End Loop
Suppose I want to generate snippet which has list of all columns of provided table. So value of TinySQL variables will be:
SET @TableName = 'tblCategory' SET @PrintTableName = 'Category' SET @Template = ' ** generate simple column list /v1.0 $table: {loop}$field, {/loop} '
It will generate code something like this:
Category: Id, LANGUAGE, ParentId, Name, SafeName, RIGHT, LEFT, IsEnabled, DisplayOrder, Color,
Note: first line of template is comment portion which can be used as template description, author, template version, additional comment etc.
You can play with TinySQL to explorer more about this tool.
Ok, so here are some practical examples of templates which explain the basic usage of TinySQL:
1. Listing all fields of provided table.
$table FIELDS: {loop}$field, {/loop}
This template will generate list of field in separate lines.
2. Creating Simple SELECT statement:
SELECT {loop}$field, {/loop} FROM $table
As I mentioned before, you may require minor modification sometime in generated code to use it in your project. Like in above case, you have to manual remove last comma from SELECT.
3. Creating UPDATE statement
UPDATE $table SET {loop}$field = @$field, {/loop}
Again, you require removing last comma from generated code.
4. Creating Update Stored Procedure:
** generate DATA Provider: UPDATE/v1.0 CREATE PROCEDURE [dbo].[usp_Update$table]{loop} @$field = $sp_type,{/loop} AS BEGIN UPDATE dbo.$table WITH (ROWLOCK) SET {loop} $field = @$field,{/loop} WHERE --TODO RETURN -1 END
5. Creating simple insert statement:
** generate simple INSERT statement/v1.0 INSERT INTO $table ({loop}[$field],{/loop} VALUES ({loop}@$field,{/loop}
6. Now, let’s use TinySQL to generate code snippet in C# (or VB.NET) which assign entity values to respective parameters of stored procedure.
** generate DATA Provider: UPDATE FUNCTION/v1.0 SqlDatabase DATABASE = new SqlDatabase(this._connectionString); DbCommand commandWrapper = StoredProcedureProvider.GetCommandWrapper(DATABASE, "dbo.$table_Update", _useStoredProcedure); {loop}DATABASE.AddInParameter(commandWrapper, "@$field", DbType.$type, entity.$field ); {/loop}
7. And as last example, here is template to generate business entity in C#.
** generate basic business entity/v1.0 #region Using Directives using System; using System.ComponentModel; using System.Collections; using System.Xml.Serialization; using System.Runtime.Serialization; #endregion namespace MyNameSpace.Entities { ///<summary> /// An object representation of the "$table" table. ///</summary> [Serializable, DataObject] public class $table { #region Variable Declarations {loop} private $type _$field;{/loop} #endregion Variable Declarations #region Constructors public $table() { {loop}_$field = $default; {/loop} } #endregion #region Properties {loop} public $type $field { get { return this._$field; } set { this._$field = value; } } {/loop} #endregion } }
Like last example, you can even create complete business service or data access layer using TinySQL.
I hope you will find this tool useful. Please do let me know if you found any bug or feature request.
UPDATE:
Please take latest version from TinySQL v2.0
Recent Comments