<?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-8550043570632565513</id><updated>2026-10-29T03:47:07.698-07:00</updated><category term="sql"/><category term=".net"/><category term="sql server"/><category term="error"/><category term="asp.net"/><category term="c#"/><category term="wpf"/><category term="mvc"/><category term="t-sql"/><category term="tables"/><category term=".net framework 4.0"/><category term="wcf"/><category term="database"/><category term="sql server 2008"/><category term="easy"/><category term="mvc3"/><category term="sql server 2005"/><category term="web service"/><category term="Unit Testing"/><category term="browsers"/><category term="console"/><category term="decryption"/><category term="encryption"/><category term="entity framework"/><category term="errors"/><category term="sql server 2008 r2"/><category term="tutorial"/><category term="vb.net"/><category term="vs 2010"/><category term="web developer"/><category term="webconfig"/><category term="Generic List"/><category term="SharePoint"/><category term="app.config"/><category term="columns"/><category term="connection string"/><category term="css"/><category term="debugging"/><category term="deploy"/><category term="div"/><category term="entity framework 4.0"/><category term="function"/><category term="hexadecimal"/><category term="identity seed"/><category term="image"/><category term="insert"/><category term="javascript"/><category term="join"/><category term="mvvm"/><category term="null values"/><category term="performance"/><category term="public key"/><category term="razor"/><category term="security"/><category term="session"/><category term="sql jobs"/><category term="sql server 2000"/><category term="ssis"/><category term="string"/><category term="styles"/><category term="tips"/><category term="vb6"/><category term="visual studio"/><category term="web forms"/><category term="websphere mq"/><category term="windows server"/><category term="windows workflow foundation"/><category term=".NET Core"/><category term=".net framework 3.0"/><category term="ASP.NET API"/><category term="ActionLink"/><category term="AppFabric"/><category term="DTS"/><category term="Github"/><category term="InstallShield"/><category term="Internet Explorer"/><category term="LinQ"/><category term="RESTful service"/><category term="SoapUI"/><category term="TextboxFor"/><category term="WF4"/><category term="abstract class"/><category term="attach to process"/><category term="back"/><category term="bids 2008"/><category term="bulk insert"/><category term="caching"/><category term="changes"/><category term="code first"/><category term="commandargument"/><category term="commercial"/><category term="concurrency"/><category term="conditional statement"/><category term="connectivity"/><category term="control"/><category term="conversion"/><category term="convert"/><category term="copy database"/><category term="copy records"/><category term="create"/><category term="crystal report"/><category term="database version"/><category term="datatypes"/><category term="datet format"/><category term="declaration"/><category term="difficult"/><category term="display authorizations"/><category term="enums"/><category term="events"/><category term="excel file"/><category term="extension method"/><category term="failover"/><category term="foreign key"/><category term="gridview"/><category term="iis"/><category term="image button"/><category term="immediate window"/><category term="info"/><category term="inheritance"/><category term="intellisense"/><category term="interface"/><category term="introduction"/><category term="ip address"/><category term="jquery"/><category term="keys"/><category term="lectures"/><category term="license"/><category term="link files"/><category term="local user"/><category term="log file"/><category term="login"/><category term="mapping"/><category term="mask"/><category term="masking"/><category term="medium"/><category term="memory leak"/><category term="merge"/><category term="navigation"/><category term="online conversion"/><category term="oop"/><category term="opinion"/><category term="optimization"/><category term="password"/><category term="pgp"/><category term="ping"/><category term="pivot"/><category term="polymorphism"/><category term="pop quiz"/><category term="primary key"/><category term="printing"/><category term="private key"/><category term="programmers"/><category term="project reference"/><category term="putty"/><category term="puttygen"/><category term="query"/><category term="rand()"/><category term="refresh image"/><category term="regex"/><category term="regsitry"/><category term="regular expression"/><category term="reset"/><category term="rules"/><category term="save records"/><category term="sayings"/><category term="select"/><category term="selected row"/><category term="set authorizations"/><category term="sftp"/><category term="sql injection"/><category term="ssh"/><category term="ssh.net"/><category term="starters"/><category term="state management"/><category term="stored procedures"/><category term="strategies"/><category term="surrogate key"/><category term="telnet"/><category term="text"/><category term="text format"/><category term="tool"/><category term="trace route"/><category term="translate"/><category term="translator"/><category term="truncate"/><category term="update"/><category term="version error"/><category term="versioning"/><category term="videos"/><category term="view jobs"/><category term="viewstate"/><category term="vs 2008"/><category term="web designer"/><category term="windows server 2000"/><category term="windows server 2003"/><category term="word6"/><category term="wordbasic"/><category term="workflow service"/><category term="xml"/><title type='text'>One Happy Coder</title><subtitle type='html'>In this blog, I will share with you my experiences in programming and on how to do stuff the best way.&#xa;&#xa;Happy coding!!!</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default?start-index=26&amp;max-results=25&amp;redirect=false'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>113</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-1789998253860566453</id><published>2026-03-23T21:55:00.000-07:00</published><updated>2026-03-23T21:55:33.874-07:00</updated><title type='text'>New Home</title><content type='html'>&lt;p&gt;&amp;nbsp;So I moved already to a new platform. Not sure how it will be but it&#39;s worth a try.&lt;/p&gt;&lt;p&gt;You can visit my blogs here.&lt;br /&gt;&lt;a href=&quot;https://medium.com/@ryan.aimel.estandarte&quot;&gt;https://medium.com/@ryan.aimel.estandarte&lt;/a&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/1789998253860566453/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/1789998253860566453' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1789998253860566453'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1789998253860566453'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2026/03/new-home.html' title='New Home'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-93750230329834004</id><published>2026-03-03T13:06:00.000-08:00</published><updated>2026-03-03T13:08:42.315-08:00</updated><title type='text'>.NET Core...to the Core</title><content type='html'>&lt;p&gt;This was going on my head when I was planning the title of this blog...&lt;/p&gt;
&lt;p&gt;&lt;iframe allow=&quot;accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share&quot; allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;315&quot; referrerpolicy=&quot;strict-origin-when-cross-origin&quot; src=&quot;https://www.youtube.com/embed/SgGK93iiQ6E?si=nTfd-3hEkxePEp2l&quot; title=&quot;YouTube video player&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;&lt;/p&gt;
&lt;p&gt;Kidding aside, I mentioned earlier (or maybe not) that most of my career was focused on .NET Framework--all my 17 years as a .NET developer. However, I have a knack for learning new technologies because I don&#39;t want to be irrelevant. Thus, I started exploring about .NET Core while I was still working in Malaysia.&lt;/p&gt;&lt;p&gt;So what is .NET Core (now simply called as .NET)? From their &lt;a href=&quot;https://dotnet.microsoft.com/en-us/&quot; target=&quot;_blank&quot;&gt;website&lt;/a&gt;, it mentions this:&lt;/p&gt;&lt;p&gt;&lt;/p&gt;&lt;blockquote&gt;&lt;i&gt;&lt;span style=&quot;color: #666666;&quot;&gt;.NET is the free, open-source, cross-platform framework for building modern apps and powerful cloud services.&lt;/span&gt;&lt;/i&gt;&lt;/blockquote&gt;&lt;p&gt;&lt;/p&gt;&lt;blockquote&gt;&lt;p&gt;&lt;/p&gt;&lt;/blockquote&gt;&lt;p&gt;This new platform, Microsoft has provided a number of promises. Here are some of them.&lt;/p&gt;&lt;p&gt;&lt;b&gt;Open Source Development&lt;/b&gt;&lt;/p&gt;&lt;p&gt;Personally, this has long been coming where .NET has jumped into the open-source environment as they have been losing so much in terms of revenue because they have been focused so much in licensing that developers would want to develop applications freely. Moreover, this has encouraged other developers in the community to contribute to the further development of the product.&lt;/p&gt;&lt;p&gt;&lt;b&gt;Cross-Platform Support&lt;/b&gt;&lt;/p&gt;&lt;p&gt;Back in the day, .NET applications only relied on Windows Server in order to make the applications run. However since the emergence of different servers and computers like Linux and macOS, especially with the emergence of the cloud where they are &quot;mostly free&quot;, Microsoft have to jump ship in order to support such applications. By doing so, they have been able to support these servers and machines thus giving developers a wider range of options based on their comfort level.&lt;/p&gt;&lt;p&gt;&lt;b&gt;Modular and Lightweight Architecture&lt;/b&gt;&lt;/p&gt;&lt;p&gt;Since the birth of .NET Framework 1.0, it has grown into a steady pace that it became a monolyth of libraries which are not being used by developers. With the emergence of .NET Core, what you get initially is the core libraries that you need (thus, .NET Core), and if you need something like Entity Framework, or JWT Tokens, you have to install them via Nuget packages.&lt;/p&gt;&lt;p&gt;So can I easily switch from .NET Framework to .NET Core? Yes because it is seamless and you&#39;re familiar with the different stuff there. The look and feel is the same, the internals are different. If there&#39;s anything that needs to be learned, it&#39;s configuring your application in the Program.cs file where everything starts, and that includes Dependency Injections and Microservices (if you need one). I&#39;ll explain each of them in the succeeding blogposts.&lt;/p&gt;&lt;p&gt;To learn more, you can listen to this video by Tim Corey:&lt;/p&gt;&lt;p&gt;
&lt;iframe width=&quot;560&quot; height=&quot;315&quot; src=&quot;https://www.youtube.com/embed/79UWvR734wI?si=F8L6bWR3HRzCuyx_&quot; title=&quot;YouTube video player&quot; frameborder=&quot;0&quot; allow=&quot;accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share&quot; referrerpolicy=&quot;strict-origin-when-cross-origin&quot; allowfullscreen&gt;&lt;/iframe&gt;
&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/93750230329834004/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/93750230329834004' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/93750230329834004'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/93750230329834004'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2026/03/net-coreto-core.html' title='.NET Core...to the Core'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/SgGK93iiQ6E/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-1929653712716739691</id><published>2026-02-28T08:59:00.000-08:00</published><updated>2026-02-28T08:59:52.724-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".NET Core"/><category scheme="http://www.blogger.com/atom/ns#" term="ASP.NET API"/><category scheme="http://www.blogger.com/atom/ns#" term="entity framework"/><category scheme="http://www.blogger.com/atom/ns#" term="Github"/><title type='text'>What&#39;s up with me lately</title><content type='html'>&lt;p&gt;&amp;nbsp;Hmm..&amp;nbsp;&lt;/p&gt;&lt;p&gt;So what&#39;s up with me lately?&lt;/p&gt;&lt;p&gt;Many things have happened since my last blogpost and I&#39;ve totally abandoned this.&lt;/p&gt;&lt;p&gt;I&#39;ve learned a lot since my time in Malaysia for 11 years and left that beautiful country with very happy memories (sniff... sniff...)&lt;/p&gt;&lt;p&gt;I&#39;ve slowly migrated to using .NET Core (finally) when I arrived here in the US.&lt;/p&gt;&lt;div&gt;And I&#39;ve been let go of the company because it didn&#39;t have any projects coming in because of the government shutdown (booo....). That&#39;s why I now started building my portfolio in order to show employers that despite I don&#39;t have any working experience with many new technologies, I can still catch up with them.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;And that&#39;s the reason why I resurrected this blog, thanks to Tim Corey and his video. You can watch it here:&amp;nbsp;
&lt;/div&gt;
&lt;div&gt;
  &lt;iframe allow=&quot;accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share&quot; allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;315&quot; referrerpolicy=&quot;strict-origin-when-cross-origin&quot; src=&quot;https://www.youtube.com/embed/ollC4DDKTUk?si=8WoDhs3aLG5lpiL2&quot; title=&quot;YouTube video player&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;
