<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5697141498182262636</id><updated>2024-10-24T13:26:24.865-07:00</updated><title type='text'>Development</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>45</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-9157096017811825048</id><published>2013-03-03T02:31:00.000-08:00</published><updated>2013-03-05T20:48:08.014-08:00</updated><title type='text'>AJAX calls using jQuery</title><content type='html'>&lt;br /&gt;
&lt;div style=&quot;background-color: white; font-family: sans-serif, &#39;trebuchet ms&#39;, &#39;lucida grande&#39;, &#39;lucida sans unicode&#39;, arial, helvetica, sans-serif; font-size: 14px;&quot;&gt;
&lt;span style=&quot;font-family: &#39;Times New Roman&#39;; font-size: small;&quot;&gt;For making ajax call with javascript firstly we need to crate XMLHttpRequest object that is browser dependent then can proceed for ajax call. But jquery has made the things simple as well as with powerful&lt;/span&gt;&lt;span style=&quot;font-family: &#39;Times New Roman&#39;; font-size: small;&quot;&gt;&amp;nbsp;.&amp;nbsp;&lt;/span&gt;jQuery provides a rich set of handy methods you can use to Ajaxify your web pages. jQuery provides&amp;nbsp;&lt;strong&gt;wrapper methods&lt;/strong&gt;&amp;nbsp;that shield you from the inner mechanisms of an AJAX request&lt;span style=&quot;background-color: transparent;&quot;&gt;&amp;nbsp;as:&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: transparent;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
1. GET Request method : jQuery.get( url, [data], [callback], [type] )&lt;br /&gt;
2. POST Request method : jQuery.post( url, [data], [callback], [type] )&lt;br /&gt;
3. Get JSON : jQuery.getJSON( url, [data], [callback] )&lt;br /&gt;
4. AJAX Start/End : jQuery.ajaxStart([callback]), jQuery.ajaxComplete([callback])&lt;br /&gt;
5. Serialize html form : serialize(), serializeArray()&lt;br /&gt;
6. jQuery.ajax()&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;1. GET Request method :&lt;/b&gt; Loads a remote page using HTTP GET request method. It allows a single callback function to be specified that will be executed when the request is complete (and only if the response has a successful response code).&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
jQuery.get( url, [data], [callback], [type] )&lt;/div&gt;
&lt;div&gt;
url: (String) The URL of the page to load.&lt;/div&gt;
&lt;div&gt;
data (Optional): (Map) Key/value pairs that will be sent to the server.&lt;/div&gt;
&lt;div&gt;
callback (Optional): (Function) A function to be executed whenever the data is loaded successfully.&lt;/div&gt;
&lt;div&gt;
type (Optional): (String) Type of data to be returned to callback function: “xml”, “html”, “script”, “json”, “jsonp”, or “text”.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;2. POST Request method :&amp;nbsp;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
Sends HTTP Post request.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
jQuery.post( url, [data], [callback], [type] )&lt;/div&gt;
&lt;div&gt;
url: (String) The URL of the page to load.&lt;/div&gt;
&lt;div&gt;
data (Optional): (Map) Key/value pairs that will be sent to the server.&lt;/div&gt;
&lt;div&gt;
callback (Optional): (Function) A function to be executed whenever the data is loaded successfully.&lt;/div&gt;
&lt;div&gt;
type (Optional): (String) Type of data to be returned to callback function: “xml”, “html”, “script”, “json”, “jsonp”, or “text”.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;3. Get JSON :&amp;nbsp;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
JavaScript Object Notation (JSON) is a popular light weight format that can be used to get data from server. JSON format is easy to create from the server and easy to parse at client as it is the basic object representation in JavaScript. Normally the data that we get from AJAX is converted in JSON by calling eval () method of JavaScript. But the function provided by JQuery handles this internally and provides direct JSON object as output.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
jQuery.getJSON( url, [data], [callback] )&lt;/div&gt;
&lt;div&gt;
url: (String) The URL of the page to load.&lt;/div&gt;
&lt;div&gt;
data (Optional): (Map) Key/value pairs that will be sent to the server.&lt;/div&gt;
&lt;div&gt;
callback (Optional): (Function) A function to be executed whenever the data is loaded successfully.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;4. AJAX Start/End :&amp;nbsp;&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 21.59375px;&quot;&gt;While making a sequence of AJAX requests one being dependent on returned data from other request&#39;s response in that case it is good to show a progress bar or image to user so that (s)he knows that something is going on. For such case ajax start/end method used.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 21.59375px;&quot;&gt;ajaxStart() method registers a function handler that will be called by jQuery internally whenever an AJAX call is made. If already a request is active than the handler is not called. We can use this method to register a handler function that will display our progress bar.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 21.59375px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 21.59375px;&quot;&gt;Similarly ajaxComplete() method can be used to register a handler function which gets called by jQuery when an AJAX request get completed and any other active request are not in progress.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;5. Serialize html form :&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;While submitting a form using AJAX, one has to create a input string that contains the value of all the input elements on the screen. It is very difficult to create this string if your form is very big. Hence we can use jQuery’s serialize() and serializeArray() method to do so.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;serialize()&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;Serializes a set of input elements into a string of data. Serialize is typically used to prepare user input data to be posted to a server. The serialized data is in a standard format that is compatible with almost all server side programming languages and frameworks. In order to work properly serialize requires that form fields have a name attribute. Having only an id will not work.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;This value can be sent to server by an AJAX call.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;serializeArray()&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;serializeArray() does the similar job. Except it creates JSON output.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;color: #222222; font-family: Arial, Trebuchet MS, Verdana, Tahoma;&quot;&gt;&lt;span style=&quot;font-size: 15px; line-height: 22px;&quot;&gt;6. jQuery.ajax()&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;background-color: white; font-family: sans-serif, &#39;trebuchet ms&#39;, &#39;lucida grande&#39;, &#39;lucida sans unicode&#39;, arial, helvetica, sans-serif; font-size: 14px;&quot;&gt;
If you need greater flexibility, the full-blown&amp;nbsp;&lt;strong&gt;$.ajax()&lt;/strong&gt;&amp;nbsp;function offers a great number of settings.&lt;/div&gt;
&lt;div style=&quot;background-color: white; font-family: sans-serif, &#39;trebuchet ms&#39;, &#39;lucida grande&#39;, &#39;lucida sans unicode&#39;, arial, helvetica, sans-serif; font-size: 14px;&quot;&gt;
For instance, let&#39;s say you want to retrieve a list of programming languages from the XML document you used in the previous example. You might want to specify the following options:&lt;/div&gt;
&lt;ol style=&quot;background-color: white; font-family: sans-serif, &#39;trebuchet ms&#39;, &#39;lucida grande&#39;, &#39;lucida sans unicode&#39;, arial, helvetica, sans-serif; font-size: 14px;&quot;&gt;
&lt;li style=&quot;padding-top: 0.25em;&quot;&gt;the request must be an&amp;nbsp;&lt;strong&gt;HTTP GET&lt;/strong&gt;;&lt;/li&gt;
&lt;li style=&quot;padding-top: 0.25em;&quot;&gt;the page from which the result is returned&amp;nbsp;&lt;strong&gt;must not be in the browser&#39;s cache&lt;/strong&gt;;&lt;/li&gt;
&lt;li style=&quot;padding-top: 0.25em;&quot;&gt;the response returned by the server&amp;nbsp;&lt;strong&gt;is of data-type XML&lt;/strong&gt;;&lt;/li&gt;
&lt;li style=&quot;padding-top: 0.25em;&quot;&gt;the request&amp;nbsp;&lt;strong&gt;is made in html&lt;/strong&gt;;&lt;/li&gt;
&lt;li style=&quot;padding-top: 0.25em;&quot;&gt;there must be a&amp;nbsp;&lt;strong&gt;function that handles the returned result if all goes well&lt;/strong&gt;;&lt;/li&gt;
&lt;li style=&quot;padding-top: 0.25em;&quot;&gt;and, finally, there must be a&amp;nbsp;&lt;strong&gt;function that handles errors&lt;/strong&gt;&amp;nbsp;in case the request is not successful.&lt;/li&gt;
&lt;/ol&gt;
&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/9157096017811825048/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/9157096017811825048' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/9157096017811825048'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/9157096017811825048'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2013/03/ajax-calls-using-jquery.html' title='AJAX calls using jQuery'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-824968137919524196</id><published>2013-01-08T02:00:00.001-08:00</published><updated>2013-01-08T02:06:48.369-08:00</updated><title type='text'>jQuery - AJAX Events</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;h2 style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Helvetica, Arial, &#39;Liberation Sans&#39;, FreeSans, sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: bold; letter-spacing: normal; line-height: 1.5; margin-bottom: 10px; margin-top: 10px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;&quot;&gt;
Local Events:&lt;/h2&gt;
&lt;div style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: verdana, helvetica, arial, sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;&quot;&gt;
These are callbacks that you can subscribe to within the Ajax&lt;br /&gt;
request object.&lt;/div&gt;
&lt;table cellpadding=&quot;5&quot; cellspacing=&quot;5&quot; class=&quot;src&quot; style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #f1f1f1; border-collapse: collapse; border: 1px solid rgb(170, 170, 170); color: black; font-family: verdana, helvetica, arial, sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; padding-left: 5px; text-align: left; text-indent: 0px; text-transform: none; vertical-align: top; white-space: normal; widows: 2; width: 552px; word-spacing: 0px;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;border-collapse: collapse; border: 1px solid rgb(170, 170, 170); font-family: verdana, helvetica, arial, sans-serif; margin-bottom: 0px; text-align: left; vertical-align: top;&quot;&gt;&lt;pre style=&quot;font-family: &#39;Courier New&#39;, monospace; font-size: 12px; margin-bottom: 0px; margin-left: 0px; margin-top: 0px;&quot;&gt;$.ajax({
   beforeSend: function(){
     // event handling
   },
   complete: function(){
     // event handling
   }
   // ......
 });
&lt;/pre&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;h2 style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Helvetica, Arial, &#39;Liberation Sans&#39;, FreeSans, sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: bold; letter-spacing: normal; line-height: 1.5; margin-bottom: 10px; margin-top: 10px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;&quot;&gt;
Global Events :&lt;/h2&gt;
&lt;div style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: verdana, helvetica, arial, sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;&quot;&gt;
These events are broadcast to all elements in the DOM, triggering any&lt;br /&gt;
handlers which may be listening. You can listen for these events like so:&lt;/div&gt;
&lt;table cellpadding=&quot;5&quot; cellspacing=&quot;5&quot; class=&quot;src&quot; style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #f1f1f1; border-collapse: collapse; border: 1px solid rgb(170, 170, 170); color: black; font-family: verdana, helvetica, arial, sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; padding-left: 5px; text-align: left; text-indent: 0px; text-transform: none; vertical-align: top; white-space: normal; widows: 2; width: 552px; word-spacing: 0px;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;border-collapse: collapse; border: 1px solid rgb(170, 170, 170); font-family: verdana, helvetica, arial, sans-serif; margin-bottom: 0px; text-align: left; vertical-align: top;&quot;&gt;&lt;pre style=&quot;font-family: &#39;Courier New&#39;, monospace; font-size: 12px; margin-bottom: 0px; margin-left: 0px; margin-top: 0px;&quot;&gt;$(&quot;#loading&quot;).bind(&quot;ajaxSend&quot;, function(){
   $(this).show();
 }).bind(&quot;ajaxComplete&quot;, function(){
   $(this).hide();
 });
&lt;/pre&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;div style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: verdana, helvetica, arial, sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;&quot;&gt;
Global events can be disabled, for a particular Ajax request, by&lt;br /&gt;
passing in the global option, like so:&lt;/div&gt;
&lt;table cellpadding=&quot;5&quot; cellspacing=&quot;5&quot; class=&quot;src&quot; style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: #f1f1f1; border-collapse: collapse; border: 1px solid rgb(170, 170, 170); color: black; font-family: verdana, helvetica, arial, sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; padding-left: 5px; text-align: left; text-indent: 0px; text-transform: none; vertical-align: top; white-space: normal; widows: 2; width: 552px; word-spacing: 0px;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;border-collapse: collapse; border: 1px solid rgb(170, 170, 170); font-family: verdana, helvetica, arial, sans-serif; margin-bottom: 0px; text-align: left; vertical-align: top;&quot;&gt;&lt;pre style=&quot;font-family: &#39;Courier New&#39;, monospace; font-size: 12px; margin-bottom: 0px; margin-left: 0px; margin-top: 0px;&quot;&gt; $.ajax({
   url: &quot;MyPage.html&quot;,
   global: false,
   // ...
 });
&lt;/pre&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;h1 style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: Helvetica, Arial, &#39;Liberation Sans&#39;, FreeSans, sans-serif; font-size: 18px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.5; margin-bottom: 0px; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;&quot;&gt;
Events:&lt;/h1&gt;
&lt;div style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: verdana, helvetica, arial, sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;&quot;&gt;
Below is the full list of Ajax events, where the ajaxStart and ajaxStop events are&lt;br /&gt;
&amp;nbsp;events that relate to all Ajax requests together.&lt;/div&gt;
&lt;ul style=&quot;-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: verdana, helvetica, arial, sans-serif; font-size: 11px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;&quot;&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;ajaxStart&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Global Event)&lt;br /&gt;
This event is broadcast if an Ajax request is started and no other&lt;br /&gt;
Ajax requests are currently running.&lt;/div&gt;
&lt;ul style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;beforeSend&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Local Event)&lt;br /&gt;
This event, which is triggered before an Ajax request&lt;br /&gt;
is started, allows you to modify the XMLHttpRequest object&lt;br /&gt;
(setting additional headers, if need be.)&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;ajaxSend&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Global Event)&lt;br /&gt;
This global event is also triggered before the request is run.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;success&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Local Event)&lt;br /&gt;
This event is only called if the request was successful (no errors&lt;br /&gt;
&amp;nbsp;from the server, no errors with the data).&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;ajaxSuccess&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Global Event)&lt;br /&gt;
This event is also only called if the request was successful.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;error&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Local Event)&lt;br /&gt;
This event is only called if an error occurred with the request&lt;br /&gt;
&amp;nbsp;(you can never have both an error and a success callback with a request).&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;ajaxError&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Global Event)&lt;br /&gt;
This global event behaves the same as the local error event.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;complete&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Local Event)&lt;br /&gt;
This event is called regardless of if the request was successful,&lt;br /&gt;
or not. You will always receive a complete callback, even for&lt;br /&gt;
synchronous requests.&lt;/div&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif;&quot;&gt;
&lt;b&gt;ajaxComplete&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Global Event)&lt;br /&gt;
This event behaves the same as the complete event and will be&lt;br /&gt;
triggered every time an Ajax request finishes.&lt;/div&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/li&gt;
&lt;li&gt;&lt;div style=&quot;font-family: verdana,helvetica,arial,sans-serif; text-align: justify;&quot;&gt;
&lt;b&gt;ajaxStop&lt;/b&gt;&lt;span class=&quot;Apple-converted-space&quot;&gt;&amp;nbsp;&lt;/span&gt;(Global Event)&lt;br /&gt;
This global event is triggered if there are no more Ajax requests being processed.&lt;/div&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/824968137919524196/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/824968137919524196' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/824968137919524196'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/824968137919524196'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2013/01/jquery-ajax-events.html' title='jQuery - AJAX Events'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-8601885770389568881</id><published>2011-08-06T18:13:00.001-07:00</published><updated>2011-08-06T18:13:49.971-07:00</updated><title type='text'>HttpCookieMode enumerations</title><content type='html'></content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/8601885770389568881/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/8601885770389568881' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/8601885770389568881'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/8601885770389568881'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/08/httpcookiemode-enumerations.html' title='HttpCookieMode enumerations'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-8416255100862277762</id><published>2011-07-05T15:55:00.000-07:00</published><updated>2011-07-05T15:55:44.752-07:00</updated><title type='text'>Design Principles</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;span style=&quot;font-weight: bold; text-decoration: underline;&quot;&gt;SOLID Principles:&lt;/span&gt;&lt;br /&gt;
&lt;a href=&quot;http://en.wikipedia.org/wiki/Single_responsibility_principle&quot;&gt;SRP&lt;/a&gt;:(single responsibility principle)&lt;br /&gt;
&lt;a href=&quot;http://en.wikipedia.org/wiki/Open/closed_principle&quot;&gt;OCP&lt;/a&gt;:(Open Close Principle)&lt;br /&gt;
&lt;a href=&quot;http://en.wikipedia.org/wiki/Liskov_substitution_principle&quot;&gt;LSP&lt;/a&gt;: (Liskov substitution principle - Design By Contract)&lt;br /&gt;
&lt;a href=&quot;http://en.wikipedia.org/wiki/Interface_segregation_principle&quot;&gt;ISP&lt;/a&gt;:(Interface-segregation principle)&lt;br /&gt;
&lt;a href=&quot;http://en.wikipedia.org/wiki/Dependency_inversion_principle&quot;&gt;DIP&lt;/a&gt;:(Dependency inversion principle)&lt;br /&gt;
&lt;br /&gt;
Inheritance --&amp;gt; is - a &lt;br /&gt;
Composition --&amp;gt; part - of &lt;br /&gt;
Aggregation --&amp;gt; has - a &lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/8416255100862277762/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/8416255100862277762' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/8416255100862277762'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/8416255100862277762'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/07/design-principles.html' title='Design Principles'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-5311929694795393569</id><published>2011-07-02T04:30:00.001-07:00</published><updated>2011-07-02T04:30:45.962-07:00</updated><title type='text'>LINQ</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;!--[if gte mso 9]&gt;&lt;xml&gt;  &lt;w:WordDocument&gt;   &lt;w:View&gt;Normal&lt;/w:View&gt;   &lt;w:Zoom&gt;0&lt;/w:Zoom&gt;   &lt;w:TrackMoves/&gt;   &lt;w:TrackFormatting/&gt;   &lt;w:PunctuationKerning/&gt;   &lt;w:ValidateAgainstSchemas/&gt;   &lt;w:SaveIfXMLInvalid&gt;false&lt;/w:SaveIfXMLInvalid&gt;   &lt;w:IgnoreMixedContent&gt;false&lt;/w:IgnoreMixedContent&gt;   &lt;w:AlwaysShowPlaceholderText&gt;false&lt;/w:AlwaysShowPlaceholderText&gt;   &lt;w:DoNotPromoteQF/&gt;   &lt;w:LidThemeOther&gt;EN-US&lt;/w:LidThemeOther&gt;   &lt;w:LidThemeAsian&gt;X-NONE&lt;/w:LidThemeAsian&gt;   &lt;w:LidThemeComplexScript&gt;X-NONE&lt;/w:LidThemeComplexScript&gt;   &lt;w:Compatibility&gt;    &lt;w:BreakWrappedTables/&gt;    &lt;w:SnapToGridInCell/&gt;    &lt;w:WrapTextWithPunct/&gt;    &lt;w:UseAsianBreakRules/&gt;    &lt;w:DontGrowAutofit/&gt;    &lt;w:SplitPgBreakAndParaMark/&gt;    &lt;w:DontVertAlignCellWithSp/&gt;    &lt;w:DontBreakConstrainedForcedTables/&gt;    &lt;w:DontVertAlignInTxbx/&gt;    &lt;w:Word11KerningPairs/&gt;    &lt;w:CachedColBalance/&gt;   &lt;/w:Compatibility&gt;   &lt;w:BrowserLevel&gt;MicrosoftInternetExplorer4&lt;/w:BrowserLevel&gt;   &lt;m:mathPr&gt;    &lt;m:mathFont m:val=&quot;Cambria Math&quot;/&gt;    &lt;m:brkBin m:val=&quot;before&quot;/&gt;    &lt;m:brkBinSub m:val=&quot;--&quot;/&gt;    &lt;m:smallFrac m:val=&quot;off&quot;/&gt;    &lt;m:dispDef/&gt;    &lt;m:lMargin m:val=&quot;0&quot;/&gt;    &lt;m:rMargin m:val=&quot;0&quot;/&gt;    &lt;m:defJc m:val=&quot;centerGroup&quot;/&gt;    &lt;m:wrapIndent m:val=&quot;1440&quot;/&gt;    &lt;m:intLim m:val=&quot;subSup&quot;/&gt;    &lt;m:naryLim m:val=&quot;undOvr&quot;/&gt;   &lt;/m:mathPr&gt;&lt;/w:WordDocument&gt; &lt;/xml&gt;&lt;![endif]--&gt;&lt;!--[if gte mso 9]&gt;&lt;xml&gt;  &lt;w:LatentStyles DefLockedState=&quot;false&quot; DefUnhideWhenUsed=&quot;true&quot;
  DefSemiHidden=&quot;true&quot; DefQFormat=&quot;false&quot; DefPriority=&quot;99&quot;
  LatentStyleCount=&quot;267&quot;&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;0&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Normal&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;heading 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; QFormat=&quot;true&quot; Name=&quot;heading 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; QFormat=&quot;true&quot; Name=&quot;heading 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; QFormat=&quot;true&quot; Name=&quot;heading 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; QFormat=&quot;true&quot; Name=&quot;heading 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; QFormat=&quot;true&quot; Name=&quot;heading 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; QFormat=&quot;true&quot; Name=&quot;heading 7&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; QFormat=&quot;true&quot; Name=&quot;heading 8&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;9&quot; QFormat=&quot;true&quot; Name=&quot;heading 9&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 7&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 8&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; Name=&quot;toc 9&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;35&quot; QFormat=&quot;true&quot; Name=&quot;caption&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;10&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Title&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;1&quot; Name=&quot;Default Paragraph Font&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;11&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Subtitle&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;22&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Strong&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;20&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Emphasis&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;59&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Table Grid&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; UnhideWhenUsed=&quot;false&quot; Name=&quot;Placeholder Text&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;1&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;No Spacing&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;60&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Shading&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;61&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light List&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;62&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Grid&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;63&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;64&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;65&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;66&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;67&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;68&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;69&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;70&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Dark List&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;71&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Shading&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;72&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful List&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;73&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Grid&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;60&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Shading Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;61&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light List Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;62&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Grid Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;63&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 1 Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;64&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 2 Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;65&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 1 Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; UnhideWhenUsed=&quot;false&quot; Name=&quot;Revision&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;34&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;List Paragraph&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;29&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Quote&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;30&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Intense Quote&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;66&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 2 Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;67&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 1 Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;68&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 2 Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;69&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 3 Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;70&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Dark List Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;71&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Shading Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;72&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful List Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;73&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Grid Accent 1&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;60&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Shading Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;61&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light List Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;62&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Grid Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;63&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 1 Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;64&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 2 Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;65&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 1 Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;66&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 2 Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;67&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 1 Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;68&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 2 Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;69&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 3 Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;70&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Dark List Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;71&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Shading Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;72&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful List Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;73&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Grid Accent 2&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;60&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Shading Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;61&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light List Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;62&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Grid Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;63&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 1 Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;64&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 2 Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;65&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 1 Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;66&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 2 Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;67&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 1 Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;68&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 2 Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;69&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 3 Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;70&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Dark List Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;71&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Shading Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;72&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful List Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;73&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Grid Accent 3&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;60&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Shading Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;61&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light List Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;62&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Grid Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;63&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 1 Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;64&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 2 Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;65&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 1 Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;66&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 2 Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;67&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 1 Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;68&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 2 Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;69&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 3 Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;70&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Dark List Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;71&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Shading Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;72&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful List Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;73&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Grid Accent 4&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;60&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Shading Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;61&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light List Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;62&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Grid Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;63&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 1 Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;64&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 2 Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;65&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 1 Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;66&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 2 Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;67&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 1 Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;68&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 2 Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;69&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 3 Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;70&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Dark List Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;71&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Shading Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;72&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful List Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;73&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Grid Accent 5&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;60&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Shading Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;61&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light List Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;62&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Light Grid Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;63&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 1 Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;64&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Shading 2 Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;65&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 1 Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;66&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium List 2 Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;67&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 1 Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;68&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 2 Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;69&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Medium Grid 3 Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;70&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Dark List Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;71&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Shading Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;72&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful List Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;73&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; Name=&quot;Colorful Grid Accent 6&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;19&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Subtle Emphasis&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;21&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Intense Emphasis&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;31&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Subtle Reference&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;32&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Intense Reference&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;33&quot; SemiHidden=&quot;false&quot;
   UnhideWhenUsed=&quot;false&quot; QFormat=&quot;true&quot; Name=&quot;Book Title&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;37&quot; Name=&quot;Bibliography&quot;/&gt;   &lt;w:LsdException Locked=&quot;false&quot; Priority=&quot;39&quot; QFormat=&quot;true&quot; Name=&quot;TOC Heading&quot;/&gt;  &lt;/w:LatentStyles&gt; &lt;/xml&gt;&lt;![endif]--&gt;&lt;!--[if gte mso 10]&gt; &lt;style&gt;
 /* Style Definitions */
 table.MsoNormalTable
 {mso-style-name:&quot;Table Normal&quot;;
 mso-tstyle-rowband-size:0;
 mso-tstyle-colband-size:0;
 mso-style-noshow:yes;
 mso-style-priority:99;
 mso-style-qformat:yes;
 mso-style-parent:&quot;&quot;;
 mso-padding-alt:0in 5.4pt 0in 5.4pt;
 mso-para-margin-top:0in;
 mso-para-margin-right:0in;
 mso-para-margin-bottom:10.0pt;
 mso-para-margin-left:0in;
 line-height:115%;
 mso-pagination:widow-orphan;
 font-size:11.0pt;
 font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
 mso-ascii-font-family:Calibri;
 mso-ascii-theme-font:minor-latin;
 mso-fareast-font-family:&quot;Times New Roman&quot;;
 mso-fareast-theme-font:minor-fareast;
 mso-hansi-font-family:Calibri;
 mso-hansi-theme-font:minor-latin;
 mso-bidi-font-family:&quot;Times New Roman&quot;;
 mso-bidi-theme-font:minor-bidi;}