&lt;/div&gt;&lt;div&gt;(if the embedded video does not work, you can watch it here:&amp;nbsp;&lt;a href=&quot;https://youtu.be/ollC4DDKTUk?si=oVm0ubWg_Cakv423&quot; target=&quot;_blank&quot;&gt;https://youtu.be/ollC4DDKTUk?si=oVm0ubWg_Cakv423&lt;/a&gt;)&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;So, this is my portfolio (&lt;a href=&quot;https://github.com/Musikero31/CasaAsa&quot; target=&quot;_blank&quot;&gt;Casa Asa Bakeshop Et. Al&lt;/a&gt;) which I worked on since December 2025. This was originally the business of our friend during the Covid pandemic where my wife automated the process and made it into an online food ordering system.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;What does this do?&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Basically, it&#39;s an ordering system where the users order food in the website and it will be delivered in your doorstep. Payment is done online where the user will upload their receipt before it is sent to their doorstep.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Development is still underway wherein some of the parts here will use some mock API links for delivery and payment gateways. But as I code and learn new things, I&#39;ll try to document my learnings here.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;The architecture that is used here is kinda of a Clean Architecture. When I say kinda is because I think this is not a purist kind of Clean Architecture.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;The tools that I used here and will use here are the following (which I will document and write a blogpost on)&lt;/div&gt;&lt;div&gt;&lt;ul style=&quot;text-align: left;&quot;&gt;&lt;li&gt;JWT Token&lt;/li&gt;&lt;li&gt;.NET Core and Dependency Injection&lt;/li&gt;&lt;li&gt;ASP.NET API&lt;/li&gt;&lt;li&gt;Entity Framework Code First&lt;/li&gt;&lt;li&gt;Svelt or React (or maybe Angular)&lt;/li&gt;&lt;li&gt;Github&lt;/li&gt;&lt;li&gt;Html Agility Pack&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;I think that&#39;s all for now. Hopefully I can document these things as I go so that I have something to look back to again when I need something.&lt;/div&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/1929653712716739691/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/1929653712716739691' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1929653712716739691'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1929653712716739691'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2026/02/whats-up-with-me-lately.html' title='What&#39;s up with me lately'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://img.youtube.com/vi/ollC4DDKTUk/default.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-5892705714036427931</id><published>2015-01-15T23:04:00.001-08:00</published><updated>2015-01-15T23:04:45.251-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".net"/><category scheme="http://www.blogger.com/atom/ns#" term="deploy"/><category scheme="http://www.blogger.com/atom/ns#" term="InstallShield"/><title type='text'>Deploying Application using InstallShield Light</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://www.quickmeme.com/img/27/27b2a133427236b57181ebb0337bf2e8214394838fe1f9a66097b81ca476ad49.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;http://www.quickmeme.com/img/27/27b2a133427236b57181ebb0337bf2e8214394838fe1f9a66097b81ca476ad49.jpg&quot; height=&quot;246&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
In my previous &lt;a href=&quot;http://onehappycoder.blogspot.com/2011/10/deploying-your-wpf-application.html?q=setup&quot; target=&quot;_blank&quot;&gt;post&lt;/a&gt;, I shared with you how to deploy your applications in WPF. Apparently, this does not apply only to WPF but to all applications. Also, this also applies to those using Visual Studio 2010 and below.&lt;br /&gt;
&lt;br /&gt;
When using Visual Studio 2012, most of you (including myself) will be surprised as to why there is no Setup project and that you only have InstallShield available. Sadly, starting with Visual Studio 2012, they will not support the basic Setup project (insert angry comments here). Jason Shuler mentioned in his &lt;a href=&quot;http://www.shulerent.com/2012/08/20/looking-for-setup-projects-in-visual-studio-2012/&quot; target=&quot;_blank&quot;&gt;blog entry&lt;/a&gt;&amp;nbsp;when he asked during the TechEd 2012 as to why they removed it. The reply was that &quot;WiX Toolset is the &#39;&lt;i&gt;future&lt;/i&gt;&#39; of setup projects in Visual Studio&quot;. You can read some of their replies in these links:&lt;br /&gt;
&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;&lt;a href=&quot;https://visualstudio.uservoice.com/forums/121579-visual-studio/suggestions/3041773-bring-back-the-basic-setup-and-deployment-project&quot; target=&quot;_blank&quot;&gt;Bring back the basic setup and deployment project&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://blogs.msdn.com/b/buckh/archive/2011/03/17/visual-studio-setup-projects-vdproj-will-not-ship-with-future-versions-of-vs.aspx&quot; target=&quot;_blank&quot;&gt;Visual Studio setup projects (vdproj) will not ship with future versions of VS (Buck Hodges)&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://blogs.synergex.com/psg_blog/2012/06/13/microsoft-removes-installer-project-templates-from-visual-studio-2012/&quot; target=&quot;_blank&quot;&gt;Microsoft Removes Installer Project Templates from Visual Studio 2012 (Steve Ives)&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
So, moving forward, I&#39;ve managed to find the a simple tutorial as to how to use the InstallShield Lite. Below is the video to do it. I hope this will be helpful&lt;br /&gt;
&lt;br /&gt;
Happy coding!!!&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;315&quot; src=&quot;//www.youtube.com/embed/Mgu0y34HsVM&quot; width=&quot;560&quot;&gt;&lt;/iframe&gt;&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/5892705714036427931/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/5892705714036427931' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/5892705714036427931'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/5892705714036427931'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2015/01/deploying-application-using.html' title='Deploying Application using InstallShield Light'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-3783559150272364697</id><published>2014-11-25T03:28:00.001-08:00</published><updated>2014-11-25T03:28:22.968-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="link files"/><category scheme="http://www.blogger.com/atom/ns#" term="versioning"/><title type='text'>How to have one version per project</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://www.quickmeme.com/img/62/6272cebc51b850cb81f355d074a14e5eb90350ce032ef35864a589fc2cd628bc.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;http://www.quickmeme.com/img/62/6272cebc51b850cb81f355d074a14e5eb90350ce032ef35864a589fc2cd628bc.jpg&quot; height=&quot;212&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
I had an experience before where I need to see the version numbers of the application and DLLs which I built. However, it would entail that I would have to open every project and modify the version numbers. It was so tiring and I got lazy doing this.&lt;br /&gt;
&lt;br /&gt;
However, I found out that you can just have one assembly info and just share it with the rest of the projects inside the solution, and this is possible through the use of &lt;b&gt;Link Files. &lt;/b&gt;Having this would reduce the time I would do to open all the assembly info files and updating every single file per project.&lt;br /&gt;
&lt;b&gt;&lt;br /&gt;
&lt;/b&gt; It is easy to do. For example you have this solution.&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxiZVCqK2r0hJgv0RAGsrhD9CEVu7UGhb4jcU7Fk3UY3mtBkHqVSe5P6rmfCIwxbJDobQ9SFdv4pxly8ZtxUUhCRsMyfmOsbkrQuxlxAk8ygZ8Zj5OJz0MOZls1Mgjkv2ZlJ0xiUjnzTQ/s1600/blog+11-25-2014+7-07-15+PM.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxiZVCqK2r0hJgv0RAGsrhD9CEVu7UGhb4jcU7Fk3UY3mtBkHqVSe5P6rmfCIwxbJDobQ9SFdv4pxly8ZtxUUhCRsMyfmOsbkrQuxlxAk8ygZ8Zj5OJz0MOZls1Mgjkv2ZlJ0xiUjnzTQ/s1600/blog+11-25-2014+7-07-15+PM.png&quot; height=&quot;400&quot; width=&quot;170&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Below are the steps to do this:&lt;br /&gt;
1. Create a new folder in the solution and name it &lt;i&gt;Shared Items. &lt;/i&gt;&amp;nbsp;Add new class and name it &quot;SharedAssemblyInfo.cs&quot;. Then copy the contents from one of the assembly files and paste it in the &quot;SharedAssemblyInfo.cs&quot;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgILUSOXEnZA8wLgxtWeYfmEwdL0H1fu85Hq0Mh-645CRx0HangfOpsBqxwKGF8q2fgWABib_EsWzW_1fmCcn0nT6KlvVvypVbLxHjcwk447XtV7NbYwn9-Vwm9jkTP5K4b0r00c6WQ89w/s1600/blog+11-25-2014+7-10-08+PM.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgILUSOXEnZA8wLgxtWeYfmEwdL0H1fu85Hq0Mh-645CRx0HangfOpsBqxwKGF8q2fgWABib_EsWzW_1fmCcn0nT6KlvVvypVbLxHjcwk447XtV7NbYwn9-Vwm9jkTP5K4b0r00c6WQ89w/s1600/blog+11-25-2014+7-10-08+PM.png&quot; height=&quot;204&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
2. In the &lt;i&gt;SharedAssemblyInfo.cs &lt;/i&gt;remove everything except the following:&lt;br /&gt;
&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Assembly Company&lt;/li&gt;
&lt;li&gt;Assembly Copyright&lt;/li&gt;
&lt;li&gt;ComVisible&lt;/li&gt;
&lt;li&gt;AssemblyVersion&lt;/li&gt;
&lt;li&gt;AssemblyFileVersion&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
Do the opposite in the other assembly files&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRquPfR5z5mzeb3BUHN9WHsXlKlWWsn_UHMQzEoPH-1oM1l-Qs3Mas3bdiiUC_0L9rIn2KMAeztc5yTzsnxggVRPjdT4TezHSNpOIhSQvxzHnJx10zL-vwwekwtJ-v0uImxgkNz9wIDww/s1600/blog+11-25-2014+7-17-43+PM.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRquPfR5z5mzeb3BUHN9WHsXlKlWWsn_UHMQzEoPH-1oM1l-Qs3Mas3bdiiUC_0L9rIn2KMAeztc5yTzsnxggVRPjdT4TezHSNpOIhSQvxzHnJx10zL-vwwekwtJ-v0uImxgkNz9wIDww/s1600/blog+11-25-2014+7-17-43+PM.png&quot; height=&quot;178&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
3. Select one project (for example &quot;Framework&quot;), right-click then select &quot;Add &amp;gt; Existing Item&quot;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwg7jBmP2iWHfgWiL4t5EfnDMNie1V8RgFN_7SW8AM7mqAfSpQ7-7-iBJ0ujISPnpilngWXzn46ouTN0OPL9d9HCFwT65m155CoRHpxf17s121E6mmah8_eGC3ZxQrK1toWzuyLNlyfDk/s1600/blog+11-25-2014+7-21-33+PM.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwg7jBmP2iWHfgWiL4t5EfnDMNie1V8RgFN_7SW8AM7mqAfSpQ7-7-iBJ0ujISPnpilngWXzn46ouTN0OPL9d9HCFwT65m155CoRHpxf17s121E6mmah8_eGC3ZxQrK1toWzuyLNlyfDk/s1600/blog+11-25-2014+7-21-33+PM.png&quot; height=&quot;174&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
4. Point to the &lt;i&gt;SharedAssemblyInfo.cs&lt;/i&gt;, then click the drop-down box beside the &quot;Add&quot; and select &quot;Add as link&quot;.&amp;nbsp;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3eEX4dqTA7b7GyQ_UZjWinTBXhJSewLpztUE56L_it_l-YYiE-OVj05mYnIRWV7aA-wCKGd60vVDZpsJEvGWMXYjc-sqWuYLBrR_oyVjI5uq6rxfhRPTdhoWrtl9Dc1B6aKKBNUjWvjY/s1600/blog+11-25-2014+7-24-16+PM.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3eEX4dqTA7b7GyQ_UZjWinTBXhJSewLpztUE56L_it_l-YYiE-OVj05mYnIRWV7aA-wCKGd60vVDZpsJEvGWMXYjc-sqWuYLBrR_oyVjI5uq6rxfhRPTdhoWrtl9Dc1B6aKKBNUjWvjY/s1600/blog+11-25-2014+7-24-16+PM.png&quot; height=&quot;277&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
Then there you have it! You have a shared assembly for one project. Don&#39;t forget to move the linked file to the Properties folder.&amp;nbsp;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP0-ir9ZlTTcvdC1XdJ9pOILT2av28kr7Gzl6tAzkxO4U8S2tD0UvKGIRt5D1ePPAfP9ve-rcgZgdRaRG0wwX46M7qDZuA0UDDijfoTOjiV57FvgwG5IGgEi7K7vAMBt1yHDWl8mwmgQA/s1600/blog+11-25-2014+7-26-57+PM.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP0-ir9ZlTTcvdC1XdJ9pOILT2av28kr7Gzl6tAzkxO4U8S2tD0UvKGIRt5D1ePPAfP9ve-rcgZgdRaRG0wwX46M7qDZuA0UDDijfoTOjiV57FvgwG5IGgEi7K7vAMBt1yHDWl8mwmgQA/s1600/blog+11-25-2014+7-26-57+PM.png&quot; height=&quot;228&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Do it for the rest of the projects and you can synchronize the file version across all projects.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
I hope this helps! Happy coding!!!&lt;/div&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/3783559150272364697/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/3783559150272364697' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/3783559150272364697'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/3783559150272364697'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2014/11/how-to-have-one-version-per-project.html' title='How to have one version per project'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjxiZVCqK2r0hJgv0RAGsrhD9CEVu7UGhb4jcU7Fk3UY3mtBkHqVSe5P6rmfCIwxbJDobQ9SFdv4pxly8ZtxUUhCRsMyfmOsbkrQuxlxAk8ygZ8Zj5OJz0MOZls1Mgjkv2ZlJ0xiUjnzTQ/s72-c/blog+11-25-2014+7-07-15+PM.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-1352875399084248918</id><published>2014-09-25T02:19:00.003-07:00</published><updated>2014-09-25T02:19:46.682-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="RESTful service"/><category scheme="http://www.blogger.com/atom/ns#" term="SoapUI"/><category scheme="http://www.blogger.com/atom/ns#" term="Unit Testing"/><category scheme="http://www.blogger.com/atom/ns#" term="wcf"/><category scheme="http://www.blogger.com/atom/ns#" term="web service"/><title type='text'>Introduction to SoapUI</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://cdn.meme.li/instances/250x250/54384059.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;http://cdn.meme.li/instances/250x250/54384059.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
DISCLAIMER: This will just be a small introduction on how to use SoapUI. I will improve on this blog post once I learn more on how to use this. But for now, I&#39;ll just post on what I know...&lt;br /&gt;
&lt;br /&gt;
--------------------------------------&lt;br /&gt;
Below are the steps on how to use SoapUI when dealing with web services and RESTful services&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen=&quot;&quot; frameborder=&quot;0&quot; height=&quot;355&quot; marginheight=&quot;0&quot; marginwidth=&quot;0&quot; scrolling=&quot;no&quot; src=&quot;//www.slideshare.net/slideshow/embed_code/23181965&quot; style=&quot;border-width: 1px; border: 1px solid #CCC; margin-bottom: 5px; max-width: 100%;&quot; width=&quot;425&quot;&gt; &lt;/iframe&gt; &lt;br /&gt;
&lt;div style=&quot;margin-bottom: 5px;&quot;&gt;
&lt;strong&gt; &lt;a href=&quot;https://www.slideshare.net/romsoft/how-to-test-23181965&quot; target=&quot;_blank&quot; title=&quot;How to Test Web Services Using SOAP UI&quot;&gt;How to Test Web Services Using SOAP UI&lt;/a&gt; &lt;/strong&gt; from &lt;strong&gt;&lt;a href=&quot;https://www.slideshare.net/romsoft&quot; target=&quot;_blank&quot;&gt;ROMSOFT SRL&lt;/a&gt;&lt;/strong&gt; &lt;/div&gt;
&lt;br /&gt;
You can download the free software and get more information here:&lt;br /&gt;
&lt;a href=&quot;http://www.soapui.org/&quot; target=&quot;_blank&quot;&gt;http://www.soapui.org/&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Happy coding...and testing!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/1352875399084248918/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/1352875399084248918' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1352875399084248918'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1352875399084248918'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2014/09/introduction-to-soapui.html' title='Introduction to SoapUI'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-2610433062619056863</id><published>2014-08-05T20:29:00.002-07:00</published><updated>2014-08-05T20:30:40.299-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="foreign key"/><category scheme="http://www.blogger.com/atom/ns#" term="sql server"/><title type='text'>Updating tables with Foreign Key Constraints</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://www.quickmeme.com/img/b4/b4031aefeb1e86e19c96c77901c6cf4cbf62b0e040dc49b8c855fc5e79c888ae.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;http://www.quickmeme.com/img/b4/b4031aefeb1e86e19c96c77901c6cf4cbf62b0e040dc49b8c855fc5e79c888ae.jpg&quot; height=&quot;275&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Had an encounter wherein I need to update the tables but I was not able to do it because of the foreign key constraints. Good thing was that I found this code and it solved my problem.&lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotJGd4cbW_09uXZ-0uBmxQi6gad2Q1VZr8qrfNdSwXhQfy3WLEEwhCjOSB0Cmv3_G0wz6KYuHfdXZ8KrrDTx-WI_SkFi8Y8MUBT_bWqcrMnUWgyH19DVI2MYbuwHocVDIG0GGwtxDMxk1/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;&quot;&gt;&lt;code style=&quot;color: black; word-wrap: normal;&quot;&gt; -- Disable FK Constraint  
 ALTER TABLE emp NOCHECK CONSTRAINT fk_dept_d_fk  
 -- Perform UPDATE  
 UPDATE dept SET d_id=3 WHERE d_id=2  
 UPDATE emp SET d_fk=3 WHERE d_fk=2  
 -- Enable FK Constraint  
 ALTER TABLE emp WITH CHECK CHECK CONSTRAINT fk_dept_d_fk  
 -- Following SELECTS will show the new values in updated records:  
 SELECT * from dept  
&lt;/code&gt;&lt;/pre&gt;
&lt;br /&gt;
What this code does what to temporarily remove the checking of the foreign key so you can change the data and then set it back again.&lt;br /&gt;
&lt;br /&gt;
I hope this helps!&lt;br /&gt;
&lt;br /&gt;
Happy coding!!&lt;br /&gt;
&lt;br /&gt;
&lt;hr /&gt;
&lt;b&gt;&lt;i&gt;Source:&amp;nbsp;&lt;a href=&quot;http://sqlwithmanoj.com/2010/12/21/update-statement-conflicted-with-the-reference-constraint/&quot; target=&quot;_blank&quot;&gt;UPDATE statement conflicted with the REFERENCE constraint by Manoj Pandey&lt;/a&gt;&lt;/i&gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/2610433062619056863/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/2610433062619056863' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/2610433062619056863'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/2610433062619056863'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2014/08/updating-tables-with-foreign-key.html' title='Updating tables with Foreign Key Constraints'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-1247517397891213047</id><published>2014-04-09T02:17:00.001-07:00</published><updated>2014-04-09T02:17:52.287-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="visual studio"/><title type='text'>Track active file in solution explorer [Visual Studio]</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
A friend of mine asked me as to how to set the active item in Visual Studio. He said this because before it is working but not any more.&lt;br /&gt;
&lt;br /&gt;
So after checking, I found out that the &quot;Track Active Item in Solution Explorer&quot; was unticked.&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV5jSXGDxiLJnPRtBGKzbfvHUJ0Ceb7wLF8zAxA4HxQLES-WKChcBV00wawceG1JX48ru7YpMPcFn6JYmkX8AoeSqGteLL8qR2s9hHvmuIIFW_lhE5d3SW9iw_8ujyDbmTlCnXqFP2vYM/s1600/active+item.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV5jSXGDxiLJnPRtBGKzbfvHUJ0Ceb7wLF8zAxA4HxQLES-WKChcBV00wawceG1JX48ru7YpMPcFn6JYmkX8AoeSqGteLL8qR2s9hHvmuIIFW_lhE5d3SW9iw_8ujyDbmTlCnXqFP2vYM/s1600/active+item.png&quot; height=&quot;238&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
So, after clicking this, everything was back to normal. Probably, he accidentally unticked this one.&lt;br /&gt;
&lt;br /&gt;
Hope this helps!&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/1247517397891213047/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/1247517397891213047' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1247517397891213047'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1247517397891213047'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2014/04/track-active-file-in-solution-explorer.html' title='Track active file in solution explorer [Visual Studio]'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgV5jSXGDxiLJnPRtBGKzbfvHUJ0Ceb7wLF8zAxA4HxQLES-WKChcBV00wawceG1JX48ru7YpMPcFn6JYmkX8AoeSqGteLL8qR2s9hHvmuIIFW_lhE5d3SW9iw_8ujyDbmTlCnXqFP2vYM/s72-c/active+item.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-1846857197325193803</id><published>2014-01-26T19:53:00.001-08:00</published><updated>2014-01-26T19:53:29.063-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".net framework 4.0"/><category scheme="http://www.blogger.com/atom/ns#" term="concurrency"/><category scheme="http://www.blogger.com/atom/ns#" term="wcf"/><title type='text'>WCF Concurrency (Single, Multiple, and Reentrant) and Throttling</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
I just want to share with you this video regarding WCF Concurrency&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;!-- copy and paste. Modify height and width if desired. --&gt;&lt;br /&gt;
&lt;object data=&quot;http://content.screencast.com/users/Shivkoi/folders/Default/media/92f7f313-9b1f-47f9-b99e-b9e098263da3/mp4h264player.swf&quot; height=&quot;360&quot; id=&quot;scPlayer&quot; type=&quot;application/x-shockwave-flash&quot; width=&quot;640&quot;&gt;
&lt;param name=&quot;movie&quot; value=&quot;http://content.screencast.com/users/Shivkoi/folders/Default/media/92f7f313-9b1f-47f9-b99e-b9e098263da3/mp4h264player.swf&quot; /&gt;&lt;param name=&quot;quality&quot; value=&quot;high&quot; /&gt;&lt;param name=&quot;bgcolor&quot; value=&quot;#FFFFFF&quot; /&gt;&lt;param name=&quot;flashVars&quot; value=&quot;thumb=http://content.screencast.com/users/Shivkoi/folders/Default/media/92f7f313-9b1f-47f9-b99e-b9e098263da3/FirstFrame.jpg&amp;containerwidth=640&amp;containerheight=360&amp;content=http://content.screencast.com/users/Shivkoi/folders/Default/media/92f7f313-9b1f-47f9-b99e-b9e098263da3/HowcanweimplementSSLsecurity.mp4&amp;blurover=false&quot; /&gt;&lt;param name=&quot;allowFullScreen&quot; value=&quot;true&quot; /&gt;&lt;param name=&quot;scale&quot; value=&quot;showall&quot; /&gt;&lt;param name=&quot;allowScriptAccess&quot; value=&quot;always&quot; /&gt;&lt;param name=&quot;base&quot; value=&quot;http://content.screencast.com/users/Shivkoi/folders/Default/media/92f7f313-9b1f-47f9-b99e-b9e098263da3/&quot; /&gt;&lt;iframe type=&quot;text/html&quot; frameborder=&quot;0&quot; scrolling=&quot;no&quot; style=&quot;overflow:hidden;&quot; src=&quot;http://www.screencast.com/users/Shivkoi/folders/Default/media/92f7f313-9b1f-47f9-b99e-b9e098263da3/embed&quot; height=&quot;360&quot; width=&quot;640&quot; &gt;&lt;/iframe&gt;
&lt;/object&gt; 
&lt;br /&gt;
Happy coding!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/1846857197325193803/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/1846857197325193803' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1846857197325193803'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1846857197325193803'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2014/01/wcf-concurrency-single-multiple-and.html' title='WCF Concurrency (Single, Multiple, and Reentrant) and Throttling'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-4921765756936371230</id><published>2013-10-07T12:16:00.000-07:00</published><updated>2013-10-06T21:16:52.140-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="database"/><category scheme="http://www.blogger.com/atom/ns#" term="merge"/><category scheme="http://www.blogger.com/atom/ns#" term="sql server 2008"/><category scheme="http://www.blogger.com/atom/ns#" term="sql server 2008 r2"/><category scheme="http://www.blogger.com/atom/ns#" term="t-sql"/><category scheme="http://www.blogger.com/atom/ns#" term="tables"/><title type='text'>Using the MERGE statement in SQL Server 2008 (and up)</title><content type='html'>&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;The MERGE statement is a newly introduced functionality in SQL Server 2008, which, &lt;a href=&quot;http://msdn.microsoft.com/en-us/library/bb510625.aspx&quot; target=&quot;_blank&quot;&gt;according to MSDN&lt;/a&gt;,&amp;nbsp;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;Performs insert, update, or delete operations on a target table based on the results of a join with a source table. For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;This came into the picture because I needed something to manipulate a table of all the (permanent) employees in the company which are pulled from another database that is being updated everyday. So instead of doing a rather more tedious script, I have decided to use the MERGE statement instead.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;So for my example, I have two tables, one is called GALTemp and one is GAL, both with the same table schema. I am refreshing and updating GALTemp every night, and with that, I have to merge GALTemp with the GAL table. Merge in my case would mean:&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;-if the employee is already existing in the GAL table, some of its fields will be updated based from the data of GALTemp&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;-if the employee is a new one from GALTemp, it will be inserted as a new entry in GAL.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;Also, to perform a MERGE, it also needs to have an identifier from both tables, such as an employee id that would refer to the data to be merged. In my case, similar to the JOIN clause, I am using the Alias_Name column which is the unique employee network ID in the database. If an Alias_Name from GALTemp matches with one row in GAL, it will update some of the fields (such as the employee&#39;s department, title, office, phone number, and company name). If an Alias_Name from GALTemp is not found in GAL, the whole row with that Alias_Name will be inserted as a new entry in the GAL table.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;Take a look at my script below:&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif; font-size: x-small;&quot;&gt;&lt;span style=&quot;color: #2a2a2a; line-height: 18px;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;pre style=&quot;background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotJGd4cbW_09uXZ-0uBmxQi6gad2Q1VZr8qrfNdSwXhQfy3WLEEwhCjOSB0Cmv3_G0wz6KYuHfdXZ8KrrDTx-WI_SkFi8Y8MUBT_bWqcrMnUWgyH19DVI2MYbuwHocVDIG0GGwtxDMxk1/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;&quot;&gt;&lt;code style=&quot;color: black; word-wrap: normal;&quot;&gt; USE TSRFv2_Copy  
 GO
  
 MERGE GAL AS tg1  
 USING (SELECT * FROM GALTemp) AS tg2  
 ON tg1.Alias_Name = tg2.Alias_Name  
 WHEN MATCHED THEN   
      UPDATE SET tg1.[Auto_ID] = tg2.[Auto_ID],  
                  tg1.[Title] = tg2.[Title],  
                  tg1.[Department] = tg2.[Department],  
                  tg1.[Office] = tg2.[Office],  
                  tg1.[Phone_Number] = tg2.[Phone_Number],  
                  tg1.[Company] = tg2.[Company]  
 WHEN NOT MATCHED THEN   
      INSERT   
       ([Auto_ID]  
       ,[Obj_Class]  
       ,[Display_Name]  
       ,[First_Name]  
       ,[Last_Name]  
       ,[Employee_ID]  
       ,[Alias_Name]  
       ,[Title]  
       ,[Department]  
       ,[Office]  
       ,[Phone_Number]  
       ,[E_mail]  
       ,[Company])  
    VALUES  
       (tg2.[Auto_ID]  
       ,tg2.[Obj_Class]  
       ,tg2.[Display_Name]  
       ,tg2.[First_Name]  
       ,tg2.[Last_Name]  
       ,tg2.[Employee_ID]  
       ,tg2.[Alias_Name]  
       ,tg2.[Title]  
       ,tg2.[Department]  
       ,tg2.[Office]  
       ,tg2.[Phone_Number]  
       ,tg2.[E_mail]  
       ,tg2.[Company]);  
 GO  
&lt;/code&gt;&lt;/pre&gt;
&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;Do not forget to put a semicolon (;) at the end of the MERGE statement.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: Trebuchet MS, sans-serif;&quot;&gt;Happy Coding!&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/4921765756936371230/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/4921765756936371230' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/4921765756936371230'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/4921765756936371230'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/10/using-merge-statement-in-sql-server.html' title='Using the MERGE statement in SQL Server 2008 (and up)'/><author><name>heaven_chill</name><uri>http://www.blogger.com/profile/17567252220673790160</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='24' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizgBzwUPtG3ezwgJvM2MD2FqGMms2JQ7Mm-M75nyewfEyx5ZfikCBqdEAzgCNa15PrHtdRch-7BXsUrebUJMOa_wAL8DnwUicqVM_JIwmT1YDCKIbourx3GoaFpKPT7A/s220/1_333003731l.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-8111569700970494258</id><published>2013-10-06T20:31:00.000-07:00</published><updated>2013-10-06T21:08:37.631-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="display authorizations"/><category scheme="http://www.blogger.com/atom/ns#" term="set authorizations"/><category scheme="http://www.blogger.com/atom/ns#" term="websphere mq"/><title type='text'>Display and Set MQ Authorizations in WebSphere</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://cdn.memegenerator.net/instances/400x/26541729.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;http://cdn.memegenerator.net/instances/400x/26541729.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Got an issue wherein I need to set my Queue with these following permissions:&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Put&lt;/li&gt;
&lt;li&gt;Get&lt;/li&gt;
&lt;li&gt;Inq&lt;/li&gt;
&lt;/ul&gt;
And as being new to WebSphere, I found that this is how to display and set authorizations in the WebSphere MQ. For example that queue manager name is &lt;b&gt;TESTQM &lt;/b&gt;and queue name is &lt;b&gt;TESTQUEUE&lt;/b&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Display Authorization&lt;/b&gt;&lt;br /&gt;
Syntax: dspmqaut [-m qmgrname] [-n objname] -t objtype [-p principal/ -g group] [-s service component]&lt;br /&gt;
Ex:&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgptiqB5t5MyTgSjgwmYnhOcsPBh9brWSsXW4kaqtX2oPr0vp6vqWgznxj69XAFL3jJ2C9IRZDMc_nRqImn2IAIsN-LpzWuaVEZb9LIQCKnSQLBegXGdY_bPXjJcwtGVvuDuKxaWfftxdI/s1600/display.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;65&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgptiqB5t5MyTgSjgwmYnhOcsPBh9brWSsXW4kaqtX2oPr0vp6vqWgznxj69XAFL3jJ2C9IRZDMc_nRqImn2IAIsN-LpzWuaVEZb9LIQCKnSQLBegXGdY_bPXjJcwtGVvuDuKxaWfftxdI/s400/display.JPG&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;b&gt;Set Authorization&lt;/b&gt;&lt;br /&gt;
Syntax:&amp;nbsp;&lt;b&gt; &lt;/b&gt;setmqaut [-m qmgrname] [-n objname] -t objtype [-p principal/ -g group] [-s service component] [+/- authorization verb]&lt;br /&gt;
Ex:&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhu1T_lpyMCQuXgh3V8EN9Im2xaAtu9g7GxFvDvYeNTu2p36Z4EZKnrP4yNQ-EDGKwnHniQTAiEvB5KbS4Xe3iQ1boVih8atwieS-oqIy-pFswfLHnexxtwnOVaCQlIk1CG1ufOt5g5-UI/s1600/set.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;95&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhu1T_lpyMCQuXgh3V8EN9Im2xaAtu9g7GxFvDvYeNTu2p36Z4EZKnrP4yNQ-EDGKwnHniQTAiEvB5KbS4Xe3iQ1boVih8atwieS-oqIy-pFswfLHnexxtwnOVaCQlIk1CG1ufOt5g5-UI/s400/set.JPG&quot; width=&quot;400&quot; /&gt;&amp;nbsp;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;b&gt;UPDATE 07/10/2013&lt;/b&gt;&lt;br /&gt;
To remove authorization &#39;setid&#39; in the manager queue&lt;b&gt; &lt;/b&gt;:&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjppDD5rfRxC4IH2KMyZxiCxjfkHOER1JD-XJI33m1xb0y3jVR3jzimZiOWkAK66gCj6O_IMY_7dqn8q_58nUG1h3VeR1LSuuY33V5DkIH-N0_2Fk3mKfUR4G5s192tBcYSjVBWecXJlfw/s1600/set+queue.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;30&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjppDD5rfRxC4IH2KMyZxiCxjfkHOER1JD-XJI33m1xb0y3jVR3jzimZiOWkAK66gCj6O_IMY_7dqn8q_58nUG1h3VeR1LSuuY33V5DkIH-N0_2Fk3mKfUR4G5s192tBcYSjVBWecXJlfw/s400/set+queue.JPG&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/8111569700970494258/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/8111569700970494258' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/8111569700970494258'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/8111569700970494258'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/10/display-and-set-mq-authorizations-in.html' title='Display and Set MQ Authorizations in WebSphere'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgptiqB5t5MyTgSjgwmYnhOcsPBh9brWSsXW4kaqtX2oPr0vp6vqWgznxj69XAFL3jJ2C9IRZDMc_nRqImn2IAIsN-LpzWuaVEZb9LIQCKnSQLBegXGdY_bPXjJcwtGVvuDuKxaWfftxdI/s72-c/display.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-8310863008344981298</id><published>2013-09-13T04:32:00.000-07:00</published><updated>2013-09-13T04:32:32.749-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="AppFabric"/><category scheme="http://www.blogger.com/atom/ns#" term="windows workflow foundation"/><title type='text'>A Discussion with my Team Lead on Workflows and AppFabric Persistence Store</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
I just had a discussion with my team lead regarding her knowledge on workflows. I will just share to you what she taught me.&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;The ServiceDeploymentsTable in the Persistence Store lists all of the workflow services that are hosted.&lt;/li&gt;
&lt;li&gt;The InstancesTable lists out the instances of your workflows. It also shows the status of each workflow instance. To locate your workflow instances in the InstancesTable, get the Id in the ServiceDeploymentsTable and map it with the ServiceDeploymentId in the InstancesTable&lt;/li&gt;
&lt;li&gt;In the InstancesTable, there are two important columns one needs to check (especially for workflow schedulers): PendingTimer and the BlockingBookmarks&lt;/li&gt;
&lt;li&gt;PendingTimer shows the time when the workflow instance will wake up. The time here is in GMT +0. So, for example, if you are in the Philippines (GMT +8) and the PendingTime shows 07:50, your workflow will wake up at 15:50pm.&lt;/li&gt;
&lt;li&gt;BlockingBookmarks shows what is the current workflow activity. Personally, this is applicable if you have a PickBranch activity. &lt;br /&gt;&lt;br /&gt;
For example, you have a DelayBranch and a StopBranch. According to her, if the current activity is now in the DelayBranch, the BlockingBookmarks will show &quot;StopBranch&quot; because it is waiting for the StopBranch to be triggered and that the DelayBranch is currently working.&lt;br /&gt;
&lt;/li&gt;
&lt;/ul&gt;
These are just some of the items that I&#39;ve learned from her. I hope this helps you understand some of the things with the AppFabric Persistence Store&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/8310863008344981298/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/8310863008344981298' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/8310863008344981298'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/8310863008344981298'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/09/a-discussion-with-my-team-lead-on.html' title='A Discussion with my Team Lead on Workflows and AppFabric Persistence Store'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-2697127415184682797</id><published>2013-08-28T00:09:00.002-07:00</published><updated>2013-08-28T00:09:50.831-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="connectivity"/><category scheme="http://www.blogger.com/atom/ns#" term="ping"/><category scheme="http://www.blogger.com/atom/ns#" term="telnet"/><category scheme="http://www.blogger.com/atom/ns#" term="trace route"/><title type='text'>Testing connection</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi08doWyr6vx9KQdOmkuuju1OgdktVLtJJV87blEHmFT1TdBhxdDdp4wQ7lD3M4zGDeqepEbxvXdXmCPISWKoay-2t_HqibfSLFh2aWt92UU8mORrKdXFqmroK8l1MmANKlBUwkBO-uWWyr/&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;200&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi08doWyr6vx9KQdOmkuuju1OgdktVLtJJV87blEHmFT1TdBhxdDdp4wQ7lD3M4zGDeqepEbxvXdXmCPISWKoay-2t_HqibfSLFh2aWt92UU8mORrKdXFqmroK8l1MmANKlBUwkBO-uWWyr/&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Just want to share with you what I learned lately regarding how to test the connection. The common commands are telnet, ping and tracert. Below are commands on how to use them.&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;To Ping: ping&lt;space&gt;&lt;ip address=&quot;&quot;&gt;. Ex: ping 111.222.333.444 &lt;/ip&gt;&lt;/space&gt;&lt;/li&gt;
&lt;li&gt;To test telnet: telnet&lt;space&gt;&lt;ip address=&quot;&quot;&gt;&lt;space&gt;&lt;port number=&quot;&quot;&gt;. Ex: telnet 111.222.333.444 22&lt;/port&gt;&lt;/space&gt;&lt;/ip&gt;&lt;/space&gt;&lt;/li&gt;
&lt;li&gt;To Trace Route: tracert&lt;space&gt;&lt;ip address=&quot;&quot;&gt;. Ex: tracert 111.222.333.444&lt;/ip&gt;&lt;/space&gt;&lt;/li&gt;
&lt;/ul&gt;
Hope this helps! Will update this on the definitions of these 3.&lt;br /&gt;
&lt;br /&gt;
Happy coding! &lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/2697127415184682797/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/2697127415184682797' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/2697127415184682797'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/2697127415184682797'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/08/testing-connection.html' title='Testing connection'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi08doWyr6vx9KQdOmkuuju1OgdktVLtJJV87blEHmFT1TdBhxdDdp4wQ7lD3M4zGDeqepEbxvXdXmCPISWKoay-2t_HqibfSLFh2aWt92UU8mORrKdXFqmroK8l1MmANKlBUwkBO-uWWyr/s72-c" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-6975321927256009066</id><published>2013-08-01T19:16:00.000-07:00</published><updated>2013-08-01T19:16:30.455-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="asp.net"/><category scheme="http://www.blogger.com/atom/ns#" term="commandargument"/><category scheme="http://www.blogger.com/atom/ns#" term="gridview"/><category scheme="http://www.blogger.com/atom/ns#" term="selected row"/><title type='text'>Get gridview selected row</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZRQdCSkFtRs8PC2PupJEUvV7cK9a3VJPkNxyJrbB4khhUnT0YdhNta0ZqCH7ZqiRmLhTcLrAJnojf12xWNtZRGHpEyPTMJ11p08Mp4LJZYZrVFE3sil1e010FfpdBkfI3aa-7B4MCka8/s1600/gridview+Boromir.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;320&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZRQdCSkFtRs8PC2PupJEUvV7cK9a3VJPkNxyJrbB4khhUnT0YdhNta0ZqCH7ZqiRmLhTcLrAJnojf12xWNtZRGHpEyPTMJ11p08Mp4LJZYZrVFE3sil1e010FfpdBkfI3aa-7B4MCka8/s320/gridview+Boromir.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
There was this requirement in one of my projects that it will display a confirm dialog box whenever the user would click on the select button. Thanks to the Ajax Control Toolkit (you can download the latest version &lt;a href=&quot;http://www.asp.net/ajaxlibrary/ajaxcontroltoolkitsamplesite/&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;), I was able to use the &lt;a href=&quot;http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/ConfirmButton/ConfirmButton.aspx&quot; target=&quot;_blank&quot;&gt;Confirm Button control&lt;/a&gt;. By doing so, I would need to convert the select button column in my grid view to a template column (thus converting the button to a link button in my grid view).&lt;br /&gt;
&lt;br /&gt;
While expecting that I would still get the selected row (using the command argument), I found out that this is does not happen.&lt;br /&gt;
&lt;br /&gt;
Why?&lt;br /&gt;
&lt;br /&gt;
Because while we did convert it successfully, the link button does not tie up easily to my selected row [Note: I will update this explanation once I&#39;ve confirmed it fully. But for now, this is what really happens]. Initially, I would add in a custom attribute on the row inside the GridView.RowCreated event. However, I found a better solution and I did this by tweaking in the CommandArgument property.&lt;br /&gt;
&lt;pre style=&quot;background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotJGd4cbW_09uXZ-0uBmxQi6gad2Q1VZr8qrfNdSwXhQfy3WLEEwhCjOSB0Cmv3_G0wz6KYuHfdXZ8KrrDTx-WI_SkFi8Y8MUBT_bWqcrMnUWgyH19DVI2MYbuwHocVDIG0GGwtxDMxk1/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;&quot;&gt;&lt;code style=&quot;color: black; word-wrap: normal;&quot;&gt; &amp;lt;asp:PagingGridView ID=&quot;UsersGridView&quot; runat=&quot;server&quot;   
           CellPadding=&quot;4&quot; ForeColor=&quot;#333333&quot; GridLines=&quot;None&quot;  
           DataKeyNames=&quot;ID&quot;   
           AutoGenerateColumns=&quot;False&quot; AllowSorting=&quot;True&quot;   
           ShowHeaderWhenEmpty=&quot;True&quot;   
           OnPageIndexChanging=&quot;UsersGridView_PageIndexChanging&quot;   
           OnRowCommand=&quot;UsersGridView_RowCommand&quot;   
           OnRowEditing=&quot;UsersGridView_RowEditing&quot; AllowPaging=&quot;True&quot;&amp;gt;  
   &amp;lt;AlternatingRowStyle BackColor=&quot;White&quot; /&amp;gt;  
   &amp;lt;Columns&amp;gt;  
     &amp;lt;asp:TemplateField ShowHeader=&quot;False&quot;&amp;gt;  
       &amp;lt;ItemTemplate&amp;gt;  
         &amp;lt;asp:LinkButton ID=&quot;LinkButton1&quot;   
           runat=&quot;server&quot;   
           CausesValidation=&quot;false&quot;   
           CommandName=&quot;Delete&quot;   
           &lt;b&gt;&lt;span style=&quot;color: #990000;&quot;&gt;CommandArgument=&quot;&amp;lt;%# Container.DataItemIndex %&amp;gt;&quot;&lt;/span&gt;&lt;/b&gt;  
           Text=&quot;Delete&quot;/&amp;gt;  
         &amp;lt;asp:ConfirmButtonExtender ID=&quot;LinkButton1_ConfirmButtonExtender&quot;   
           runat=&quot;server&quot;   
           ConfirmText=&quot;Are you sure you want to delete this record?&quot;   
           Enabled=&quot;True&quot;   
           TargetControlID=&quot;LinkButton1&quot;/&amp;gt;  
       &amp;lt;/ItemTemplate&amp;gt;  
     &amp;lt;/asp:TemplateField&amp;gt;  
     &amp;lt;asp:BoundField DataField=&quot;ID&quot; HeaderText=&quot;ID&quot; /&amp;gt;  
     &amp;lt;asp:BoundField DataField=&quot;Name&quot; HeaderText=&quot;Name&quot; /&amp;gt;  
     &amp;lt;asp:BoundField DataField=&quot;Address&quot; HeaderText=&quot;Address&quot; /&amp;gt;  
     &amp;lt;asp:BoundField DataField=&quot;Group&quot; HeaderText=&quot;User Group&quot; /&amp;gt;  
     &amp;lt;asp:BoundField DataField=&quot;IsActive&quot; HeaderText=&quot;Is Active&quot; /&amp;gt;  
   &amp;lt;/Columns&amp;gt;  
   &amp;lt;EditRowStyle BackColor=&quot;#7C6F57&quot; /&amp;gt;  
   &amp;lt;EmptyDataTemplate&amp;gt;  
     No records found  
   &amp;lt;/EmptyDataTemplate&amp;gt;  
   &amp;lt;FooterStyle BackColor=&quot;#1C5E55&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;White&quot; /&amp;gt;  
   &amp;lt;HeaderStyle BackColor=&quot;#1C5E55&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;White&quot; /&amp;gt;  
   &amp;lt;PagerSettings Mode=&quot;NumericFirstLast&quot;/&amp;gt;  
   &amp;lt;PagerStyle BackColor=&quot;#666666&quot; ForeColor=&quot;White&quot; HorizontalAlign=&quot;Center&quot; /&amp;gt;  
   &amp;lt;RowStyle BackColor=&quot;#E3EAEB&quot; /&amp;gt;  
   &amp;lt;SelectedRowStyle BackColor=&quot;#C5BBAF&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;#333333&quot; /&amp;gt;  
   &amp;lt;SortedAscendingCellStyle BackColor=&quot;#F8FAFA&quot; /&amp;gt;  
   &amp;lt;SortedAscendingHeaderStyle BackColor=&quot;#246B61&quot; /&amp;gt;  
   &amp;lt;SortedDescendingCellStyle BackColor=&quot;#D4DFE1&quot; /&amp;gt;  
   &amp;lt;SortedDescendingHeaderStyle BackColor=&quot;#15524A&quot; /&amp;gt;  
 &amp;lt;/asp:PagingGridView&amp;gt;  
&lt;/code&gt;&lt;/pre&gt;
By adding that section in the CommandArgument property, we are now able to get the selected row through the CommandArgument property.&lt;br /&gt;
&lt;br /&gt;
Hope this helps!&lt;br /&gt;
&lt;br /&gt;
Happy coding! &lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/6975321927256009066/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/6975321927256009066' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/6975321927256009066'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/6975321927256009066'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/08/get-gridview-selected-row.html' title='Get gridview selected row'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZRQdCSkFtRs8PC2PupJEUvV7cK9a3VJPkNxyJrbB4khhUnT0YdhNta0ZqCH7ZqiRmLhTcLrAJnojf12xWNtZRGHpEyPTMJ11p08Mp4LJZYZrVFE3sil1e010FfpdBkfI3aa-7B4MCka8/s72-c/gridview+Boromir.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-4222638421876657819</id><published>2013-07-31T04:46:00.001-07:00</published><updated>2013-07-31T20:38:47.326-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="sql jobs"/><category scheme="http://www.blogger.com/atom/ns#" term="sql server 2008"/><category scheme="http://www.blogger.com/atom/ns#" term="ssis"/><title type='text'>Set values in SQL Job from physical files or folders</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTYZihU2uaBRRKd7hzv68V4X3n2j8nDzFYGQYaVkm76CBNQxfH0KA&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTYZihU2uaBRRKd7hzv68V4X3n2j8nDzFYGQYaVkm76CBNQxfH0KA&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
I encountered a problem when I deployed and run the package.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;span style=&quot;color: red;&quot;&gt;Error: 2013-07-31 15:23:00.66&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Code: 0xC001401E&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Source: MyPackage Connection manager &quot;FlatFileConnection&quot;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Description: The file name &quot;D:\ReportFolder&quot; /SET \Package.Variables[User::_consolePath].Properties[Value];D:\Console_MyReport.txt&quot; specified in the connection was not valid.&amp;nbsp; End Error&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;br /&gt;
[Note: To view the Package History via query, please refer to my previous post about &lt;a href=&quot;http://onehappycoder.blogspot.com/2013/07/view-sql-server-job-history-via-query.html&quot; target=&quot;_blank&quot;&gt;&quot;View SQL Server Job History via query&quot;&lt;/a&gt;]&lt;br /&gt;
&lt;br /&gt;
One way to check is to see if the folder has rights for the user. I did this but it failed. However in my investigation, I found out that it is caused by the path. Below is the screenshot of the changes I&#39;ve done.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisIzgUpCY-vetNvt4sG-tpW92yVil-IzzkZUJANTVrQK572mnLB4tlOPkPtHxJd-XRjNVSyxVtHzVUWLsqdHxi4Df83Mgg5COnOjHdZABPCXVOIMc2kr-fOZixkYH5O4OZCrSC17NTrlA/s1600/Capture.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;235&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisIzgUpCY-vetNvt4sG-tpW92yVil-IzzkZUJANTVrQK572mnLB4tlOPkPtHxJd-XRjNVSyxVtHzVUWLsqdHxi4Df83Mgg5COnOjHdZABPCXVOIMc2kr-fOZixkYH5O4OZCrSC17NTrlA/s400/Capture.JPG&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
Initially, I&#39;ve set the values for the _outputFolder&amp;nbsp; and _consolePath to &quot;D:\ReportFolder\&quot; and &quot;D:\Console\&quot; respectively. So, by adding an additional &quot;\&quot;, it would solve the issue. After changing the values and running the package, it passed.&lt;br /&gt;
&lt;br /&gt;
I hope that this helps.&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/4222638421876657819/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/4222638421876657819' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/4222638421876657819'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/4222638421876657819'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/07/set-values-in-sql-job-from-physical.html' title='Set values in SQL Job from physical files or folders'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisIzgUpCY-vetNvt4sG-tpW92yVil-IzzkZUJANTVrQK572mnLB4tlOPkPtHxJd-XRjNVSyxVtHzVUWLsqdHxi4Df83Mgg5COnOjHdZABPCXVOIMc2kr-fOZixkYH5O4OZCrSC17NTrlA/s72-c/Capture.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-2767426052670313397</id><published>2013-07-30T18:35:00.001-07:00</published><updated>2013-07-30T18:35:30.306-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="sql jobs"/><category scheme="http://www.blogger.com/atom/ns#" term="sql server"/><category scheme="http://www.blogger.com/atom/ns#" term="view jobs"/><title type='text'>View SQL Server Job History via query</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYqWeAoSulE1XHAU2YaZ4uQPtIMgVcToKUK_IFIuSPDbo0rIEyzBVvir4cYgFWNgJsS-9OBmsR0hFsa4B6Mr7TVrRPpBbWztbJKvfxQenvb6rkE3d07NEva2obeTR7tABrE-_QaE8TF0/s1600/sbc+packers.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;240&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYqWeAoSulE1XHAU2YaZ4uQPtIMgVcToKUK_IFIuSPDbo0rIEyzBVvir4cYgFWNgJsS-9OBmsR0hFsa4B6Mr7TVrRPpBbWztbJKvfxQenvb6rkE3d07NEva2obeTR7tABrE-_QaE8TF0/s320/sbc+packers.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Everytime I think of packages, I always remember the SBC Packers. Hehehehe! &lt;br /&gt;
&lt;br /&gt;
Anyway, lately I&#39;ve been working into SSIS and have deployed my package to an SQL Job. However, I always get the timeout error every time I would view it through the GUI.&lt;br /&gt;
&lt;br /&gt;
Gladly, I found a query that displays the job history using this query.&lt;br /&gt;
&lt;pre style=&quot;background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotJGd4cbW_09uXZ-0uBmxQi6gad2Q1VZr8qrfNdSwXhQfy3WLEEwhCjOSB0Cmv3_G0wz6KYuHfdXZ8KrrDTx-WI_SkFi8Y8MUBT_bWqcrMnUWgyH19DVI2MYbuwHocVDIG0GGwtxDMxk1/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;&quot;&gt;&lt;code style=&quot;color: black; word-wrap: normal;&quot;&gt; DECLARE @dateparam DATETIME  
 DECLARE @JobName VARCHAR(100)  
 SET @dateparam = getdate()  
 SET @JobName = &#39;MyJob&#39;  
 SELECT sysjobhistory.SERVER  
      ,sysjobs.NAME AS job_name  
      ,CASE sysjobhistory.run_status  
           WHEN 0  
                THEN &#39;Failed&#39;  
           WHEN 1  
                THEN &#39;Succeeded&#39;  
           ELSE &#39;???&#39;  
           END AS run_status  
      ,Isnull(Substring(CONVERT(VARCHAR(8), run_date), 1, 4) + &#39;-&#39; + Substring(CONVERT(VARCHAR(8), run_date), 5, 2) + &#39;-&#39; + Substring(CONVERT(VARCHAR(8), run_date), 7, 2), &#39;&#39;) AS [Run DATE]  
      ,Isnull(Substring(CONVERT(VARCHAR(7), run_time + 1000000), 2, 2) + &#39;:&#39; + Substring(CONVERT(VARCHAR(7), run_time + 1000000), 4, 2) + &#39;:&#39; + Substring(CONVERT(VARCHAR(7), run_time + 1000000), 6, 2), &#39;&#39;) AS [Run TIME]  
      ,Isnull(Substring(CONVERT(VARCHAR(7), run_duration + 1000000), 2, 2) + &#39;:&#39; + Substring(CONVERT(VARCHAR(7), run_duration + 1000000), 4, 2) + &#39;:&#39; + Substring(CONVERT(VARCHAR(7), run_duration + 1000000), 6, 2), &#39;&#39;) AS [Duration]  
      ,sysjobhistory.step_id  
      ,sysjobhistory.step_name  
      ,sysjobhistory.MESSAGE  
 FROM msdb.dbo.sysjobhistory  
 INNER JOIN msdb.dbo.sysjobs ON msdb.dbo.sysjobhistory.job_id = msdb.dbo.sysjobs.job_id  
 WHERE sysjobhistory.run_date = Datepart(yyyy, @dateparam) * 10000 + Datepart(mm, @dateparam) * 100 + Datepart(dd, @dateparam)  
      AND sysjobs.NAME = @JobName --remove this line if you want to show all jobs for the specified day  
 ORDER BY instance_id DESC  
&lt;/code&gt;&lt;/pre&gt;
&lt;br /&gt;
I hope this code helps you.&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;br /&gt;
&lt;br /&gt;
---------------------------------------------------------&lt;br /&gt;
&lt;i&gt;Source:&lt;/i&gt;&lt;br /&gt;
&lt;i&gt;&lt;a href=&quot;http://www.jamesserra.com/archive/2011/06/easier-way-to-view-sql-server-job-history/&quot; target=&quot;_blank&quot;&gt;Easier way to view SQL Server job history&lt;/a&gt; by James Serra&lt;/i&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/2767426052670313397/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/2767426052670313397' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/2767426052670313397'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/2767426052670313397'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/07/view-sql-server-job-history-via-query.html' title='View SQL Server Job History via query'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisYqWeAoSulE1XHAU2YaZ4uQPtIMgVcToKUK_IFIuSPDbo0rIEyzBVvir4cYgFWNgJsS-9OBmsR0hFsa4B6Mr7TVrRPpBbWztbJKvfxQenvb6rkE3d07NEva2obeTR7tABrE-_QaE8TF0/s72-c/sbc+packers.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-854744639193055237</id><published>2013-07-25T00:47:00.002-07:00</published><updated>2013-07-25T00:47:59.115-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="bids 2008"/><category scheme="http://www.blogger.com/atom/ns#" term="error"/><category scheme="http://www.blogger.com/atom/ns#" term="ssis"/><title type='text'>[ERROR] Result binding by name is not supported for this connection type</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
I found this weird error in SSIS (using BIDS 2008).&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: red;&quot;&gt;[Execute SQL Task] Error: An error occurred while assigning a value to variable [variable name]: &quot;Result binding by name [column name] is not supported for this connection type. &quot;.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
The connection manager that I used is ADO.Net.&lt;br /&gt;
&lt;br /&gt;
After much research, I found out the solution to this error from this &lt;a href=&quot;http://hanleyhub.com/blog/?p=46&quot; target=&quot;_blank&quot;&gt;link&lt;/a&gt;:&lt;br /&gt;
&lt;blockquote class=&quot;tr_bq&quot;&gt;
&lt;i&gt;[Then] I found that the ‘Result Set – Result Name’ should be changed to Index of the Column in the Result Set like &lt;b&gt;0&lt;/b&gt;, &lt;b&gt;&lt;i&gt;1, etc&lt;/i&gt;&lt;/b&gt;.&lt;/i&gt;&lt;/blockquote&gt;
Yes! This sucks to know that it should be based on the index. I hope that in the latest version, we can use the column name.&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/854744639193055237/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/854744639193055237' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/854744639193055237'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/854744639193055237'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/07/error-result-binding-by-name-is-not.html' title='[ERROR] Result binding by name is not supported for this connection type'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-4404505680538237142</id><published>2013-06-03T19:26:00.000-07:00</published><updated>2013-06-03T19:26:15.471-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="info"/><category scheme="http://www.blogger.com/atom/ns#" term="visual studio"/><title type='text'>Difference between Clean, Build and Rebuild Solution</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbAspAGsQYC5zQA_ff3m3DzahUI1BJ3lCIsSOOub7utUGs3dgbNGzaQPrsHLjJqFZH_w-eYxU6cVI8wEP5kfYveXecC-l0yhvpoeV5LP7ARI5Xf_EIWnNpYOD-URms1Ssr7Gg1YS0lJ1c/s1600/rebuild.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;177&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbAspAGsQYC5zQA_ff3m3DzahUI1BJ3lCIsSOOub7utUGs3dgbNGzaQPrsHLjJqFZH_w-eYxU6cVI8wEP5kfYveXecC-l0yhvpoeV5LP7ARI5Xf_EIWnNpYOD-URms1Ssr7Gg1YS0lJ1c/s400/rebuild.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
It took me quite a while to understand the difference between &quot;Clean Solution&quot;, &quot;Build Solution&quot; and &quot;Rebuild Solution&quot;. I&#39;ve been using them, but it&#39;s because of &lt;a href=&quot;http://stackoverflow.com/a/3095935/440310&quot; target=&quot;_blank&quot;&gt;John Skeet&#39;s answer in Stackoverflow&lt;/a&gt; that I finally understand the meaning. And this is what he wrote:&lt;br /&gt;
&lt;blockquote class=&quot;tr_bq&quot;&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;&lt;b&gt;Clean solution&lt;/b&gt; will remove the build artefacts from the previous build. If there are any other files in the build target directories (bin and obj) they may not be removed, but actual build artefacts are. I&#39;ve seen behaviour for this vary - sometimes deleting fairly thoroughly and sometimes not - but I&#39;ll give VS the benefit of the doubt for the moment :)&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Build solution&lt;/b&gt; will perform an incremental build: if it doesn&#39;t think it needs to rebuild a project, it won&#39;t. It may also use partially-built bits of the project if they haven&#39;t changed (I don&#39;t know how far it takes this)&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Rebuild solution&lt;/b&gt; will clean and then build the solution from scratch, ignoring anything it&#39;s done before&lt;/li&gt;
&lt;/ul&gt;
&lt;/blockquote&gt;
I hope this helps for you to understand these three.&lt;br /&gt;
&lt;br /&gt;
Happy coding! &lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/4404505680538237142/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/4404505680538237142' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/4404505680538237142'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/4404505680538237142'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/06/difference-between-clean-build-and.html' title='Difference between Clean, Build and Rebuild Solution'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbAspAGsQYC5zQA_ff3m3DzahUI1BJ3lCIsSOOub7utUGs3dgbNGzaQPrsHLjJqFZH_w-eYxU6cVI8wEP5kfYveXecC-l0yhvpoeV5LP7ARI5Xf_EIWnNpYOD-URms1Ssr7Gg1YS0lJ1c/s72-c/rebuild.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-1679063641419126008</id><published>2013-06-02T23:54:00.002-07:00</published><updated>2013-10-04T02:34:42.905-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="errors"/><category scheme="http://www.blogger.com/atom/ns#" term="websphere mq"/><title type='text'>List of WebSphere MQ Errors</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://cdn.memegenerator.net/instances/400x/28233041.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; src=&quot;http://cdn.memegenerator.net/instances/400x/28233041.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVJRz5e1QFH81ZDVW9w3xl8NLGe-Er68yELqkd3Jq3db6_bf3bHQiXYU_5RiESGUWS2eVIMsSYZh-FgmXbno5PE5SVpYdi5hRZ2g4O2Put5NtZc5WC0KKX93qXGmz8cLnxN4BLhyphenhyphenoLHJ4/s1600/Websphere+meme.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;br /&gt;
&lt;/a&gt; I&#39;m currently crawling with the use of WebSphere MQ and I&#39;ve encountered lots of errors which I can&#39;t understand.&lt;br /&gt;
&lt;br /&gt;
Good thing I found a list of WebSphere errors in this website: &lt;a href=&quot;http://russsutton.com/developer/index.php/45/websphere-mq-reason-codes-error-codes/&quot; target=&quot;_blank&quot;&gt;WebSphere MQ Reason Codes (Error Codes)&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
I hope this helps you understand how and where to check.&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;UPDATES [10/4/2013]:&lt;/b&gt;&lt;br /&gt;
Here are some common errors which I got from &lt;a href=&quot;http://support.sas.com/rnd/itech/doc9/dev_guide/messageq/mqexplor.html&quot; target=&quot;_blank&quot;&gt;http://support.sas.com/rnd/itech/doc9/dev_guide/messageq/mqexplor.html&lt;/a&gt;. This is a good resource for understanding how the websphere works.&lt;br /&gt;
&lt;table bgcolor=&quot;#ffffff&quot; border=&quot;1&quot; cellpadding=&quot;3&quot; cellspacing=&quot;3&quot;&gt;&lt;tbody&gt;
&lt;tr class=&quot;silver&quot;&gt;  &lt;th&gt;Reason Code&lt;/th&gt;  &lt;th&gt;Explanation&lt;/th&gt;  &lt;th&gt;Suggested Action&lt;/th&gt; &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;2018&lt;/td&gt;  &lt;td&gt;Connection handle is invalid.&lt;/td&gt;  &lt;td&gt;A connection handle that is created by an MQCONN call must be used within the same DATA step where it was created.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;2035&lt;/td&gt;  &lt;td&gt;User is not authorized to perform the attempted action.&lt;/td&gt;  &lt;td&gt;Verify that you are connecting to the correct queue and queue manager.  Verify that you are authorized to connect to the queue manager.  If error is reported to a client connecting to a queue manager, you might need to set the user ID under the MCA tab in the server connection channel definition properties to a user ID that has permission to access the queue manager on the server machine.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;2058&lt;/td&gt;  &lt;td&gt;Error in Queue Manager Name.&lt;/td&gt;  &lt;td&gt;Check spelling and case of the queue manager name that is used in the application and is defined in the queue manager.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;2059&lt;/td&gt;  &lt;td&gt;Queue Manager is not available.&lt;/td&gt;  &lt;td&gt;Restart the queue manager.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;2085&lt;/td&gt;  &lt;td&gt;Unknown Object Name.&lt;/td&gt;  &lt;td&gt;Check spelling and case of the queue name that is used in the application and is defined in the queue manager.&lt;/td&gt; &lt;/tr&gt;
&lt;tr&gt;  &lt;td&gt;Others&lt;/td&gt;  &lt;td&gt;&lt;/td&gt;  &lt;td&gt;See the Messages book in the WebSphere MQ documentation.&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://onehappycoder.blogspot.com/feeds/1679063641419126008/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/1679063641419126008' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1679063641419126008'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1679063641419126008'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/06/list-of-websphere-mq-errors.html' title='List of WebSphere MQ Errors'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-9035631681259295801</id><published>2013-05-14T09:18:00.002-07:00</published><updated>2013-05-14T09:18:25.011-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="error"/><category scheme="http://www.blogger.com/atom/ns#" term="WF4"/><category scheme="http://www.blogger.com/atom/ns#" term="windows workflow foundation"/><category scheme="http://www.blogger.com/atom/ns#" term="workflow service"/><title type='text'>[ERROR] The contract name &#39;workflow service contract&#39; could not be found in the list of contracts implemented by the service &#39;workflow service&#39;</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;http://i1.kym-cdn.com/photos/images/original/000/500/648/a7d.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;231&quot; src=&quot;http://i1.kym-cdn.com/photos/images/original/000/500/648/a7d.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Source:&amp;nbsp;&lt;a href=&quot;http://knowyourmeme.com/photos/500648-gordon-ramsay&quot;&gt;http://knowyourmeme.com/photos/500648-gordon-ramsay&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
Yes! And when Gordon Ramsey says something, he means it.&lt;br /&gt;
&lt;br /&gt;
It&#39;s the same as what my error is shouting when I&#39;m running my workflow service.&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: #990000; font-family: Trebuchet MS, sans-serif; font-size: large;&quot;&gt;&lt;b&gt;&lt;i&gt;The contract name &#39;IWorkflowService&#39; could not be found in the list of contracts implemented by the service &#39;WorkflowService&#39;.&lt;/i&gt;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
It took me a while until I realized my mistake. It simply means one thing: I forgot to change the service contract name in the receive message activity. Just like WCF, WF services needs to expose a method. In this case, it is looking for the IWorkflowService contract in order to implement the WorkflowService.&lt;br /&gt;
&lt;br /&gt;
To start with, here&#39;s an example of a simple workflow service (Expense Service)&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHStm2H-HqCeNE41AvNRoiym2wxuayRVQzZM6bv7kiCVxcjBmJ3VB4XB4Qm2XakcPUj1IOGbmijtLogEDzlhLtEetcN25yT9kZZ6HpwvqcYZSur6nJ0-UFcd6JslGOp39NkFbMgK710g8/s1600/workflow.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;295&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHStm2H-HqCeNE41AvNRoiym2wxuayRVQzZM6bv7kiCVxcjBmJ3VB4XB4Qm2XakcPUj1IOGbmijtLogEDzlhLtEetcN25yT9kZZ6HpwvqcYZSur6nJ0-UFcd6JslGOp39NkFbMgK710g8/s400/workflow.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
To resolve this error:&lt;br /&gt;
&lt;ol style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;Click on the &lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;ReceiveRequest&lt;/span&gt; activity then go to &quot;Properties&quot;&lt;/li&gt;
&lt;li&gt;In the &lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;ServiceContractName&lt;/span&gt;, rename the contract name to &quot;&lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;{namespace/}IExpenseService&lt;/span&gt;&quot;&lt;/li&gt;
&lt;/ol&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlE1_rRd5IrhZdUS__xvoVOQyk6p0G-pC1uUq-FSa9DNdKu0eGKkgfcUoccGYd5arK5lO1-25Gy-wv-IAjLunGkjowBYCd8aOsOv0XLewSjlx1jMJJ9MNh4u5LS4pO_Z1wskgme9Re7UY/s1600/properties.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;277&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlE1_rRd5IrhZdUS__xvoVOQyk6p0G-pC1uUq-FSa9DNdKu0eGKkgfcUoccGYd5arK5lO1-25Gy-wv-IAjLunGkjowBYCd8aOsOv0XLewSjlx1jMJJ9MNh4u5LS4pO_Z1wskgme9Re7UY/s320/properties.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
With this, the &lt;span style=&quot;font-family: Courier New, Courier, monospace;&quot;&gt;ExpenseService&lt;/span&gt; is now exposed and can be used in the application.&lt;br /&gt;
&lt;br /&gt;
I hope this helps.&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;br /&gt;

&lt;br /&gt;
&lt;!------&gt;&lt;!------&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/9035631681259295801/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/9035631681259295801' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/9035631681259295801'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/9035631681259295801'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/05/error-contract-name-workflow-service.html' title='[ERROR] The contract name &#39;workflow service contract&#39; could not be found in the list of contracts implemented by the service &#39;workflow service&#39;'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHStm2H-HqCeNE41AvNRoiym2wxuayRVQzZM6bv7kiCVxcjBmJ3VB4XB4Qm2XakcPUj1IOGbmijtLogEDzlhLtEetcN25yT9kZZ6HpwvqcYZSur6nJ0-UFcd6JslGOp39NkFbMgK710g8/s72-c/workflow.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-32548995322316827</id><published>2013-04-11T01:50:00.003-07:00</published><updated>2013-06-26T02:36:11.117-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="error"/><category scheme="http://www.blogger.com/atom/ns#" term="wcf"/><category scheme="http://www.blogger.com/atom/ns#" term="webconfig"/><title type='text'>[ERROR] Memory gates checking failed because the free memory is less than 5% of total memory.</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9obKKKSyboBqIxspMzijlJxUc_gGmK7BSQk_nT4iHEngh6z3xFq_I1UFevZJP_-JUWmkKvtn3ONAuAXqc8oqcfah7N3ZTTi8od7YlN-yyG4pfeDWabCO0SzMUNR4vJuAw9QF0pCnhlpg/s1600/You+Shall+Not+Pass.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;322&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9obKKKSyboBqIxspMzijlJxUc_gGmK7BSQk_nT4iHEngh6z3xFq_I1UFevZJP_-JUWmkKvtn3ONAuAXqc8oqcfah7N3ZTTi8od7YlN-yyG4pfeDWabCO0SzMUNR4vJuAw9QF0pCnhlpg/s400/You+Shall+Not+Pass.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
During my deployment (because of a bug which I just noticed), I encountered this error in my WCF host web.config file.&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class=&quot;tr_bq&quot;&gt;
&lt;span style=&quot;color: red;&quot;&gt;Memory gates checking failed because the free memory is less than 5% of total memory.&amp;nbsp; As a result, the service will not be available for incoming requests.&amp;nbsp; As a result, the service will not be available for incoming requests.&amp;nbsp; To resolve this, either reduce the load on the machine or adjust the value of minFreeMemoryPercentageToActivateService on the serviceHostingEnvironment config element.&lt;/span&gt;&lt;/blockquote&gt;
Based on my research, it simply says that the RAM of the server is near 100% (likely like 96% already) and I have to free some space. Thus, we need to add this code in the WCF web.config file (specifically inside the &lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&lt;system .servicemodel=&quot;&quot;&gt;&lt;/system&gt;&lt;/span&gt; tag).&lt;br /&gt;
&lt;blockquote class=&quot;tr_bq&quot;&gt;
&lt;pre class=&quot;lang-sql prettyprint prettyprinted&quot;&gt;&lt;span style=&quot;font-size: small;&quot;&gt;&lt;code&gt;&lt;span class=&quot;pun&quot;&gt;&amp;lt;&lt;/span&gt;&lt;span class=&quot;pln&quot;&gt;serviceHostingEnvironment &lt;/span&gt;&lt;span class=&quot;pun&quot;&gt;...&lt;/span&gt;&lt;span class=&quot;pln&quot;&gt; &lt;span style=&quot;color: red;&quot;&gt;&lt;b&gt;minFreeMemoryPercentageToActivateService&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;pun&quot;&gt;=&lt;/span&gt;&lt;span class=&quot;str&quot;&gt;&quot;0&quot;&lt;/span&gt;&lt;span class=&quot;pln&quot;&gt; &lt;/span&gt;&lt;span class=&quot;pun&quot;&gt;/&amp;gt;&lt;/span&gt;&lt;/code&gt;&lt;/span&gt;&lt;/pre&gt;
&lt;/blockquote&gt;
What does this &lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;minFreeMemoryPercentageToActivateService&lt;/span&gt; attribute mean?&lt;br /&gt;
&lt;br /&gt;
It simply says that it &quot;specifies the minimum amount of free memory that should be available to 
the system, before a Windows Communication Foundation (WCF) service can 
be activated.&quot; (Source: MSDN). So by setting this to 0, the service can still run regardless of the RAM that is used in the server.&lt;br /&gt;
&lt;strike&gt;&lt;br /&gt;&lt;/strike&gt;
&lt;strike&gt;[NOTE: For me, it is still HIGHLY RECOMMENDED to free-up your RAM in order that the server can breathe easily and accept connections]&lt;/strike&gt;&lt;br /&gt;
&lt;br /&gt;
[UPDATE]&lt;br /&gt;
I just found out that adding this entry in the web.config tells the service to get all of the ram available for himself (selfish service). That is why, it is advisable to add a &quot;boundary&quot; on the use of the RAM. This is only useful if you have one service in your server, thus it is not advisable to add this in production.&lt;br /&gt;
&lt;br /&gt;
One solution that was recommended to me is to check for services or console applications in the server which are not being used. From there, you can terminate (either fully or temporarily) the services in order to free up the RAM.&lt;br /&gt;
&lt;br /&gt;
Here&#39;s the reason behind it (and I&#39;ll be quoting my friend):&lt;br /&gt;
&lt;blockquote class=&quot;tr_bq&quot;&gt;
One WCF application need 5% of total memory to host, for this server 2048MB total memory, u need approx 102MB free space to host a WCF application, if the free space is less than that, u will get that out of memory exception again.&lt;/blockquote&gt;
With that in mind...&lt;br /&gt;
&lt;br /&gt;
Happy coding!
&lt;br /&gt;
&lt;hr /&gt;
&lt;i&gt;Sources:&lt;/i&gt;&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;&lt;a href=&quot;http://msdn.microsoft.com/en-us/library/system.servicemodel.configuration.servicehostingenvironmentsection.minfreememorypercentagetoactivateservice.aspx&quot; target=&quot;_blank&quot;&gt;http://msdn.microsoft.com/en-us/library/system.servicemodel.configuration.servicehostingenvironmentsection.minfreememorypercentagetoactivateservice.aspx&lt;/a&gt;&amp;nbsp;&amp;nbsp;&lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://codeasp.net/blogs/raghav_khunger/microsoft-net/2143/wcf-memory-gates-checking-failed-because-the-free-memory&quot; target=&quot;_blank&quot;&gt;http://codeasp.net/blogs/raghav_khunger/microsoft-net/2143/wcf-memory-gates-checking-failed-because-the-free-memory&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/32548995322316827/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/32548995322316827' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/32548995322316827'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/32548995322316827'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/04/error-memory-gates-checking-failed.html' title='[ERROR] Memory gates checking failed because the free memory is less than 5% of total memory.'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9obKKKSyboBqIxspMzijlJxUc_gGmK7BSQk_nT4iHEngh6z3xFq_I1UFevZJP_-JUWmkKvtn3ONAuAXqc8oqcfah7N3ZTTi8od7YlN-yyG4pfeDWabCO0SzMUNR4vJuAw9QF0pCnhlpg/s72-c/You+Shall+Not+Pass.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-1537292659249149660</id><published>2013-04-08T22:58:00.002-07:00</published><updated>2013-04-11T01:37:39.029-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="c#"/><category scheme="http://www.blogger.com/atom/ns#" term="enums"/><category scheme="http://www.blogger.com/atom/ns#" term="Generic List"/><title type='text'>Convert Enum to List</title><content type='html'>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim4KBwfocXEWj9MLgrcHtBW2OgeQgu5b7uknO46_8tdIHl08p0wDvE-yem2IqnDPCSYAHtWdZbcTX0MMIJS99kYJZ2hk9oBkY-qpwlSif87hw6_QBqSD5lCz6Uutm7pwsmYlM9a9tV5hg/s1600/japanese+meme.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;263&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim4KBwfocXEWj9MLgrcHtBW2OgeQgu5b7uknO46_8tdIHl08p0wDvE-yem2IqnDPCSYAHtWdZbcTX0MMIJS99kYJZ2hk9oBkY-qpwlSif87hw6_QBqSD5lCz6Uutm7pwsmYlM9a9tV5hg/s400/japanese+meme.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
(NOTE: If you want to watch the entire video of this meme, click &lt;a href=&quot;http://www.youtube.com/watch?v=7aVFFlS1uQk&quot; target=&quot;_blank&quot;&gt;this link and laugh&lt;/a&gt;)&lt;br /&gt;
&lt;br /&gt;
One of the requirements is that I want to convert my enums into list. For my case, I would use it populate my dropdown. It would be fine if it were just one enum list. However in the future, there&#39;s a possibility of having multiple enums which I (or the developer) would want to add or create.&lt;br /&gt;
&lt;br /&gt;
After much research, I found that there&#39;s a way for this. Below is the code that I did in order to export these enums.&lt;br /&gt;
&lt;pre style=&quot;background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotJGd4cbW_09uXZ-0uBmxQi6gad2Q1VZr8qrfNdSwXhQfy3WLEEwhCjOSB0Cmv3_G0wz6KYuHfdXZ8KrrDTx-WI_SkFi8Y8MUBT_bWqcrMnUWgyH19DVI2MYbuwHocVDIG0GGwtxDMxk1/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;&quot;&gt;&lt;code style=&quot;color: black; word-wrap: normal;&quot;&gt; public class MyEnums  
 {  
    public enum Enum1  
    {  
      Option1 = 0,  
      Option2 = 1  
    }  
    public enum Enum2  
    {  
      Option1 = 0,  
      Option2 = 0  
    }  
    public List&amp;lt;string&amp;gt; GetEnumList&amp;lt;T&amp;gt;()  
    {  
      if (!typeof(T).IsEnum)  
      {  
         throw new InvalidOperationException();  
      }  
      return Enum.GetNames(typeof(T)).ToList();  
    }  
 }  
 // to implement  
 List&amp;lt;string&amp;gt; myEnumList = Enum.GetValues(typeof(MyEnums.Enum1)).Cast&amp;lt;string&amp;gt;().ToList();  
&lt;/code&gt;&lt;/pre&gt;
&lt;br /&gt;
I hope this would help you to easily export your enums.&lt;br /&gt;
&lt;br /&gt;
Happy coding!!!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/1537292659249149660/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/1537292659249149660' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1537292659249149660'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/1537292659249149660'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/04/convert-enum-to-list.html' title='Convert Enum to List&lt;string&gt;'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEim4KBwfocXEWj9MLgrcHtBW2OgeQgu5b7uknO46_8tdIHl08p0wDvE-yem2IqnDPCSYAHtWdZbcTX0MMIJS99kYJZ2hk9oBkY-qpwlSif87hw6_QBqSD5lCz6Uutm7pwsmYlM9a9tV5hg/s72-c/japanese+meme.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-3780212029233724475</id><published>2013-04-05T23:17:00.003-07:00</published><updated>2013-04-07T18:49:42.973-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".net framework 3.0"/><category scheme="http://www.blogger.com/atom/ns#" term="extension method"/><title type='text'>On Extension Methods: What it is and how to use.</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://28.media.tumblr.com/tumblr_lgu7rrgHAZ1qf44ulo1_500.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;400&quot; src=&quot;http://28.media.tumblr.com/tumblr_lgu7rrgHAZ1qf44ulo1_500.png&quot; width=&quot;388&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
The first time I encountered the term &quot;extension methods&quot; was during my interview in a certain company. The interviewer asked me, &quot;Do you know anything about .Net Framework 3.0?&quot; I said, &quot;Yes.&quot; Then he asked me.&lt;br /&gt;
&lt;br /&gt;
&quot;What are extension methods?&quot;&lt;br /&gt;
&lt;br /&gt;
&quot;... ... ...&quot;&lt;br /&gt;
&lt;br /&gt;
And since then, I researched what extension methods are and all I can say to them is this.&lt;br /&gt;
&lt;br /&gt;
I LOVE EXTENSION METHODS!!!!&lt;br /&gt;
&lt;br /&gt;
Why do I say that?&lt;br /&gt;
Let&#39;s first describe what extension methods are.&lt;br /&gt;
&lt;br /&gt;
Extension methods came into being with the release of .Net Framework 3.0 which &quot;enable[s] you to &quot;add&quot; methods to existing types without creating a new 
derived type, recompiling, or otherwise modifying the original type.&quot; (Source: Msdn) With this, it makes your code simple and readable. Moreover, you can use it in any part of your application. All you need to have is a static class and a static method.&lt;br /&gt;
&lt;br /&gt;
There are two types of extension methods (which, for the time being I would like to call): (1) system extension methods, and (2) user-generated extension methods. System extension methods are those that are inherent since .Net 3.0. You can find this when, for example, you click on the intellisense on the List&lt;t&gt; object. An example of this is in Figure 2.&lt;/t&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSOfLns9GLk4KVlXV1awZrVEIXKmlbU5dyu30bkeIlKJGskPzQ6tl98xcllYhQoYhyffwl_Icp-dh6t0-ztDC5bTLqeDfobwcUy4VHww6cU8TqaO8yEVllj2cMPxdck3Sg_RJwPYW6gXk/s1600/SystemExtension.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;135&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSOfLns9GLk4KVlXV1awZrVEIXKmlbU5dyu30bkeIlKJGskPzQ6tl98xcllYhQoYhyffwl_Icp-dh6t0-ztDC5bTLqeDfobwcUy4VHww6cU8TqaO8yEVllj2cMPxdck3Sg_RJwPYW6gXk/s400/SystemExtension.jpg&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Figure 2: System Extension Methods&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;
Another type are user-generated extension methods which we can use to fulfill our needs when coding. However, we should note that in order to create a good extension method, we should look into these criteria metioned by James Michael Hare:&lt;br /&gt;
&lt;blockquote class=&quot;tr_bq&quot;&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;&lt;i&gt;Apply to any possible instance of the type it extends.&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;&lt;i&gt;Simplify logic and improve readability/maintainability.&amp;nbsp;&amp;nbsp;&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;&lt;i&gt;Apply to the most specific type or interface applicable.&amp;nbsp;&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;&lt;i&gt;Be isolated in a namespace so that it does not pollute IntelliSense.&lt;/i&gt;&amp;nbsp; &lt;/li&gt;
&lt;/ul&gt;
&lt;/blockquote&gt;
So, taking these into consideration, let&#39;s create our basic extension method and we&#39;ll show you the before and after.&lt;br /&gt;
&lt;br /&gt;
I have a code here which converts the seconds into minutes. Before, we need to have create a method per class which converts it. Below is an example of this.&lt;br /&gt;
&lt;pre style=&quot;background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotJGd4cbW_09uXZ-0uBmxQi6gad2Q1VZr8qrfNdSwXhQfy3WLEEwhCjOSB0Cmv3_G0wz6KYuHfdXZ8KrrDTx-WI_SkFi8Y8MUBT_bWqcrMnUWgyH19DVI2MYbuwHocVDIG0GGwtxDMxk1/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;&quot;&gt;&lt;code style=&quot;color: black; word-wrap: normal;&quot;&gt; public class MyClass  
 {  
   public void MyMethod()  
   {  
    int seconds = 3000;  
    decimal minutes = ConvertToMinutes(seconds);  
   }  
   public decimal ConvertToMinutes(int seconds)  
   {  
    return (seconds / 60);  
   }  
 }  
&lt;/code&gt;&lt;/pre&gt;
&lt;br /&gt;
So what if you need to use the method in another class? Surely, you can like create another class, copy-paste this method and just allow it to be used. Or you can create a static class then just use it in other methods. It does look quite &quot;dirty&quot; and not easily understandable.&lt;br /&gt;
&lt;br /&gt;
Let&#39;s try to convert the code above and use extension methods.&lt;br /&gt;
&lt;pre style=&quot;background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotJGd4cbW_09uXZ-0uBmxQi6gad2Q1VZr8qrfNdSwXhQfy3WLEEwhCjOSB0Cmv3_G0wz6KYuHfdXZ8KrrDTx-WI_SkFi8Y8MUBT_bWqcrMnUWgyH19DVI2MYbuwHocVDIG0GGwtxDMxk1/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;&quot;&gt;&lt;code style=&quot;color: black; word-wrap: normal;&quot;&gt; public class MyClass  
 {  
   public void MyMethod()  
   {  
    int seconds = 3000;  
    decimal minutes = seconds.ConvertToMinutes();  
   }  
 }  
 public static class MyExtensionMethods  
 {  
   public static decimal ConvertToMinutes(this int seconds)  
   {  
    return (seconds / 60);  
   }  
 }  
&lt;/code&gt;&lt;/pre&gt;
&lt;br /&gt;
What does this try to say to us? The deciding factor is the this in the parameters of the extension method ConvertToMintues. It simply says that, &quot;I want you to convert the value of seconds&amp;nbsp; into minutes&quot; and that is what the compiler does. You don&#39;t need to compile the class or the project. It automatically shows extension method that you need.&lt;br /&gt;
&lt;br /&gt;
I hope this gives you the basic information on what extension methods are.&lt;br /&gt;
&lt;br /&gt;
Happy coding!&lt;br /&gt;
&lt;br /&gt;
&lt;hr /&gt;
&lt;i&gt;Sources:&lt;/i&gt;&lt;br /&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li&gt;&lt;i&gt;&lt;a href=&quot;http://msdn.microsoft.com/en-us/library/vstudio/bb383977.aspx&quot; target=&quot;_blank&quot;&gt;http://msdn.microsoft.com/en-us/library/vstudio/bb383977.aspx&lt;/a&gt;&amp;nbsp;&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;&lt;i&gt;&lt;a href=&quot;http://geekswithblogs.net/BlackRabbitCoder/archive/2010/04/26/c-extension-methods---to-extend-or-not-to-extend.aspx&quot; target=&quot;_blank&quot;&gt;http://geekswithblogs.net/BlackRabbitCoder/archive/2010/04/26/c-extension-methods---to-extend-or-not-to-extend.aspx&lt;/a&gt;&amp;nbsp;&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;&lt;i&gt;&lt;a href=&quot;http://en.wikipedia.org/wiki/Extension_method&quot; target=&quot;_blank&quot;&gt;http://en.wikipedia.org/wiki/Extension_method&lt;/a&gt;&amp;nbsp;&lt;/i&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/3780212029233724475/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/3780212029233724475' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/3780212029233724475'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/3780212029233724475'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/04/on-extension-methods-what-it-is-and-how.html' title='On Extension Methods: What it is and how to use.'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSOfLns9GLk4KVlXV1awZrVEIXKmlbU5dyu30bkeIlKJGskPzQ6tl98xcllYhQoYhyffwl_Icp-dh6t0-ztDC5bTLqeDfobwcUy4VHww6cU8TqaO8yEVllj2cMPxdck3Sg_RJwPYW6gXk/s72-c/SystemExtension.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-3253900307029791496</id><published>2013-04-02T02:34:00.000-07:00</published><updated>2013-04-02T02:34:03.399-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="error"/><category scheme="http://www.blogger.com/atom/ns#" term="Unit Testing"/><category scheme="http://www.blogger.com/atom/ns#" term="wcf"/><title type='text'>[ERROR] Could not find default endpoint element that references contract in the ServiceModel client configuration section</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAHCfxYEKPcxSxrqli5DcqIw0OxnsH71MsZb9flHya2pYC6Ch_BZoRfICqlv-CXR5bXyggZwQYSyPf3ZxJqC8nL-DTLWR7FgTkNtX44D3sxDhdVPUDw7ZGSpFdRUIZ9LMIU-ah6wbKqkc/s1600/service.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;234&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAHCfxYEKPcxSxrqli5DcqIw0OxnsH71MsZb9flHya2pYC6Ch_BZoRfICqlv-CXR5bXyggZwQYSyPf3ZxJqC8nL-DTLWR7FgTkNtX44D3sxDhdVPUDw7ZGSpFdRUIZ9LMIU-ah6wbKqkc/s320/service.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Three days ago, I got this error which continually bugs me (well, that&#39;s why it&#39;s called a &quot;bug&quot;)&lt;br /&gt;
&lt;br /&gt;
&lt;span style=&quot;color: red;&quot;&gt;Could not find default endpoint element that references contract &#39;ServiceReference1.IContract&#39; in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
This error happened while doing my unit testing, and it turns out that whenever I&#39;m doing my unit tests, &lt;b&gt;the test project does not look into the app.config in the application but looks into its own app.config file.&lt;/b&gt; So what I did was to copy the app.config into the Unit Test project and it worked! &lt;br /&gt;
&lt;br /&gt;
Maybe I need to change my glasses as well.&lt;br /&gt;
&lt;br /&gt;
Happy coding!!!&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/3253900307029791496/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/3253900307029791496' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/3253900307029791496'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/3253900307029791496'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/04/error-could-not-find-default-endpoint.html' title='[ERROR] Could not find default endpoint element that references contract in the ServiceModel client configuration section'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAHCfxYEKPcxSxrqli5DcqIw0OxnsH71MsZb9flHya2pYC6Ch_BZoRfICqlv-CXR5bXyggZwQYSyPf3ZxJqC8nL-DTLWR7FgTkNtX44D3sxDhdVPUDw7ZGSpFdRUIZ9LMIU-ah6wbKqkc/s72-c/service.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-8550043570632565513.post-8222104834744645327</id><published>2013-03-24T19:48:00.000-07:00</published><updated>2013-03-24T19:58:40.235-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term=".net framework 4.0"/><category scheme="http://www.blogger.com/atom/ns#" term="Unit Testing"/><title type='text'>Catching exceptions in Unit Testing</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;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://d2o0t5hpnwv4c1.cloudfront.net/1065_exceptions/images/whatareexceptions.png&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;305&quot; src=&quot;http://d2o0t5hpnwv4c1.cloudfront.net/1065_exceptions/images/whatareexceptions.png&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
If you&#39;re slightly new to Unit Testing (like me) and you want to catch exceptions which are thrown by the application, there&#39;s simple line that you need to add to your test method.&lt;br /&gt;
&lt;br /&gt;
&lt;pre style=&quot;background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiotJGd4cbW_09uXZ-0uBmxQi6gad2Q1VZr8qrfNdSwXhQfy3WLEEwhCjOSB0Cmv3_G0wz6KYuHfdXZ8KrrDTx-WI_SkFi8Y8MUBT_bWqcrMnUWgyH19DVI2MYbuwHocVDIG0GGwtxDMxk1/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;&quot;&gt;&lt;code style=&quot;color: black; word-wrap: normal;&quot;&gt; [TestMethod]  
 [ExpectedException(typeof(ArgumentException), &quot;Unable to retrieve records&quot;)]  
 public void NullUserIdInConstructor()  
 {  
   // Arrange  
   List&amp;lt;string&amp;gt; testList = new List&amp;lt;string&amp;gt;();  
   PhoneController ctrl = new PhoneController();  
   UserPhone phone = new UserPhone  .
   { PhoneNumber = &quot;234123&quot; };  
   // Act  
   testList = ctrl.RetrieveUserPhoneRecord(phone);  
  // Assert  
  Assert.IsNotNull(testList);  
 }  
&lt;/code&gt;&lt;/pre&gt;
&lt;br /&gt;
In your test method, you need to add the &quot;Expected Exception&quot; attribute which checks if the application will throw an exception. Given that the &lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;, Courier, monospace;&quot;&gt;testList &lt;span style=&quot;font-family: inherit;&quot;&gt;would &lt;/span&gt;&lt;/span&gt;always have values, it will also check if there are other exceptions thrown by the application&lt;br /&gt;
&lt;br /&gt;
However, I think it would be great if they could move this to the &lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;Assert&lt;/span&gt; class so that it will be in one package...&lt;br /&gt;
&lt;span style=&quot;font-family: inherit;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: inherit;&quot;&gt;Well, just my thoughts...&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: inherit;&quot;&gt;&lt;br /&gt;&lt;/span&gt;
&lt;span style=&quot;font-family: inherit;&quot;&gt;Happy coding! &lt;/span&gt;&lt;/div&gt;
</content><link rel='replies' type='application/atom+xml' href='http://onehappycoder.blogspot.com/feeds/8222104834744645327/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/8550043570632565513/8222104834744645327' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/8222104834744645327'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/8550043570632565513/posts/default/8222104834744645327'/><link rel='alternate' type='text/html' href='http://onehappycoder.blogspot.com/2013/03/catching-exceptions-in-unit-testing.html' title='Catching exceptions in Unit Testing'/><author><name>don_simoun</name><uri>http://www.blogger.com/profile/17760678383755299208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='17' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSwDcrIwQv9as_WjD-csNRBFtubOo0pyL7yTlFrpU6vaBMRAaiKqiAVXMnfx_TaAuYKxAAhYitpAJNGGkaZCPMiQ1AcUkYWz4BYgC-7woUcgP60euPLBoVjpywJCzpVA/s220/don-simoun.jpg'/></author><thr:total>0</thr:total></entry></feed>