table.MsoTableLightShading
 {mso-style-name:&quot;Light Shading&quot;;
 mso-tstyle-rowband-size:1;
 mso-tstyle-colband-size:1;
 mso-style-priority:60;
 mso-style-unhide:no;
 border-top:solid black 1.0pt;
 mso-border-top-themecolor:text1;
 border-left:none;
 border-bottom:solid black 1.0pt;
 mso-border-bottom-themecolor:text1;
 border-right:none;
 mso-padding-alt:0in 5.4pt 0in 5.4pt;
 mso-para-margin:0in;
 mso-para-margin-bottom:.0001pt;
 mso-pagination:widow-orphan;
 font-size:11.0pt;
 font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
 mso-ascii-font-family:Calibri;
 mso-ascii-theme-font:minor-latin;
 mso-hansi-font-family:Calibri;
 mso-hansi-theme-font:minor-latin;
 mso-bidi-font-family:&quot;Times New Roman&quot;;
 mso-bidi-theme-font:minor-bidi;
 color:black;
 mso-themecolor:text1;
 mso-themeshade:191;}
table.MsoTableLightShadingFirstRow
 {mso-style-name:&quot;Light Shading&quot;;
 mso-table-condition:first-row;
 mso-style-priority:60;
 mso-style-unhide:no;
 mso-tstyle-border-top:1.0pt solid black;
 mso-tstyle-border-top-themecolor:text1;
 mso-tstyle-border-left:cell-none;
 mso-tstyle-border-bottom:1.0pt solid black;
 mso-tstyle-border-bottom-themecolor:text1;
 mso-tstyle-border-right:cell-none;
 mso-tstyle-border-insideh:cell-none;
 mso-tstyle-border-insidev:cell-none;
 mso-para-margin-top:0in;
 mso-para-margin-bottom:0in;
 mso-para-margin-bottom:.0001pt;
 line-height:normal;
 mso-ansi-font-weight:bold;
 mso-bidi-font-weight:bold;}
table.MsoTableLightShadingLastRow
 {mso-style-name:&quot;Light Shading&quot;;
 mso-table-condition:last-row;
 mso-style-priority:60;
 mso-style-unhide:no;
 mso-tstyle-border-top:1.0pt solid black;
 mso-tstyle-border-top-themecolor:text1;
 mso-tstyle-border-left:cell-none;
 mso-tstyle-border-bottom:1.0pt solid black;
 mso-tstyle-border-bottom-themecolor:text1;
 mso-tstyle-border-right:cell-none;
 mso-tstyle-border-insideh:cell-none;
 mso-tstyle-border-insidev:cell-none;
 mso-para-margin-top:0in;
 mso-para-margin-bottom:0in;
 mso-para-margin-bottom:.0001pt;
 line-height:normal;
 mso-ansi-font-weight:bold;
 mso-bidi-font-weight:bold;}
table.MsoTableLightShadingFirstCol
 {mso-style-name:&quot;Light Shading&quot;;
 mso-table-condition:first-column;
 mso-style-priority:60;
 mso-style-unhide:no;
 mso-ansi-font-weight:bold;
 mso-bidi-font-weight:bold;}
table.MsoTableLightShadingLastCol
 {mso-style-name:&quot;Light Shading&quot;;
 mso-table-condition:last-column;
 mso-style-priority:60;
 mso-style-unhide:no;
 mso-ansi-font-weight:bold;
 mso-bidi-font-weight:bold;}
table.MsoTableLightShadingOddColumn
 {mso-style-name:&quot;Light Shading&quot;;
 mso-table-condition:odd-column;
 mso-style-priority:60;
 mso-style-unhide:no;
 mso-tstyle-shading:silver;
 mso-tstyle-shading-themecolor:text1;
 mso-tstyle-shading-themetint:63;
 mso-tstyle-border-left:cell-none;
 mso-tstyle-border-right:cell-none;
 mso-tstyle-border-insideh:cell-none;
 mso-tstyle-border-insidev:cell-none;}
table.MsoTableLightShadingOddRow
 {mso-style-name:&quot;Light Shading&quot;;
 mso-table-condition:odd-row;
 mso-style-priority:60;
 mso-style-unhide:no;
 mso-tstyle-shading:silver;
 mso-tstyle-shading-themecolor:text1;
 mso-tstyle-shading-themetint:63;
 mso-tstyle-border-left:cell-none;
 mso-tstyle-border-right:cell-none;
 mso-tstyle-border-insideh:cell-none;
 mso-tstyle-border-insidev:cell-none;}
&lt;/style&gt; &lt;![endif]--&gt;  &lt;br /&gt;
&lt;table border=&quot;1&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;MsoTableLightShading&quot; style=&quot;border-collapse: collapse; border: none; mso-border-bottom-alt: solid black 1.0pt; mso-border-bottom-themecolor: text1; mso-border-top-alt: solid black 1.0pt; mso-border-top-themecolor: text1; mso-padding-alt: 0in 5.4pt 0in 5.4pt; mso-yfti-tbllook: 1184;&quot;&gt;&lt;tbody&gt;
&lt;tr style=&quot;mso-yfti-firstrow: yes; mso-yfti-irow: -1;&quot;&gt;   &lt;td style=&quot;background: #8DB3E2; border-bottom: solid black 1.0pt; border-left: none; border-right: none; border-top: solid black 1.0pt; mso-background-themecolor: text2; mso-background-themetint: 102; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 5;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Aggregate&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: #8DB3E2; border-bottom: solid black 1.0pt; border-left: none; border-right: none; border-top: solid black 1.0pt; mso-background-themecolor: text2; mso-background-themetint: 102; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 1;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Conversion&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: #8DB3E2; border-bottom: solid black 1.0pt; border-left: none; border-right: none; border-top: solid black 1.0pt; mso-background-themecolor: text2; mso-background-themetint: 102; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 1;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Ordering&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: #8DB3E2; border-bottom: solid black 1.0pt; border-left: none; border-right: none; border-top: solid black 1.0pt; mso-background-themecolor: text2; mso-background-themetint: 102; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 1;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Partitioning&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: #8DB3E2; border-bottom: solid black 1.0pt; border-left: none; border-right: none; border-top: solid black 1.0pt; mso-background-themecolor: text2; mso-background-themetint: 102; mso-border-bottom-themecolor: text1; mso-border-top-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.8pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 1;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Sets&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;tr style=&quot;mso-yfti-irow: 0;&quot;&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Aggregate&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Cast&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;OrderBy&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Skip&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.8pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Concat&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;tr style=&quot;mso-yfti-irow: 1;&quot;&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-hansi-font-family: Calibri;&quot;&gt;Average&lt;/span&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;OfType&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;ThenBy&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;SkipWhile&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.8pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Distinct&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;tr style=&quot;mso-yfti-irow: 2;&quot;&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-hansi-font-family: Calibri;&quot;&gt;Count&lt;/span&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;ToArray&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Descending&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Take&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.8pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Except&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;tr style=&quot;mso-yfti-irow: 3;&quot;&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-hansi-font-family: Calibri;&quot;&gt;Max&lt;/span&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;ToDictionary&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Reverse&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;TakeWhile&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.8pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Intersect&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;tr style=&quot;mso-yfti-irow: 4;&quot;&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-hansi-font-family: Calibri;&quot;&gt;Min&lt;/span&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;ToList&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; padding: 0in 5.4pt 0in 5.4pt; width: 95.8pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;Union&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;tr style=&quot;mso-yfti-irow: 5;&quot;&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 4;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: black; mso-ascii-font-family: Calibri; mso-bidi-font-family: Calibri; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-hansi-font-family: Calibri;&quot;&gt;Sum&lt;/span&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;ToLookup&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;border: none; padding: 0in 5.4pt 0in 5.4pt; width: 95.8pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;tr style=&quot;mso-yfti-irow: 6; mso-yfti-lastrow: yes;&quot;&gt;   &lt;td style=&quot;background: silver; border-bottom: solid black 1.0pt; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 68;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border-bottom: solid black 1.0pt; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;span style=&quot;color: black; mso-themecolor: text1; mso-themeshade: 191;&quot;&gt;ToSequence&lt;/span&gt;&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border-bottom: solid black 1.0pt; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border-bottom: solid black 1.0pt; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.75pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;   &lt;td style=&quot;background: silver; border-bottom: solid black 1.0pt; border: none; mso-background-themecolor: text1; mso-background-themetint: 63; mso-border-bottom-themecolor: text1; padding: 0in 5.4pt 0in 5.4pt; width: 95.8pt;&quot; valign=&quot;top&quot; width=&quot;160&quot;&gt;   &lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; mso-yfti-cnfc: 64;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;/td&gt;  &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/5311929694795393569/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/5311929694795393569' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/5311929694795393569'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/5311929694795393569'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/07/linq.html' title='LINQ'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-7674231407622892476</id><published>2011-06-05T08:46:00.000-07:00</published><updated>2011-06-05T08:46:56.871-07:00</updated><title type='text'>Ajax Frameworks Types</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;strong&gt;Ajax Frameworks Types&lt;/strong&gt;&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;                &lt;strong&gt;Client Side vs. Server Side Frameworks&lt;/strong&gt;&lt;br /&gt;
&amp;nbsp;&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;Two types of Ajax based frameworks used in the web programming nowadays:&amp;nbsp;&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;1. Server-side                  Framework&amp;nbsp;&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;2. Client-side Framework.&amp;nbsp;&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;Server-side framework is where the code                  executed on the Web server is considered as Server-side code&amp;nbsp; and it is installed inside the server.&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;Client-side framework is where code is executed on the user’s                  browse.&lt;/div&gt;&lt;br /&gt;
&lt;div class=&quot;page-content&quot;&gt;                Internet is an extremely wide area and because of this both the server-side and client –side                  programmers may not be in the contact and performs their work separately. Both the server-side                  and client-side functions differently and the code used in the frameworks also varies. The code of                  both the frameworks has its own pros and cons that suite to different sorts of developers.&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;                Now the question arises, what is the Server-side framework and what is Client-side? In this article,                  you will get the answer of both these queries. You will also learn about what are the advantages and                  disadvantages of both these frameworks.&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;                &lt;strong&gt;Server Side Framework&lt;/strong&gt;&lt;br /&gt;
The framework that is installed inside the server is known as Server-side framework. The coding of                  server-side framework is actually not created in JavaScript but it is the same language that API                  provided for server-side framework. So, it is not mandatory for the developers to be skilled in                  JavaScript for server-side framework programming. Nearby all the frameworks in server-side accepts                  the coding of developers and automatically translates it into Ajax when user accesses the website.&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;                Server-side framework can also be used for installing the specific functions from the library to                  translate and accessed effectively. The server-side framework exactly provides the desired functions                  and the library needed for developer to render the specific buttons and information in Ajax based                  website. The developers have to only customize the code during creating the program. Moreover,                  the server-side framework responds better because it handles a large number of user communications                  without intervention of server.&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;                Google Web Toolkit (GWT) might be an excellent example of server-side framework that is used as                  a normal Java Swing kind of programming on the server side in web pages using the GWT API. The                  other server side frameworks are: Yahoo, Toolkit and DWR.&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;                Server-side framework is basically used for server server-side programming that covers password                  protection, browser customization, form processing and building and displaying pages created                  from database.&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;strong&gt;                Pros and Cons of Server Side Frameworks&lt;/strong&gt;&lt;br /&gt;
There is no need for the developers to learn the extra language as server-side coding can be                  written in the existing language in which the server-side programmer is efficient.&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;page-content&quot;&gt;&lt;strong&gt;                Client Side Framework&lt;/strong&gt;&lt;br /&gt;
As opposing the server-side, Client-side framework is accessed and executes within the user’s                  browsers. For creating Ajax based client-side framework, developers must be efficient enough in JavaScript as well as XML. Because Ajax-based client side website is fully depended upon Ajax and it also needs to a wide range of coding for different browsers.&lt;br /&gt;
&lt;br /&gt;
The different uses of framework for different browsers make the Ajax client-side programming very complex. The frameworks written for Mozilla cannot be executed in Internet Explorer if XMLHttpRequest has not been defined and implemented for the Internet explorer too.&lt;br /&gt;
&lt;br /&gt;
The Request XMLHttpRequest performs like a bridge between the server and the client. The developers have to generate different coding for different platforms to perform it successfully. That’s why the developers must have the knowledge about which browser has been used by his client; otherwise the developer has to develop several customize client-side framework for running their own platforms.&lt;br /&gt;
&lt;br /&gt;
Through Client-side framework, users can execute any technology that supports user’s browser. In Client-side framework, users can modify several features besides codes without sending information to web server.&lt;br /&gt;
&lt;br /&gt;
In the Client-side framework, user can handle multiple asynchronous request, can detect easily error handling and exceptions and can mix and match widget facilities to get extra flexibility in the programming. (Widgets are small interfaces or components that can be integrated with an application easily through client side framework)&lt;br /&gt;
&lt;br /&gt;
Client-side framework is used in online games, customizing the display without reloading the page and getting data about the user’s screen or browser. The examples of client-side framework are Prototype, DOJO Toolkit, Rico, Script.aculo.us and many more.&lt;br /&gt;
&lt;br /&gt;
Pros and Cons of Client Side Frameworks&lt;br /&gt;
&lt;br /&gt;
Client-side framework is more flexible than server-side due to multi-handing frameworks, easily error handling and exceptions while the adding of widgets makes it extra-flexible. &lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/7674231407622892476/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/7674231407622892476' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/7674231407622892476'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/7674231407622892476'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/06/ajax-frameworks-types.html' title='Ajax Frameworks Types'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-7332896627283951154</id><published>2011-03-12T20:44:00.001-08:00</published><updated>2011-03-12T20:44:48.876-08:00</updated><title type='text'>Static Class</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;Static Class cannot be instantiated unlike the unstatic class. You  should directly access its Method via the ClassName.MethodName&lt;br /&gt;
&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;A Program can&#39;t tell when it is going to load static class but its definitely loaded before the call.&lt;br /&gt;
&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;A Static class will always have the static constructor and its  called only once since after that its in the memory for its lifetime.&lt;br /&gt;
&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;A Static class can contain only static members. So all the members and functions have to be static.&lt;br /&gt;
&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;A Static class is always sealed since it cannot be inherited  further. Further they cannot inherit form any other class (except  Object)&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/7332896627283951154/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/7332896627283951154' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/7332896627283951154'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/7332896627283951154'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/03/static-class.html' title='Static Class'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-6927524394767246746</id><published>2011-03-12T20:43:00.001-08:00</published><updated>2013-03-05T20:49:14.254-08:00</updated><title type='text'>Static Constructor</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;This is a special constructor and gets called before the first object is created of the class. The time of execution cannot be determined, but it is definitely before the first object creation - could be at the time of loading the assembly.&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;Notes for Static Constructors:&lt;/span&gt;&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;It is used to initialize static data members. &lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;Can&#39;t access anything but static members.&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;The static constructor should be without parameters.
&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;Can&#39;t have access modifiers like Public, Private or Protected.&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-size: x-small;&quot;&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;There can be only one static constructor in the class.&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;A class can have static as well as non static constructor without arg at same time.&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div&gt;
&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;The syntax of writing the static constructors is also damn simple. Here it is:&lt;/span&gt;&lt;/div&gt;
&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
public class Sample{&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; static&amp;nbsp;Sample()&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; {&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; // Only static members are accessible.&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; // Initialization code can be here.&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; }&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; // Other class methods goes here&lt;/div&gt;
&lt;div&gt;
}&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Let us understand features step by step here.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Firstly, the call to the static method is made by the CLR and not by the object, so we do not need to have the access modifier to it.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Secondly, it is going to be called by CLR, who can pass the parameters to it, if required. So we cannot have parameterized static constructor.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Thirdly, non-static members in the class are specific to the object instance. So static constructor, if allowed to work on non-static members, will reflect the changes in all the object instances, which is impractical. So static constructor can access only static members of the class.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Fourthly, overloading needs the two methods to be different in terms of methods definition, which you cannot do with Static Constructors, so you can have at the most one static constructor in the class.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Now, one question raises here, can we have two constructors as:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
public class Sample&lt;/div&gt;
&lt;/span&gt;&lt;span style=&quot;font-family: Verdana; font-size: x-small;&quot;&gt;&lt;div&gt;
{&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; static&amp;nbsp;Sample()&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; {&lt;/div&gt;
&lt;div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; // Only static members are accessible.&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; // Initialization code can be here.&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; }&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; public&amp;nbsp;Sample()&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; {&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; // Code for the First Constructor.&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; }&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&amp;nbsp; &amp;nbsp; // Other class methods goes here&lt;/div&gt;
&lt;div&gt;
}&lt;/div&gt;
&lt;div&gt;
This is perfectly valid, though doesn&#39;t seem to be in accordance with overloading concepts. But why? Because the time of execution of the two methods are different. One is at the time of loading the assembly and one is at the time of object creation.&lt;/div&gt;
&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/6927524394767246746/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/6927524394767246746' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6927524394767246746'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6927524394767246746'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/03/static-constructor.html' title='Static Constructor'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-3859998653089953753</id><published>2011-02-16T15:21:00.000-08:00</published><updated>2011-02-16T15:21:06.360-08:00</updated><title type='text'>SQL Server Q &amp; A -1</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;&lt;span style=&quot;color: blue; font-family: Arial;&quot;&gt;1. How to optimize stored procedures in SQL Server?&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;Ans:&lt;/b&gt; I. Use where clause&lt;br /&gt;
II. Select only required fields&lt;br /&gt;
III. Do join on indexed key fields&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: Arial;&quot;&gt;2. What is the difference between Stored procedure and User defined functions?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: Arial;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: Arial;&quot;&gt;3. Why should we go for Stored Procedures? Why not direct queries?&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;Ans:&lt;/b&gt; SP are precompiled and contain an execution plan with it. Hence, they are faster.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: Arial;&quot;&gt;4. How many NULL values we can have in a Unique key field in SQL Server?&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;Ans:&lt;/b&gt; Only one. In case of Oracle, we can have multiple NULL values in a Unique key field.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue; font-family: arial;&quot;&gt;5. What is correlated subquery?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #3333ff;&quot;&gt;6. What is an index. What are the types?&lt;/span&gt;&lt;br /&gt;
Indexes in databases are very much similar to Indexes in Books. Indexes help in searching data faster.&lt;br /&gt;
&lt;br /&gt;
Types: Clustered Index&lt;br /&gt;
Non-Clustered Index&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: blue;&quot;&gt;&lt;span style=&quot;font-family: arial;&quot;&gt;7&lt;/span&gt;. What is the difference between a clustered index and a non-clustered index?&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;Clustered Index&lt;/b&gt;:&lt;br /&gt;
1    Only one clustered index allowed per table&lt;br /&gt;
2    Physically rearranges the data&lt;br /&gt;
3    For use on columns that are frequently searched for range of data&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Non-clustered Index&lt;/b&gt;:&lt;br /&gt;
1    Upto 249 non-clustered index allowed per table&lt;br /&gt;
2    Doesn’t rearrange the data. Keeps a pointer to the data.&lt;br /&gt;
3    For use on columns that are searched for single value.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #3333ff;&quot;&gt;&lt;span style=&quot;font-family: arial;&quot;&gt;8.&lt;/span&gt; What is a join? What are the types of joins?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black; font-family: arial;&quot;&gt;Joins are used to retrieve data from multiple tables.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black; font-family: arial;&quot;&gt;Following  are the types of joins:&lt;/span&gt;&lt;span style=&quot;color: black;&quot;&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: arial;&quot;&gt;Inner join&lt;br /&gt;
Left outer join&lt;br /&gt;
Right outer join&lt;br /&gt;
Full outer join&lt;br /&gt;
Cross join&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: arial;&quot;&gt;9. What is a transaction?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: Arial;&quot;&gt;&lt;/span&gt;A  SQL transaction is a sequence of operations performed as a single unit  of work. If all the tasks are completed successfully, then the  transaction is committed (saved). If a single task fails, the  transaction is rolled back (discarded).&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: arial;&quot;&gt;10. What is ACID property of transaction?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: Arial;&quot;&gt;&lt;/span&gt;A SQL transaction must exhibit ACID property, i.e Atomicity, Consistency, Isolation, and Durability.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Atomicity:&lt;/b&gt;  A transaction is always treated as a single unit of work, i.e. either  all the tasks are performed or none of them, no intermediate stage.&lt;br /&gt;
&lt;b&gt;Consistency:&lt;/b&gt; When a transaction is completed, it must leave all data in a consistent state. &lt;br /&gt;
&lt;b&gt;Isolation:&lt;/b&gt; Modifications made by a transaction must be isolated from the modifications made by other transactions. &lt;br /&gt;
&lt;b&gt;Durability:&lt;/b&gt; After a transaction is completed, it’s effects are permanently in place in the system.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: arial;&quot;&gt;11. What is &lt;strong&gt;SET NOCOUNT ON&lt;/strong&gt;?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: Arial;&quot;&gt;&lt;/span&gt;When we perform a &lt;strong&gt;SELECT, INSERT, UPDATE or DELETE&lt;/strong&gt; query, it returns a &lt;strong&gt;COUNT&lt;/strong&gt; (number of rows affected) when &lt;strong&gt;SET NOCOUNT OFF&lt;/strong&gt;. If &lt;strong&gt;SET NOCOUNT ON&lt;/strong&gt;, it doesn’t return the &lt;strong&gt;COUNT&lt;/strong&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: arial;&quot;&gt;12. How to delete exactly duplicate records from a table?&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: Arial;&quot;&gt;&lt;/span&gt;There are many ways. Simplest answer is:&lt;br /&gt;
i. Let the table tab1 contains duplicate records.&lt;br /&gt;
ii. Insert distinct records from tab1 in a temporary table #temp       &lt;br /&gt;
INSERT INTO #temp   &lt;br /&gt;
SELECT DISTINCT * FROM tab1&lt;br /&gt;
iii. Delete all rows from original table tab1 &lt;br /&gt;
DELETE FROM tab1&lt;br /&gt;
iv. Insert from temporary table&lt;br /&gt;
INSERT INTO tab1&lt;br /&gt;
SELECT * FROM #temp&lt;br /&gt;
Try other solutions yourself.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: arial;&quot;&gt;13. How to get &lt;strong&gt;nth&lt;/strong&gt; highest salary from employee table.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #3333ff; font-family: Arial;&quot;&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;The query below demonstrates how to find the 5th highest salary. Replace 5 with any integer to get nth salary.&lt;br /&gt;
&lt;br /&gt;
SELECT TOP 1 SALARY&lt;br /&gt;
FROM (SELECT DISTINCT TOP 5 SALARY&lt;br /&gt;
FROM EMPLOYEE ORDER BY SALARY DESC) a&lt;br /&gt;
ORDER BY SALARY ASC&lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/3859998653089953753/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/3859998653089953753' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/3859998653089953753'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/3859998653089953753'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/02/sql-server-q-1.html' title='SQL Server Q &amp; A -1'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-743253735260785892</id><published>2011-01-14T04:06:00.000-08:00</published><updated>2011-01-14T04:11:11.782-08:00</updated><title type='text'>Enabling SQL Cache Dependency in ASP.NET</title><content type='html'>1• Enable notifications for the database.&lt;br /&gt;
2• Enable notifications for individual tables.&lt;br /&gt;
3• Enable ASP.NET polling using “web.config” file&lt;br /&gt;
4• Finally use the Cache dependency object in your ASP.NET code&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote style=&quot;background-color: #351c75; color: white;&quot;&gt;&lt;b&gt;1. Enabling notifications for the database.&lt;/b&gt;&lt;/blockquote&gt;a. Enable notifications for the database, that can be done by using aspnet_regsql.exe, a command line utility.&lt;br /&gt;
&lt;blockquote&gt;CD c:\[WinDir]\Microsoft.NET\Framework\[Version] directory &lt;/blockquote&gt;b. execute the command at the same location as&lt;br /&gt;
&lt;blockquote&gt;c:&amp;gt;[WinDir]\Microsoft.NET\Framework\[Version] directory&amp;gt; aspnet_regsql -ed -E -d MyDBName&lt;/blockquote&gt;&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td&gt;Switch&lt;/td&gt;&lt;td&gt;Description&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;-ed&lt;/td&gt;&lt;td&gt;command-line switch&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;-E&lt;/td&gt;&lt;td&gt;Use trusted connection&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;-S&lt;/td&gt;&lt;td&gt;Specify server name it other than the current computer you are working on&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;-d&lt;/td&gt;&lt;td&gt;Database Name&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
The above command will cause to create one new table and new stored procedures as specified below in the database.&lt;br /&gt;
&lt;br /&gt;
Essentially, when a change takes place, a record is written in this table. The SQL Server&lt;br /&gt;
polling queries this table for changes.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td&gt;&lt;b&gt;Procedure Name&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Description&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;AspNet_Sql&lt;br /&gt;
CacheRegisterTable&lt;br /&gt;
StoredProcedure&lt;/td&gt;&lt;td&gt;This  stored procedure sets a table to support notifications. This process  works by adding a notification trigger to the table, which will fire  when any row is inserted, deleted, or updated.&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;AspNet_SqlCache&lt;br /&gt;
UnRegisterTable&lt;br /&gt;
StoredProcedure&lt;/td&gt;&lt;td&gt;This stored procedure takes a registered table and removes the notification trigger so that notifications won&#39;t be generated.&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;AspNet_Sql&lt;br /&gt;
CacheUpdateChange&lt;br /&gt;
IdStoredProcedure&lt;/td&gt;&lt;td&gt;The  notification trigger calls this stored procedure to update the  AspNet_SqlCacheTablesFor ChangeNotification table, thereby indicating  that the table has changed.&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;AspNet_SqlCache&lt;br /&gt;
QueryRegistered&lt;br /&gt;
TablesStored&lt;br /&gt;
Procedure&lt;/td&gt;&lt;td&gt;This extracts just the table&lt;br /&gt;
names from the AspNet_SqlCacheTablesForChangeNotification table. It’s used to get a&lt;br /&gt;
quick look at all the registered tables.&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;AspNet_SqlCache&lt;br /&gt;
PollingStored&lt;br /&gt;
Procedure&lt;/td&gt;&lt;td&gt;This will get the list of changes from the&lt;br /&gt;
AspNet_SqlCacheTablesForChangeNotification table. It is used to perform polling.&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td&gt;&lt;b&gt;Table Name&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Description&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;AspNet_SqlCacheTablesForChangeNotification&lt;/td&gt;&lt;td&gt;Has  three columns: tableName, notificationCreated, and changeId. This table  is used to track changes. Essentially, when a change takes place, a  record is written into this table. The SQL Server polling queries this  table. Also a set of stored procedures is added to the database as well.  See the following table.&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
&lt;blockquote style=&quot;background-color: #351c75; color: white;&quot;&gt;&lt;b&gt;2. Enabling notification for individual tables&lt;/b&gt;&lt;/blockquote&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;After enabling notification for database, need to enable notification support for each individual table.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;&lt;b&gt;a. &lt;/b&gt;This also can be done manually using &lt;/span&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;AspNet_SqlCacheRegisterTableStoredProcedure in query analyzer, for example, as given below:&lt;/span&gt;&lt;br /&gt;
&lt;blockquote&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;br /&gt;
&lt;div style=&quot;background-color: #cccccc;&quot;&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;exec AspNet_SqlCacheRegisterTableStoredProcedure &#39;TableName&#39;&lt;/span&gt;&lt;/div&gt;&lt;/blockquote&gt;&lt;br /&gt;
&lt;b&gt;b.&lt;/b&gt; This also can be done with the use of &lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;&quot;aspnet_regsql&quot; with &lt;/span&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;parameters as discussed&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt; &lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td&gt;Parameter&lt;/td&gt;&lt;td&gt;Description&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;-et &lt;/td&gt;&lt;td&gt;to enable a able for sql cache dependency notifications &lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td&gt;-t &lt;/td&gt;&lt;td&gt;to name the table&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
e.g.&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote&gt;&lt;div style=&quot;background-color: #cccccc;&quot;&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;aspnet_regsql -et -E -d Northwind -t &#39;&lt;/span&gt;&lt;b&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;TableName&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;&#39;&lt;/span&gt;&lt;/div&gt;&lt;/blockquote&gt;&lt;br /&gt;
&amp;nbsp;Registering tables for notification internally creates trigger for the tables. For instance for&lt;br /&gt;
a &quot;&lt;b&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;TableName&lt;/span&gt;&lt;/b&gt;&quot; table the following trigger is created. So any modifications done to the&lt;br /&gt;
&quot;&lt;b&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;TableName&lt;/span&gt;&lt;/b&gt;&quot; table will update the &quot;&lt;b&gt;AspNet_SqlCacheNotification&quot;&lt;/b&gt; table.&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote&gt;&lt;span style=&quot;background-color: #cccccc;&quot;&gt;CREATE TRIGGER&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;dbo.[Products_AspNet_SqlCacheNotification_Trigger] ON&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;[&lt;/span&gt;&lt;b style=&quot;background-color: #cccccc;&quot;&gt;&lt;span style=&quot;color: black; font-family: Arial;&quot;&gt;TableName&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;background-color: #cccccc;&quot;&gt;]&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;FOR INSERT, UPDATE, DELETE&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;AS&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;BEGIN&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;SET NOCOUNT ON&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;EXEC dbo.AspNet_SqlCacheUpdateChangeIdStoredProcedure&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;N&#39;Products‘&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #cccccc;&quot;&gt;END&lt;/span&gt; &lt;/blockquote&gt;When you make a change in the table (such as inserting, deleting or&lt;br /&gt;
updating a record), the change Id column is incremented by 1.ASP.NET queries this table&lt;br /&gt;
repeatedly keeps track of the most recent changed values for every table. When this&lt;br /&gt;
value changes in a subsequent read, ASP.NET knows that the table has changed.&lt;br /&gt;
&lt;br /&gt;
Continue .......</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/743253735260785892/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/743253735260785892' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/743253735260785892'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/743253735260785892'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/enabling-sql-cache-dependency-in-aspnet.html' title='Enabling SQL Cache Dependency in ASP.NET'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-6343983489330915849</id><published>2011-01-14T02:13:00.001-08:00</published><updated>2011-01-14T02:13:45.776-08:00</updated><title type='text'>What are the various ways to maintain state in web application?</title><content type='html'>√ session variables&lt;br /&gt;
√ Hidden fields&lt;br /&gt;
√ View state&lt;br /&gt;
√ Hidden frames&lt;br /&gt;
√ Cookies&lt;br /&gt;
√ Query strings</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/6343983489330915849/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/6343983489330915849' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6343983489330915849'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6343983489330915849'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/what-are-various-ways-to-maintain-state.html' title='What are the various ways to maintain state in web application?'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-6615455928444203186</id><published>2011-01-13T22:13:00.000-08:00</published><updated>2011-01-13T22:14:40.328-08:00</updated><title type='text'>What is scavenging ?</title><content type='html'>&lt;i&gt;The feature of caching is one of the useful technologies that exists in web application to improve the performance of the application in many scenarios but also have drawback that it uses numerous resources of the server that includes a great amount of memory which sometimes causes the complete memory gets exhausted.&amp;nbsp;&amp;nbsp;&lt;/i&gt;&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp;So when server running your ASP.NET application runs low on memory resources, items are removed from cache depending on cache item priority. Cache item priority is set when you add item to cache. By setting the cache item priority controls the items scavenging are removed first</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/6615455928444203186/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/6615455928444203186' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6615455928444203186'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6615455928444203186'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/what-is-scavenging.html' title='What is scavenging ?'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-8542733316250219727</id><published>2011-01-13T21:26:00.000-08:00</published><updated>2011-01-13T21:26:02.446-08:00</updated><title type='text'>Call Back method creation for a cached item</title><content type='html'>Ensures cache to be updated based on changes after removal of corresponding cached item.&lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&lt;u&gt;&lt;b&gt;&lt;code&gt;CacheItemRemovedCallback&lt;/code&gt; &lt;/b&gt;delegate&lt;/u&gt;: An instance of this&amp;nbsp;delegate is passed to the &lt;code&gt;insert&lt;/code&gt; method when we insert a cache item.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Signature of the delegate:&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote&gt;&lt;pre id=&quot;pre5&quot; lang=&quot;cs&quot; style=&quot;background-color: #eeeeee; margin-top: 0pt;&quot;&gt;&lt;span class=&quot;code-keyword&quot;&gt;public&lt;/span&gt; &lt;span class=&quot;code-keyword&quot;&gt;delegate&lt;/span&gt; &lt;span class=&quot;code-keyword&quot;&gt;void&lt;/span&gt; CacheItemRemovedCallback( &lt;span class=&quot;code-keyword&quot;&gt;string&lt;/span&gt; key, 
    &lt;span class=&quot;code-keyword&quot;&gt;object&lt;/span&gt; value, CacheItemRemovedReason reason );&lt;/pre&gt;&lt;/blockquote&gt;&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;  &lt;th&gt;Parameter&lt;/th&gt;  &lt;th&gt;Description&lt;/th&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;key&lt;/td&gt;  &lt;td&gt;The index location for the item removed from the cache. &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;value&lt;/td&gt;  &lt;td&gt;The object item removed from the cache. &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;reason&lt;/td&gt; &lt;td&gt;The reason the item was removed from the cache, as specified by the CacheItemRemovedReason enumeration. &lt;/td&gt;  &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
&lt;b&gt;&lt;code&gt;CacheItemRemovedReason &lt;/code&gt;&lt;/b&gt;&lt;code&gt;enumeration: a very useful enumeration used for getting reason of expiration.&lt;/code&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;  &lt;th&gt;Parameter&lt;/th&gt;  &lt;th&gt;Description&lt;/th&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;DependencyChanged&lt;/td&gt;  &lt;td&gt;The item is removed from the cache because a file or key dependency changed. &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;Expired&lt;/td&gt;  &lt;td&gt;The item is removed from the cache because it expired. &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;Removed&lt;/td&gt;  &lt;td&gt;The item is removed from the cache by a Remove method call, or by an Insert method call that specified the same key. &lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;Underused&lt;/td&gt;  &lt;td&gt;The item is removed from the cache because the system removed it to free memory. &lt;/td&gt;   &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
e.g.&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote style=&quot;background-color: #eeeeee;&quot;&gt;public void RemovedCallback(String k, &lt;br /&gt;
Object v,CacheItemRemovedReason r) {&lt;br /&gt;
// Code to check the reason of expiration.&lt;br /&gt;
&lt;br /&gt;
// Logic to repopulate cache item using new values&lt;br /&gt;
&lt;br /&gt;
}&lt;/blockquote&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/8542733316250219727/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/8542733316250219727' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/8542733316250219727'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/8542733316250219727'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/call-back-method-creation-for-cached.html' title='Call Back method creation for a cached item'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-6378844813012312909</id><published>2011-01-13T21:11:00.000-08:00</published><updated>2011-01-14T02:56:19.658-08:00</updated><title type='text'>What is a dependency?</title><content type='html'>&lt;h2&gt;&lt;/h2&gt;Any change in the resources  which our cache item depends on[*], will make our cache item expire.&lt;br /&gt;
&lt;br /&gt;
&lt;i&gt;&amp;nbsp;[*] Expiration policy of the item based on other resources such as physical file(s) in the  server, another cache item(s), or time that can be set to be dependency for item to be cached.&lt;/i&gt;&lt;br /&gt;
&lt;br /&gt;
There are three types of dependencies:&lt;br /&gt;
&lt;ul&gt;&lt;li&gt;File based dependency  &lt;/li&gt;
&lt;li&gt;Key based dependency  &lt;/li&gt;
&lt;li&gt;Time based dependency &lt;/li&gt;
&lt;/ul&gt;&lt;h5&gt;File based dependency&lt;/h5&gt;We can set the validity of the cache item based on an external file  or files. When this resource changes, the cached object becomes obsolete  and is removed from the cache.&lt;br /&gt;
&lt;div class=&quot;small-text align-right&quot; id=&quot;premain3&quot; style=&quot;display: block;&quot; width=&quot;100%&quot;&gt;&lt;span id=&quot;precollapse3&quot; style=&quot;cursor: pointer; margin-bottom: 0pt;&quot;&gt;e.g.&lt;/span&gt;&lt;/div&gt;&lt;pre id=&quot;pre3&quot; lang=&quot;cs&quot; style=&quot;margin-top: 0pt;&quot;&gt;CacheDependency dependency = &lt;span class=&quot;code-keyword&quot;&gt;new&lt;/span&gt; CacheDependency(Server.MapPath(&lt;span class=&quot;code-string&quot;&gt;&quot;&lt;/span&gt;&lt;span class=&quot;code-string&quot;&gt;isbn.xml&quot;&lt;/span&gt;));&lt;/pre&gt;&lt;br /&gt;
For multiple file dependencies, we can pass a string array containing the filename to the constructor.&lt;br /&gt;
&lt;h5&gt;Key based dependency &lt;/h5&gt;Key based dependency enables you to associate one cached item with  another item in the cache and invalidates the first item when the second  item changes. The following code fragment demonstrates how to insert an  item into your application&#39;s &lt;code&gt;Cache&lt;/code&gt; with a dependency on a  key to another item placed in the cache. Since this method uses array  syntax, you must define the number of keys the item you are adding to  the &lt;code&gt;Cache&lt;/code&gt; is dependent on.&lt;br /&gt;
&lt;div class=&quot;small-text align-right&quot; id=&quot;premain4&quot; style=&quot;display: block;&quot; width=&quot;100%&quot;&gt;&lt;br /&gt;
e.g.&lt;br /&gt;
&lt;br /&gt;
&lt;/div&gt;&lt;pre id=&quot;pre4&quot; lang=&quot;cs&quot; style=&quot;margin-top: 0pt;&quot;&gt;&lt;span class=&quot;code-SDKkeyword&quot;&gt;String&lt;/span&gt;[] dependencyKey = &lt;span class=&quot;code-keyword&quot;&gt;new&lt;/span&gt; &lt;span class=&quot;code-SDKkeyword&quot;&gt;String&lt;/span&gt;[&lt;span class=&quot;code-digit&quot;&gt;1&lt;/span&gt;];
dependencyKey[&lt;span class=&quot;code-digit&quot;&gt;0&lt;/span&gt;] = &lt;span class=&quot;code-string&quot;&gt;&quot;&lt;/span&gt;&lt;span class=&quot;code-string&quot;&gt;key1&quot;&lt;/span&gt;; 
CacheDependency dependency = &lt;span class=&quot;code-keyword&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/pre&gt;&lt;pre id=&quot;pre4&quot; lang=&quot;cs&quot; style=&quot;margin-top: 0pt;&quot;&gt;&lt;span class=&quot;code-keyword&quot;&gt;new&lt;/span&gt; CacheDependency(&lt;span class=&quot;code-keyword&quot;&gt;null&lt;/span&gt;, dependencyKey);&lt;/pre&gt;&lt;pre id=&quot;pre4&quot; lang=&quot;cs&quot; style=&quot;margin-top: 0pt;&quot;&gt;&amp;nbsp;&lt;/pre&gt;You can use multiple key dependencies by increasing the array size and adding the keys to the array.&lt;br /&gt;
&lt;h5&gt;Time based dependency. &lt;/h5&gt;A time based dependency expires the item at a predefined time. There  are two types of time-based dependency: Absolute and Sliding explained in under &lt;a href=&quot;http://developmentskills.blogspot.com/2011/01/aspnet-cache.html&quot;&gt;ASP.NET Cache.&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/6378844813012312909/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/6378844813012312909' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6378844813012312909'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6378844813012312909'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/what-is-dependency.html' title='What is a dependency?'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-2107101172666988703</id><published>2011-01-13T21:00:00.000-08:00</published><updated>2011-01-13T21:36:25.283-08:00</updated><title type='text'>Cache Insert() Method</title><content type='html'>Insert() ---&amp;gt; it overwrites the item if same key already exists in the cache.&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote style=&quot;background-color: #eeeeee;&quot;&gt;public void Insert(string key, object value,CacheDependency dependencies,&lt;br /&gt;
DateTime absoluteExpiration,&lt;br /&gt;
TimeSpan slidingExpiration,&lt;br /&gt;
CacheItemPriority priority,&lt;br /&gt;
CacheItemRemovedCallback onRemoveCallback );&lt;/blockquote&gt;&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;  &lt;th&gt;Parameter&lt;/th&gt;  &lt;th&gt;Description&lt;/th&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;key&lt;/td&gt;  &lt;td&gt;The cache key used to reference the object. &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;value&lt;/td&gt;  &lt;td&gt;The object to be inserted in the cache. &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;dependencies&lt;/td&gt;  &lt;td&gt;The file or cache key dependencies for the item. When any dependency changes, the object becomes invalid and is removed from the cache. If there are no dependencies, this parameter contains a null reference (Nothing in Visual Basic).  &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;absoluteExpiration&lt;/td&gt;  &lt;td&gt;The time at which the inserted object expires and is removed from the cache.&lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;slidingExpiration&lt;/td&gt;  &lt;td&gt;The interval between the time the inserted object was last accessed and when that object expires. If this value is the equivalent of 20 minutes, the object will expire and be removed from the cache 20 minutes after it was last accessed. &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;priority&lt;/td&gt;  &lt;td&gt;The cost of the object relative to other items stored in the cache, as expressed by the CacheItemPriority enumeration. This value is used by the cache when it evicts objects; objects with a lower cost are removed from the cache before objects with a higher cost. &lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;onRemoveCallback&lt;/td&gt;  &lt;td&gt;A delegate that, if provided, will be called when an object is removed from the cache. You can use this to notify applications when their objects are deleted from the cache. &lt;/td&gt;   &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
e.g.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre id=&quot;pre2&quot; lang=&quot;cs&quot; style=&quot;margin-top: 0pt;&quot;&gt;Cache.Insert (&lt;span class=&quot;code-string&quot;&gt;&quot;&lt;/span&gt;&lt;span class=&quot;code-string&quot;&gt;DSN&quot;&lt;/span&gt;, connectionString,&lt;span class=&quot;code-keyword&quot;&gt;new&lt;/span&gt; CacheDependency(&quot;filepath&quot;) 
  DateTime.Now.AddMinutes(&lt;span class=&quot;code-digit&quot;&gt;2&lt;/span&gt;), 
  TimeSpan.Zero, 
  CacheItemPriority.High,
  &lt;span class=&quot;code-keyword&quot;&gt;new&lt;/span&gt; CacheItemRemovedCallback(&lt;span class=&quot;code-keyword&quot;&gt;this&lt;/span&gt;.RemovedCallback)
);&lt;/pre&gt;&lt;pre id=&quot;pre2&quot; lang=&quot;cs&quot; style=&quot;margin-top: 0pt;&quot;&gt;&amp;nbsp;&lt;/pre&gt;&lt;b&gt;dependency and a call back function executed when the cache expires.&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;CacheItemRemovedCallback &lt;/b&gt;&lt;i&gt;is a delegate&lt;/i&gt;, which &lt;u&gt;defines a callback method&lt;/u&gt; for notifying applications when a cached item is removed from the Cache.&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote&gt;e.g. 1.  Insert xml data from a file into the cache, eliminating &lt;/blockquote&gt;&lt;blockquote&gt;the need to read from the file on subsequent requests. &lt;/blockquote&gt;&lt;blockquote&gt;&lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;Cache.Insert(&quot;key&quot;, myXMLFileData, new &lt;/div&gt;&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;System.Web.Caching.CacheDependency(Server.MapPath(&quot;users.xml&quot;)));&lt;/div&gt;&lt;br /&gt;
CacheDependency  ----&amp;gt; ensures that cache immediately expires while files changes  and updated with changes. Similary can happen with array of filenames,  if cached data needs to depend on several files.&lt;br /&gt;
&lt;br /&gt;
e.g. 2. Inserting second piece of data that depends on the existing first piece of data [&quot;key&quot; (say)].&lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;Cache.Insert(&quot;dependentkey&quot;, myDependentData, new &lt;/div&gt;&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;System.Web.Caching.CacheDependency(new string[] {}, new string[] &lt;/div&gt;&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;{&quot;key&quot;}));&lt;/div&gt;&lt;br /&gt;
&lt;/blockquote&gt;&lt;blockquote&gt;&amp;nbsp;  If no key existed in the cache called &quot;key&quot;, or if the item associated   with that key expires or is updated, then the cache entry for   &quot;dependentkey&quot; would expire.&lt;/blockquote&gt;&lt;blockquote&gt;&lt;br /&gt;
&lt;br /&gt;
e.g. 3. Absolute Expiration: &lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;Cache.Insert(&quot;key&quot;, myTimeSensitiveData, null, &lt;/div&gt;&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;DateTime.Now.AddMinutes(1), TimeSpan.Zero);&lt;/div&gt;&lt;br /&gt;
&lt;/blockquote&gt;&lt;blockquote&gt;Caches time sensitive data for one minute, at which point the cache will expire.&lt;/blockquote&gt;&lt;i&gt;Note: absolute expiration and sliding expiration (below) cannot be used together&lt;/i&gt; &lt;br /&gt;
&lt;blockquote&gt;e.g. 4.&amp;nbsp; Sliding Expiration: &lt;/blockquote&gt;&lt;blockquote&gt;&lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;Cache.Insert(&quot;key&quot;, myFrequentlyAccessedData, null, &lt;/div&gt;&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;System.Web.Caching.Cache.NoAbsoluteExpiration, &lt;/div&gt;&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;TimeSpan.FromMinutes(1));&lt;/div&gt;&lt;/blockquote&gt;&lt;br /&gt;
&lt;blockquote&gt;Caches some frequently used data and remain in cache until one minute passes without anything referencing it. &lt;/blockquote&gt;If  anyone references even at 59th second then again time of expiration  become one minute instead of one second that was expected to expire the  data in case it might not referenced during the current minute.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;pre id=&quot;pre2&quot; lang=&quot;cs&quot; style=&quot;margin-top: 0pt;&quot;&gt;&amp;nbsp;&lt;/pre&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/2107101172666988703/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/2107101172666988703' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/2107101172666988703'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/2107101172666988703'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/cache-insert-method.html' title='Cache Insert() Method'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-6589673594350616536</id><published>2011-01-12T21:18:00.000-08:00</published><updated>2011-01-13T21:40:47.658-08:00</updated><title type='text'>ASP.NET Cache</title><content type='html'>Used while sharing data across users based on dependencies and expiration policies.&lt;br /&gt;
Cache values can be accessed using&lt;br /&gt;
Name space&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; -&lt;b&gt;System.Web&lt;/b&gt;&lt;br /&gt;
Class object of -&lt;b&gt; HttpContext &lt;/b&gt;or &lt;b&gt;Page&lt;/b&gt;&lt;br /&gt;
Property&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; - &lt;b&gt;Cache&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
It has the greatest potential impact on an application&#39;s performance&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote style=&quot;background-color: #f3f3f3;&quot;&gt;Tip:&lt;br /&gt;
Cache Early; Cache Often&lt;br /&gt;
&lt;br /&gt;
Implement caching at every layer of your application. Add caching support to the data layer, the business logic layer, and the UI or output layer. Memory is cheap—by implementing caching in an intelligent fashion throughout the application, you can achieve great performance gains.&lt;/blockquote&gt;&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt; &lt;td&gt;Types of dependencies&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;th&gt;Type&lt;/th&gt; &lt;th&gt;Brief Description&lt;/th&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;File dependency&lt;/td&gt; &lt;td&gt;Allows you to invalidate a specific cache item when a disk&lt;br /&gt;
based file or files change.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;Time-based expiration&lt;/td&gt; &lt;td&gt;Allows you to invalidate a specific cache item depending on predefined time.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;Key dependency&lt;/td&gt; &lt;td&gt;Allows you to invalidate a specific cache item depending when another cached item changes.&lt;/td&gt; &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;table&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td&gt;&lt;b&gt; Table 1.&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;h3&gt;&amp;nbsp;&lt;/h3&gt;&lt;h3&gt;Cache Callback&lt;/h3&gt;As cache object is created according to some dependency (ref table 1) and expires or removed while there is change in corresponding dependency and ASP.NET execute/capable to fire a cache callback method corresponding to this removal of object to add the items back in cache.&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;&lt;i&gt;ASP.NET has a full-featured cache engine that can be used by applications to store arbitrary objects in memory. This mechanism is implemented via the Cache class, an instance of which exists for each application configured on a web server. The application cache provides a simple dictionary interface using key/value pairs that enables you to store and retrieve objects from the cache.&lt;/i&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td&gt;Forms of caching&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;  &lt;th&gt;Type&lt;/th&gt;  &lt;th&gt;Advantages&lt;/th&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;page level output caching,&lt;/td&gt;  &lt;td&gt;provides additional flexibility and can be used to take advantage of caching throughout every layer of an application.&lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;user control level output caching (or fragment caching)&lt;/td&gt;  &lt;td rowspan=&quot;2&quot;&gt;advantage of being incredibly simple to implement&lt;/td&gt;   &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;Cache API&lt;/td&gt;  &lt;td&gt;&lt;/td&gt;   &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;&lt;h3&gt;Page Level Output Caching &lt;/h3&gt;&lt;/div&gt;&lt;b&gt;e.g.&lt;/b&gt;&lt;br /&gt;
&lt;div style=&quot;color: black;&quot;&gt;&lt;pre&gt;&amp;lt;%@OutputCache Duration=&quot;60&quot; VaryByParam=&quot;*&quot;%&amp;gt;&lt;pre&gt;&lt;/pre&gt;&lt;/pre&gt;&lt;/div&gt;&lt;br /&gt;
The various types of parameters that can be used in this form of caching is discussed as below:&lt;br /&gt;
&lt;table border=&quot;1&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;            &lt;th&gt;&lt;br /&gt;
Param name  &lt;/th&gt;            &lt;th&gt;&lt;br /&gt;
Description&lt;/th&gt;   &lt;/tr&gt;
&lt;tr&gt;         &lt;td&gt;Duration&lt;/td&gt;         &lt;td&gt;Required. Time, in seconds, the page should be cached. Must be a positive integer.&lt;/td&gt;       &lt;/tr&gt;
&lt;tr&gt;         &lt;td&gt;Location&lt;/td&gt;         &lt;td&gt;Specifies where the output should be cached. If specified, must be one of: Any, Client, Downstream, None, Server or ServerAndClient.&lt;/td&gt;       &lt;/tr&gt;
&lt;tr&gt;         &lt;td&gt;VaryByParam&lt;/td&gt;         &lt;td&gt;Required. The names of the variables in the Request, which should result in, separate cache entries. &quot;none&quot; can be used to specify no variation. &quot;*&quot; can be used to create new cache entries for every different set of variables. Separate variables with &quot;;&quot;.&lt;/td&gt;       &lt;/tr&gt;
&lt;tr&gt;         &lt;td&gt;VaryByHeader&lt;/td&gt;         &lt;td&gt;Varies cache entries based on variations in a specified header.&lt;/td&gt;       &lt;/tr&gt;
&lt;tr&gt;         &lt;td&gt;VaryByCustom&lt;/td&gt;         &lt;td&gt;Allows custom variations to be specified in the global.asax (for example, &quot;Browser&quot;).&lt;/td&gt;       &lt;/tr&gt;
&lt;/tbody&gt;   &lt;/table&gt;&lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;Most situations can be handled with a combination of the required Duration and VaryByParam options. VaryByHeader and VaryByCustom are primarily used to allow customization of the page&#39;s look or content based on the client that is accessing them.&lt;/div&gt;&lt;br /&gt;
&lt;i&gt;In order to enable separate cache entries for each browser, VaryByCustom can be set to a value of &quot;browser&quot;. This functionality is built into the caching module, and will insert separate cached versions of the page for each browser name and major version.&lt;/i&gt;&lt;br /&gt;
&lt;div style=&quot;color: black;&quot;&gt;&lt;pre&gt;&amp;lt;%@ OutputCache Duration=&quot;60&quot; VaryByParam=&quot;None&quot; VaryByCustom=&quot;browser&quot;  %&amp;gt;
&lt;/pre&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;&lt;h3&gt;Fragment Caching, User Control Output Caching&lt;/h3&gt;&lt;/div&gt;&lt;br /&gt;
Fragment caching uses the same syntax as page level output caching, but applied to a user control (.ascx file) instead of to a web form (.aspx file).&lt;br /&gt;
&lt;br /&gt;
In addition to parameters used for page level output caching an additional an OutputCache attribute named &quot;&lt;b&gt;VaryByControl&lt;/b&gt;&quot; is included in fragment caching, which will vary the caching of the user control depending on the value of a member of that control(typically a control on the page, such as a DropDownList).&lt;br /&gt;
&lt;br /&gt;
If VaryByControl is specified, VaryByParam may be omitted.&lt;br /&gt;
&lt;br /&gt;
&lt;i&gt;By default each user control on each page is cached separately. However,  if a user control does not vary between pages in an application and is  named the same across all such pages, the Shared=&quot;true&quot; parameter can be  applied to it, which will cause the cached version(s) of the user  control to be used by all pages referencing that control.&lt;/i&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;e.g. 1. &lt;/b&gt;Separate cache for variation of query string and page containing control.&lt;br /&gt;
&lt;div style=&quot;background-color: #f3f3f3;&quot;&gt;&amp;lt;%@ OutputCache Duration=&quot;60&quot; VaryByParam=&quot;*&quot; %&amp;gt;&lt;/div&gt;&lt;pre&gt;&lt;/pre&gt;&lt;pre&gt;&amp;nbsp;&lt;/pre&gt;&lt;pre&gt;Creates a separate cache for control for 60 sec and created&lt;/pre&gt;&lt;pre&gt;for every variation of query string and page containing control.&lt;/pre&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;e.g. 2.&lt;/b&gt; Separate cache creation with variation of selected value in &lt;br /&gt;
&lt;pre&gt;CountryDropDownList control.&lt;/pre&gt;&lt;span style=&quot;background-color: #f3f3f3;&quot;&gt;&amp;lt;%@ OutputCache Duration=&quot;60&quot; VaryByParam=&quot;none&quot;&amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background-color: #f3f3f3;&quot;&gt;VaryByControl=&quot;CountryDropDownList&quot; %&amp;gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
User control cached for 60 sec and cached for each changed&lt;br /&gt;
value of control &quot;&lt;span style=&quot;background-color: #f3f3f3;&quot;&gt;CountryDropDownList&quot;&lt;/span&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;e.g. 3.&lt;/b&gt;&amp;nbsp; Separate cache creation with each browser name and&lt;br /&gt;
variation of major version&lt;br /&gt;
&lt;pre&gt;&amp;nbsp;&lt;/pre&gt;&lt;pre&gt;&lt;/pre&gt;&lt;pre&gt;&lt;/pre&gt;&lt;pre style=&quot;background-color: #f3f3f3;&quot;&gt;&amp;lt;%@ OutputCache Duration=&quot;60&quot; VaryByParam=&quot;none&quot;&amp;nbsp;&lt;/pre&gt;&lt;pre style=&quot;background-color: #f3f3f3;&quot;&gt;VaryByCustom=&quot;browser&quot; Shared=&quot;true %&amp;gt;&lt;/pre&gt;&lt;pre&gt;&amp;nbsp;&lt;/pre&gt;&lt;pre&gt;&lt;/pre&gt;&lt;pre&gt;Created cache expires after 60 sec which gets created&lt;/pre&gt;&lt;pre&gt;for every change in browser name and major version.&lt;/pre&gt;&lt;pre&gt;&amp;nbsp;&lt;/pre&gt;&lt;pre&gt;The cache entries for each browser would then be &lt;/pre&gt;&lt;pre&gt;shared by all pages referencing this user control (as long&lt;/pre&gt;&lt;pre&gt;as all pages refer to the control with the same ID).

 &lt;/pre&gt;&lt;h3 class=&quot;dtH1&quot; style=&quot;background-color: #f3f3f3;&quot;&gt;Caching API, Using the Cache Object&lt;/h3&gt;&lt;br /&gt;
Using the Cache object, you can store any serializeable data object, and control how that cache entry expires based on a combination of one or more dependencies.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Storing Data in the Cache&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;1.&lt;/b&gt; The simplest way to store data in the Cache is &lt;b&gt;simply to assign it,&lt;/b&gt; using a key, just like a HashTable or Dictionary object:&lt;br /&gt;
&lt;br /&gt;
Cache[&quot;key&quot;] = &quot;value&quot;;&lt;br /&gt;
&lt;br /&gt;
This will store the item in the cache without any dependencies,&lt;br /&gt;
so it will not expire unless the cache engine removes it in order to&lt;br /&gt;
make room for additional cached data.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;2. To include specific cache dependencies&lt;/b&gt;, the Add() or Insert()&lt;br /&gt;
method is used. Each of these has several overloads.&lt;br /&gt;
&lt;br /&gt;
Add()      --&amp;gt; Returns a reference to the cached object and do nothing if&lt;br /&gt;
item with same key already exists&lt;br /&gt;
Insert()   --&amp;gt; Has no return value and overwrite the item if item with &lt;br /&gt;
same key name already exists.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;3. Other Options:&lt;/b&gt; &lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;a.&lt;/b&gt; &lt;b&gt;Specifying the priority of the item&lt;/b&gt; (from low to high to NotRemovable):&amp;nbsp; defined in the &lt;b&gt;System.Web.Caching.CacheItemPriority enumeration&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;b. CacheItemRemovedCallback&lt;/b&gt; option allows some interesting  possibilities.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt; &lt;/b&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/6589673594350616536/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/6589673594350616536' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6589673594350616536'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6589673594350616536'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/aspnet-cache.html' title='ASP.NET Cache'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-1794047034150829581</id><published>2011-01-11T22:40:00.000-08:00</published><updated>2011-01-11T23:01:08.977-08:00</updated><title type='text'>Ajax types most know list</title><content type='html'>&lt;table border=&quot;1&quot; cellpadding=&quot;2&quot; cellspacing=&quot;2&quot;&gt;&lt;tbody&gt;
&lt;tr&gt; &lt;th&gt;AJAX Library Name&lt;/th&gt; &lt;th&gt;Brief Description&lt;/th&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;&lt;b&gt;ASP.NET AJAX Extensions (&quot;Atlas&quot;)&lt;/b&gt;&lt;/td&gt; &lt;td&gt;AJAX functionality for ASP.Net via server components, with auto generated JavaScript and tightly related to server controls.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;&lt;b&gt;AJAXPro&lt;/b&gt;&lt;/td&gt; &lt;td&gt;Ajax for ASP.NET development to create a fully client-side  based and require a few server-side API calls to get/set  data&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;&lt;b&gt;Direct Web Remoting (DWR)&lt;/b&gt;&lt;/td&gt; &lt;td&gt;AJAX solution for Java based web solutions.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;&lt;b&gt;Dojo&lt;/b&gt;&lt;/td&gt; &lt;td&gt;&lt;br /&gt;
&lt;li&gt;Provides a strong abstraction between them and the browser&#39;s DOM&lt;/li&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;li&gt;Provides the most impressive end effects from the least code&lt;/li&gt;&lt;br /&gt;
&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;&lt;b&gt;Google Web Toolkit (GWT)&lt;/b&gt;&lt;/td&gt; &lt;td&gt;For Java based solutions that require to invest more time to get a more robust, easier-to-debug solution&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;&lt;b&gt;Prototype&lt;/b&gt;&lt;/td&gt; &lt;td&gt;&lt;br /&gt;
&lt;li&gt;Client-side development that require minimal abstraction between them and the DOM&lt;/li&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;li&gt;Client-side development that need a library to speed up common DOM manipulation tasks&lt;/li&gt;&lt;br /&gt;
&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt; &lt;td&gt;&lt;b&gt;xAJAX&lt;/b&gt;&lt;/td&gt; &lt;td&gt;For PHP development of all stripes&lt;/td&gt; &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;table border=&quot;0&quot; cellpadding=&quot;4&quot; cellspacing=&quot;0&quot; style=&quot;width: 610px;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt; &lt;td&gt;&lt;span class=&quot;morelink&quot;&gt;&lt;/span&gt;&lt;span class=&quot;smallfont&quot;&gt;Note: There are the strengths and weaknesses of  popular pure JavaScript libraries and a few options offered by the  server-based AJAX libraries.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table border=&quot;1&quot; cellpadding=&quot;2&quot; cellspacing=&quot;2&quot; style=&quot;width: 400px;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;th&gt;AJAX Library Type&lt;/th&gt;     &lt;th&gt;Pros&lt;/th&gt;     &lt;th&gt;Cons&lt;/th&gt; &lt;/tr&gt;
&lt;tr&gt;     &lt;td&gt;&lt;b&gt;Server Based&lt;/b&gt;&lt;/td&gt;     &lt;td&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;li&gt;Have ability to map native server objects such as database results to JavaScript equivalents&lt;/li&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;li&gt;Reduce efforts required to code JavaScript (depending on the library)&lt;/li&gt;&lt;br /&gt;
&lt;/td&gt;     &lt;td&gt;This kind of AJAX library JS code ties tightly to the server language or controls.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt;     &lt;td&gt;&lt;b&gt;Pure JavaScript&lt;/b&gt;&lt;/td&gt;     &lt;td&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;li&gt;Have ability to handle multiple server languages&lt;/li&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;li&gt;&amp;nbsp;Have a clear line of sepration between client and server code&lt;/li&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;/td&gt;     &lt;td&gt;In this kind of library developer has to manage the logic for to manage how to translate server-side return values to XML or JSON.&lt;/td&gt; &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;
&lt;span class=&quot;smallfont&quot;&gt;&amp;nbsp;&lt;/span&gt; &lt;/td&gt; &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/1794047034150829581/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/1794047034150829581' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/1794047034150829581'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/1794047034150829581'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/ajax-types-most-know-list.html' title='Ajax types most know list'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-6508777328824763995</id><published>2011-01-03T23:58:00.000-08:00</published><updated>2011-01-03T23:58:46.146-08:00</updated><title type='text'>A Simple trigger example</title><content type='html'>The below is simplest trigger that execute while any record is inserted in the table  tbl_registrations and while insert operation is complete it displays all the values inserted in the table&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Create trigger tr_MyTrigger1&lt;br /&gt;
ON tbl_registrations&lt;br /&gt;
FOR INSERT&lt;br /&gt;
AS&lt;br /&gt;
Begin&lt;br /&gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; SELECT * FROM Inserted&lt;br /&gt;
End</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/6508777328824763995/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/6508777328824763995' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6508777328824763995'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6508777328824763995'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/simple-trigger-example.html' title='A Simple trigger example'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-5627440815912444292</id><published>2011-01-03T23:56:00.000-08:00</published><updated>2011-01-03T23:56:07.454-08:00</updated><title type='text'>List of procedures as comma seprated string</title><content type='html'>Following is the code that can be used to get&amp;nbsp; list of all procedures having name started with string &#39;Proc&#39; and this returns a single string containing all procedures as comma separated names.&lt;br /&gt;
&lt;br /&gt;
i.e. if there are procedures proc_1 ,proc_2,proc_3 and proc_4 exists in sql server then the returned result will look like&lt;br /&gt;
&lt;br /&gt;
proc_1 ,proc_2,proc_3 , proc_4&lt;br /&gt;
&lt;br /&gt;
Also&amp;nbsp; @listStr variable contains the result that can be used to process this list further according to the requirements.&lt;br /&gt;
&lt;br /&gt;
DECLARE @listStr VARCHAR(MAX)&lt;br /&gt;
select @listStr = COALESCE(@listStr+&#39;,&#39; , &#39;&#39;) + [name]&lt;br /&gt;
FROM sysobjects WHERE type =&#39;P&#39; AND name LIKE &#39;Proc%&#39; AND [name]&amp;nbsp; IS NOT NULL&lt;br /&gt;
SELECT @listStr</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/5627440815912444292/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/5627440815912444292' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/5627440815912444292'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/5627440815912444292'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/list-of-procedures-as-comma-seprated.html' title='List of procedures as comma seprated string'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-6629950417422521263</id><published>2011-01-03T23:51:00.000-08:00</published><updated>2011-01-03T23:51:20.822-08:00</updated><title type='text'>Getting List of added/deleted records in trigger</title><content type='html'>To list of all records that has been added in a table for which trigger executed&lt;br /&gt;
records&lt;br /&gt;
&lt;br /&gt;
SELECT * FROM Inserted&lt;br /&gt;
&lt;br /&gt;
To list of all records that has been deleted in a table for which trigger executed&lt;br /&gt;
records &lt;br /&gt;
&lt;br /&gt;
SELECT * FROM Deleted&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
To list of all records that has been modified but not delete modified in a table for which trigger executed&lt;br /&gt;
records &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
SELECT * FROM Inserted&lt;br /&gt;
EXCEPT&lt;br /&gt;
SELECT * FROM Deleted</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/6629950417422521263/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/6629950417422521263' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6629950417422521263'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/6629950417422521263'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/getting-list-of-addeddeleted-records-in.html' title='Getting List of added/deleted records in trigger'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-4356862358374626126</id><published>2011-01-03T23:48:00.000-08:00</published><updated>2011-01-03T23:48:23.188-08:00</updated><title type='text'>Get List of procedure in SQL Server</title><content type='html'>Select so.name FROM syscolumns sc,master..systypes st,sysobjects so &lt;br /&gt;
WHERE sc.id in (select id from sysobjects where type =&#39;P&#39;)&lt;br /&gt;
&amp;nbsp;AND so.type =&#39;P&#39; &lt;br /&gt;
&amp;nbsp;AND sc.id = so.id &lt;br /&gt;
&amp;nbsp;AND sc.type = st.type&lt;br /&gt;
GROUP BY so.name</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/4356862358374626126/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/4356862358374626126' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/4356862358374626126'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/4356862358374626126'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2011/01/get-list-of-procedure-in-sql-server.html' title='Get List of procedure in SQL Server'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-471853442669257741</id><published>2010-12-01T00:49:00.000-08:00</published><updated>2010-12-01T00:49:44.070-08:00</updated><title type='text'>OOPs Access Modifiers behaviour</title><content type='html'>&lt;table border=&quot;1&quot; cellpadding=&quot;4&quot; cellspacing=&quot;0&quot;&gt;&lt;col width=&quot;50*&quot;&gt;&lt;/col&gt;  &lt;col width=&quot;22*&quot;&gt;&lt;/col&gt;  &lt;col width=&quot;28*&quot;&gt;&lt;/col&gt;  &lt;col width=&quot;20*&quot;&gt;&lt;/col&gt;  &lt;col width=&quot;40*&quot;&gt;&lt;/col&gt;  &lt;col width=&quot;94*&quot;&gt;&lt;/col&gt;  &lt;tbody&gt;
&lt;tr valign=&quot;TOP&quot;&gt;   &lt;td width=&quot;20%&quot;&gt;    &lt;br /&gt;
&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;9%&quot;&gt;    private&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;11%&quot;&gt;    protected&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;8%&quot;&gt;    public&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;16%&quot;&gt;    Internal/friend&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;37%&quot;&gt;    Protected internal/friend&lt;br /&gt;
&lt;/td&gt;  &lt;/tr&gt;
&lt;tr valign=&quot;TOP&quot;&gt;   &lt;td width=&quot;20%&quot;&gt;    By Object&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;9%&quot;&gt;    No&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;11%&quot;&gt;    No&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;8%&quot;&gt;    Yes&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;16%&quot;&gt;    Yes&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;37%&quot;&gt;    No&lt;br /&gt;
&lt;/td&gt;  &lt;/tr&gt;
&lt;tr valign=&quot;TOP&quot;&gt;   &lt;td width=&quot;20%&quot;&gt;    By Derived Class&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;9%&quot;&gt;    No&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;11%&quot;&gt;    Yes&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;8%&quot;&gt;    Yes&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;16%&quot;&gt;    Yes&lt;br /&gt;
&lt;/td&gt;   &lt;td width=&quot;37%&quot;&gt;    Yes (Same Assembly)&lt;br /&gt;
&lt;/td&gt;  &lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/471853442669257741/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/471853442669257741' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/471853442669257741'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/471853442669257741'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2010/12/oops-access-modifiers-behaviour.html' title='OOPs Access Modifiers behaviour'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-3841968553830255371</id><published>2010-11-30T23:21:00.001-08:00</published><updated>2010-12-01T00:18:46.417-08:00</updated><title type='text'>Creating and executing stored procedures [SyBase]</title><content type='html'>http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/42965;pt=42726</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/3841968553830255371/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/3841968553830255371' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/3841968553830255371'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/3841968553830255371'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2010/11/creating-and-executing-stored.html' title='Creating and executing stored procedures [SyBase]'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-2100274732020313345</id><published>2010-11-30T23:01:00.000-08:00</published><updated>2010-11-30T23:01:42.872-08:00</updated><title type='text'>Maximum Capacity Specifications for SQL Server</title><content type='html'>http://msdn.microsoft.com/en-us/library/ms143432.aspx</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/2100274732020313345/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/2100274732020313345' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/2100274732020313345'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/2100274732020313345'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2010/11/maximum-capacity-specifications-for-sql.html' title='Maximum Capacity Specifications for SQL Server'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5697141498182262636.post-152964916696762029</id><published>2010-11-29T03:19:00.000-08:00</published><updated>2010-11-29T03:23:07.608-08:00</updated><title type='text'>Static Variables vs Application Object</title><content type='html'>For having a global variable we can use &lt;b&gt;static variables &lt;/b&gt;&lt;u&gt;as well&lt;/u&gt;&lt;b&gt; application cache&lt;/b&gt;. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Application Object need to be initialized first time into Global.asax.cs  application_start() method and keep alive until a IIS reset or worker  process recycle not occurs. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
1. The cache is thead-safe, i.e.&amp;nbsp; the objects in the cache may not be thread safe, but the cache collection itself is.&lt;br /&gt;
&lt;br /&gt;
e.g.&lt;br /&gt;
&lt;br /&gt;
Application_Start() &lt;br /&gt;
{ &lt;br /&gt;
Application[&quot;globalVar1&quot;]=&quot;Global variable One stored here&quot;; &lt;br /&gt;
Gvar2= &quot;Global Variable Two is here&quot;; &lt;br /&gt;
}&lt;br /&gt;
&lt;br /&gt;
And this can be get anywhere in application by using&lt;br /&gt;
&lt;blockquote&gt;string var1 = (string)Application[&quot;globalVar1&quot;];&amp;nbsp;&lt;/blockquote&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New,Courier,mono;&quot;&gt;&lt;span style=&quot;color: blue; font-family: &amp;quot;Courier New&amp;quot;; font-size: 10pt;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;public class Global          : System.Web.HttpApplication&lt;br /&gt;
{&lt;br /&gt;
public static string StaticTest =&quot;This is the original value&quot;;&lt;br /&gt;
. . .&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;If a static member is named &lt;b&gt;&lt;span style=&quot;font-family: Verdana;&quot;&gt;MyStaticMember&lt;/span&gt;&lt;/b&gt;          in your Global.asax file, you can use &lt;b&gt;&lt;span style=&quot;font-family: Verdana;&quot;&gt;MyClass.MyStaticMember&lt;/span&gt;&lt;/b&gt;          to access it from your page. &amp;nbsp;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: black;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;font-family: Courier New,Courier,mono;&quot;&gt;&lt;span style=&quot;color: blue; font-family: &amp;quot;Courier New&amp;quot;; font-size: 10pt;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Courier New,Courier,mono;&quot;&gt;&lt;span style=&quot;color: blue; font-family: &amp;quot;Courier New&amp;quot;; font-size: 10pt;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;or&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
public static string GVar2; &lt;span style=&quot;font-family: Courier New,Courier,mono;&quot;&gt;&lt;span style=&quot;color: blue; font-family: &amp;quot;Courier New&amp;quot;; font-size: 10pt;&quot;&gt;&lt;span style=&quot;color: blue;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
For using the Gvar2 we need to simply write the className.Gvar2 // Here Global.Gvar2 will do the work for us. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
reading / writing a static reference variable is not (at least not without some additional work).&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
So what factors you must count for choosing static - &lt;br /&gt;
1. Application holds variable as Object. &lt;br /&gt;
2. While getting the value we need to caste into the objects which it stores. Of course casting need some value. &lt;br /&gt;
&amp;nbsp; So when we need to use some primitive variables and they are not going  to changes very frequent (locking issue in case of frequent changes) we  should use static variable. &lt;br /&gt;
Application object need to be used when we need to Hold some objects application wide.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div align=&quot;justify&quot;&gt;Storing and reading a &lt;b&gt;static value is faster&lt;/b&gt; when we  compare it with the Application object because static variables do not  need to look-up in a collection when you refer to them and you do not  need to cast from object to a specific type.  &lt;/div&gt;&lt;div align=&quot;justify&quot;&gt;The key reason that the Application object exists in ASP.NET is for  compatibility with classic ASP code to allow easy migration of existing  applications to ASP.NET.&lt;br /&gt;
&lt;br /&gt;
Also, yes, static variables behave the same way regardless of where they  are loaded from, and exist exactly once per app domain (unless you&#39;re  talking about those labeled [ThreadStatic]) &lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://developmentskills.blogspot.com/feeds/152964916696762029/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5697141498182262636/152964916696762029' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/152964916696762029'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5697141498182262636/posts/default/152964916696762029'/><link rel='alternate' type='text/html' href='http://developmentskills.blogspot.com/2010/11/static-variables-vs-application-object.html' title='Static Variables vs Application Object'/><author><name>jivangoyal</name><uri>http://www.blogger.com/profile/12853371042810428434</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>