C# Corner

Resources  
  • Different Components Of SeleniumFeb 21, 2018. As we know, Selenium is the most popular tool used for automating web browsers / web applications. Selenium is an open source tool, which is used to execute the test scripts or test cases on the web application.
  • Sync Slicers In Power BIFeb 16, 2018. In this article, we will talk about the sync slicer, steps to apply “Sync” slicers in Power BI Desktop and different use cases to test this new rolled out feature in the February 2018 update.
  • Creating And Configuring A MySQL Server On The Azure PortalFeb 10, 2018. This article demonstrates how to create a MySQL database on the Azure Portal.
  • Automating SVN Check-Ins And Building A Project Via JenkinsFeb 05, 2018. A few weeks back, while sitting with my team, I learned that they run a Jenkins job which has to execute the automation scripts using the robot framework, daily around 1:00 a.m. The primary purpose of the job is to place all the necessary files and folders over the node machine of Jenkins (after copying them from the machine pointed as master on Jenkins), execute those scripts accordingly, generate the reports, and finally copy the output files back to the master machine to analyze the logs for the overall reporting and analysis purposes. This whole efficient job starts with a slack manual step which was enough to tag this activity 'not fully automated' because they had to place the updated work regularly on the specified path over the master machine before leaving the office (this includes taking the updated code, files, and automation scripts, building the project to take the DLLs etc.). This may sound tedious but more than that, there is no sense to do it manually.
  • Angular 5 HTTP Client InterceptorsJan 25, 2018. Many of us know the concept of middleware. It acts as the layer before sending a request and after receiving a response. What if we want to do the same in Angular? Now, the question arises what will be the cases where we will be needing this middleware.
  • CRUD Operations In SharePoint Using REST API - CREATE OperationsJan 18, 2018. REST API is a powerful CSOM concept that can be leveraged in SharePoint for converting sophisticated business designs into working and efficient SharePoint Artifacts (Add-Ins, CSOM solutions, etc.). REST does not require any separate references for its working unlike other frameworks (SPservices!)
  • App.Config AutoReaderJan 17, 2018. In our day to day development, it is a rare case where we don’t need to read a configuration file. There are many techniques for the treatment of such static classes, singleton classes, etc and it is normally that the Config class is accessible in all projects.
  • Stored Procedures In Azure Cosmos DBJan 16, 2018. There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures are stored at server side.
  • Identity Server 4 With ASP.NET Core 2.0Jan 16, 2018. OAuth 2 provides several flows or grant types for various use cases. I personally group them into two categories; flows that require user interaction with authorization server and flows that don’t.
  • An Introduction To Q#Jan 15, 2018. In this article, I will be explaining about Q# - the new programming language introduced by Microsoft for quantum computing. We will understand the data type, expressions, and statements of Q# with the help of code snippets.
  • Observables With Angular 5Jan 12, 2018. We have a case where we use observable to populate the UI from the external data asynchronously Angular uses same thing for this task let’s see how we can use the observables and use them in an angular application.
  • ASP.NET Core 2.0 Cookie AuthenticationJan 02, 2018. Cookie Authentication allows developers to hook into events at various lifecycle stages of the authentication process. For instance you could log successful sign-ins using OnSignedIn or use OnValidatePrincipal (runs on every request) to invalidate the user (e.g. if you want to force sign-out).
  • Creating A C# Console App From My iPhoneJan 02, 2018. Hyper IDE [link to https://github.com/polterguy/hyper-ide] is an Open Source web-based Integrated Development Environment. It supports 100+ progamming languages out of the box, and can be integrated with any type of command line tools, such as Git, compilers, etc. This leads to some interesting traits, such as the ability to actually create for instance C# console apps, from the browser on your phone. For the record, writing code on a phone, is not easy, and not something I encourage people to do in general. However, the border line use cases have interest.
  • Setting Up Add-In Development Environment In SharePoint Server 2016Dec 26, 2017. In this article, I have explained how to configure Sharepoint add-ins development environment and create a simple hello world web part in s=Sharepoint server 2016 on-premises.
  • Build Scalable Web Applications With Azure Database For MySQLDec 26, 2017. Azure Database for PostgreSQL and Azure Database for MySQL bring together community edition database engines and capabilities of a fully managed service—so you can focus on your apps instead of managing a database. See how the service helps you quickly respond to changing customer needs by scaling up and down. And see how capabilities like high availability and replication help you meet and exceed customer expectations.
  • ASP.NET Core 2.0 Tag Helper ComponentDec 18, 2017. In case you’re wondering if the solution above is missing a Tag Helper for head HTML element, it’s not. ASP.NET Core team has provided us with two built-in Tag Helpers, one targets head and the other targets the body element: HeadTagHelper and BodyTagHelper.
  • MySQL Data Access API Development Using Express.JS, Node.JSDec 14, 2017. In this article, we are looking into introduction of Node.JS, Express.JS and then I am going to create Simple MySQL data access API using Express.JS, Node.JS.
  • What XSLT Transformation Is And How To Use ItDec 12, 2017. XSLT (Extensible Stylesheet Language Transformations) is a language for transforming XML documents into other XML documents. Sometimes the user wants to some kind of xml structure instead of whole xml; In that case we can use XSLT transformation. This article gives us idea about this.
  • Difference Between MySQL DATETIME And TIMESTAMP DataTypesNov 29, 2017. A simple question that may come to one's mind while working with MySQL is "Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though they store the same data, they differ in some ways and let's check those things out with the help of a small example.
  • Pug Vs HTMLNov 26, 2017. In the holy wars of "Pug vs HTML", it is really confusing sometimes to realize which one of these to use. The same is true for SQL vs NoSQL, and the similar is true for Java vs Python. Then people think why not talk about Pug vs HTML as well. HTML is always the perfect language to consider, however for the case of Pug there might be a bit of confusion. Some developers don't know Pug, and some who know it, know it as a Jade framework.
  • Introduction To SQL Operations Studio And Connecting It With SQL ServerNov 20, 2017. Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
  • How To Add A Button To Existing Ribbon Tab In Office ApplicationsNov 16, 2017. This article is a walk through of adding a button on the Ribbon of an existing tab in Office Application (Word 2016 in this case).
  • DROP IF EXISTS In SQL Server 2016Nov 13, 2017. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the object exists to drop. If we miss writing the check and if the object is not available, then we are being served with an error message. With SQL Server 2016, now we can check the existence of the respective object without any error being generated.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part TwoOct 14, 2017. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always Encrypted feature. In case, if you have missed out the first part of the series.
  • Getting Started With SharePoint Framework For SharePoint 2016 On-PremisesOct 12, 2017. Once you have installed and upgraded the September 2017 Public Update for SharePoint 2016, you will be able to upload and deploy SharePoint Framework packages that contain web parts via the SharePoint App Catalog just as you would with SharePoint Add-ins.
  • Shared Storage Using Azure File ServiceOct 10, 2017. In most cases, the virtual disks we are creating for an Azure VM are connected to that particular VM with a 1:1 relationship which can’t be accessed by another VM at the same time. In case you need a shared storage by multiple VMs you should use Azure File Shares. Azure File shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. This is mostly used in case of any requirement of something like a shared application setting or if you need to share any tools or utilities between developers and administrators.
  • ASP.NET - Connect to MySQL Azure DatabaseOct 07, 2017. Using MVC, Entity Framework, ASP.NET Scaffolding, and Azure MySQL you can create a web application that stores your information on an MongoDB Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a MySQL Azure database.
  • Default(T) In GenericsSep 27, 2017. Default represents default value of T parameter in generics intructions. In several cases, the default keyword is an absolute unknown and we think it’s unnecessary or its functionality is null. There are many development moments with the generics classes where the default keyword can be useful.
  • XAML Value Converter With A Simple ExampleSep 27, 2017. In this article, I'm going to show you how you can use value converter in XAML to convert one format of data into another format. In our case, we'll convert a string value (value in the textbox) to a Boolean value (checked status of a checkbox).
  • 35 Essential Basic-Advanced SQL Query-Questions Asked In Technical InterviewsSep 19, 2017. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
  • How To Apply Disclaimer On External MailsSep 09, 2017. In this article, we are going to see how to add a disclaimer statement on external emails.
  • Swift Programming - Zero To Hero - Part FourSep 06, 2017. In this article, we will learn about arrays and accessing arrays using looping statements
  • Where Can I Use Common Azure CosmosDB (Use Cases)?Sep 06, 2017. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service for managing data at planet-scale. It builds upon and extends the earlier Azure DocumentDB which was released in 2014.
  • Connecting To MySql Database In StrapiSep 04, 2017. This article helps you to create a connection to the My SQL database using the Strapi; this is an article for the beginners where the basic connection can be created with the existing MySQL database.
  • Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
  • Setup Of Virtual Machines On Azure Using TerraformSep 01, 2017. Microsoft recently announced increased investment in integrating Terraform with Azure (Aug 2017). This is a continuation of Microsofts’ reach into the agnostic/multi-cloud cloud arena, where they are doing whatever it takes to help developers succeed in the cloud. It used to be the case that Azure was only for Micosoft developers - well no more. The crew in Redmond and every office around the globe are really pushing the open-source and 'Azure for everyone' opportunity.
  • Async Validation In WPFAug 31, 2017. Quite often validation requires web requests, database calls or some other kind of actions which require significant amount of time. In this case, UI should be responsible during the validation, but saving/submitting data should be disabled until validations completion.
  • Availability Of Azure Database For MySQL And Azure Database For PostgreSQL In IndiaAug 26, 2017. In Indian data centers (Central and West India), the public preview of Azure Database for MySQL and Azure Database for PostgreSQL are available. And their services provide app developers the ability to choose from an even wider number of geographies, and deploy their favorite database on Azure, without the complexity of managing and administering the databases.
  • Create Office Web Add-In Project Using Visual StudioAug 24, 2017. In this article, I would like to share the steps to create Office web add-in projects using Visual Studio. In this article, we have explored what Office add-ins are and how to create Office web add-in projects using Visual Studio 2015.
  • Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
  • Swift Programming - Zero To Hero - Part ThreeAug 17, 2017. Statements are the building blocks of any program. We can perform any function with the help of statements, such as checking values or declaring variables, calling methods, or even creating objects.
  • Swift Programming - Zero To Hero - Part TwoAug 08, 2017. This is part two of Swift Programming Zero to Hero. In this article we will see loops in Swift.
  • Execution Of Test Cases In Sequential Order Using Selenium Webdriver - Part TwoJul 26, 2017. In my previous article of "Execution Of Test Cases In Sequential And Parallel Using Selenium Webdriver" we learned the usage of selenium webdriver
  • Execution Of Test Cases In Sequential And Parallel Using Selenium WebdriverJul 18, 2017. Selenium is an open source tool, which is used to execute the test scripts or the test cases on web applications. As we know Selenium is an open source tool, which supports various programming languages such as Java,C#, PHP,JavaScript, Ruby etc. Selenium supports various operating systems to execute the test scripts on web applications like Windows, Linux, MacOS etc. Selenium is written using one of the famous programming languages; i.e. Java, and its a cross-platform.
  • Preliminary Practices On Python ProgrammingJul 17, 2017. This article describes the basic concept of Python programming including program syntax, data types, looping & conditional statements and more
  • PowerShell Script To Move List Of Users To Office 365 And Assign Them O365 LicensesJul 07, 2017. Office 365 is a SaaS platform which is being used by many organizations these days and it can become quite hard for IT administrators to onboard their users to Office 365 manually .Of course , this may not be the case when your user identities get synced to Azure AD from on-premises AD using AAD connect tool.
  • Simulate SharePoint Online Timer Jobs Using Azure FunctionsJul 05, 2017. SharePoint Server provides native Timer Jobs that inherit SPJobDefinition class to run at regular intervals defined in the SPSchedule object. This way we can create solutions that have to be iteratively run to process logic at regular intervals. However, in case of SharePoint Online Native Timer Jobs cannot be used.
  • Understand The Power Of Windows PowerShell Pipeline ( | )Jun 26, 2017. Windows PowerShell pipeline allows us to join two or more statements with a pipe symbol, sometimes called the '|' bar key. This tells PowerShell that we want to take the output of one command and pass it as the input to the next command. Let’s look at simple example to better understand the power of pipeline in Windows PowerShell.
  • C# Conditional Statements In UnityJun 19, 2017. In this article, I am going to explain about C# conditional statements in Unity.
  • Code Improvement Techniques In C#Jun 13, 2017. General code improvement technique over string.empty, string.Equals, string.Intern, StringBuilder, string.Format, case insensitive comparisons, using Block and Linq - First, FirstOrDefault, Single and SingleOrDefault. Main focus points are - what are the advantages and the purpose to use these.
  • Azure Traffic Manager - Part TwoMay 17, 2017. In part one, we saw how to work with geographic regions. In this we will see about performance which will switch the endpoints in case of failure.
  • How To Connect MySQL With ASP.NET CoreApr 28, 2017. In this article, you will learn how to connect MySQL with ASP.NET Core.
  • Developers Use Case For .NET API BrowserApr 24, 2017. This article illustrates a developer's use case for .NET API Browser.
  • Test Driven Development (TDD) - Part ThreeMar 29, 2017. This article explains how to use the new features of Visual Studio to speed up the unit test case creation.
  • Assigning Case To Appropriate Team User Using Plugin In Dynamics 365/ CRMMar 15, 2017. In this article, you will learn about a Plugin to assign a case record to the user in the team with the least number of cases.
  • Test Driven Development (TDD) - Part TwoMar 14, 2017. This article explains the options available in Visual Studio to work with Test Driven Development and also present examples about writing unit test cases.
  • Steps To Debug/ Run Selenium Test Cases From Eclipse IDMar 01, 2017. In this article, you will learn the steps to debug/ run Selenium test cases from Eclipse ID.
  • Getting Started With O365 - SharePoint-Hosted Add-Ins Using JSOMFeb 28, 2017. In this article, you will learn about SharePoint-hosted add-ins, using JSOM.
  • Deleting SharePoint-Hosted Add-In Using Napa Office 365 Development ToolFeb 23, 2017. In this article, you will learn how to delete SharePoint-Hosted Add-ins using Napa Office 365 Development Tool.
  • SharePoint-Hosted Add-In By Using NAPA Tools And Delete SharePoint Task List Item Using JSOMFeb 22, 2017. In this article, you will learn about SharePoint-hosted add-ins by using NAPA Tools and Delete SharePoint Task List item using JSOM.
  • Working With e-Discovery Case, e-Discovery Set And In-Place Hold In SharePoint OnlineJan 26, 2017. In this article you will learn about working with e-Discovery Case, e-Discovery Set and In-Place hold in SharePoint Online.
  • Switch Statement - A Code SmellJan 07, 2017. This article will explain the code issues, using the Switch.. case statement. In some cases, it is a type of code smell.
  • Creating Web API Using Node.js And MySQLDec 01, 2016. In this article, you will learn how to create Web API using Node.js and MySQL.
  • Handling Permissions In Linux VM While Migrating WordPress SiteOct 27, 2016. In this article, I'll write about how to give WordPress plug-ins permission, while migrating or maintaining the backup of your site.
  • Writing JavaScript Tests Using Jasmine FrameworkOct 11, 2016. In this post, we will see how we can write unit test cases in JavaScript.
  • Creating SharePoint Hosted Add-ins In SharePoint Server 2016Sep 25, 2016. In this article, you will learn how to create SharePoint Hosted Add-ins in SharePoint Server 2016.
  • AngularJS Case Sensitivity And Default Route With UI-RouterSep 17, 2016. In this article, you will learn about AngularJS case sensitivity and default Route with UI-Router.
  • Configure Environment For Add-Ins In SharePoint 2016Sep 16, 2016. In this article, you will learn how to configure environment for add-ins in SharePoint 2016.
  • Java Struts2 And Hibernate4 CRUD With MySQL With Pagination, Sorting And Export Option Using NetbeansSep 11, 2016. In this article, you will learn about Java Struts2 and Hibernate4 CRUD with MySQL with pagination, sort and export option, using Netbeans.
  • MySql Database In ASP.NET Using C# With ODBC ConnectorSep 11, 2016. In this article, we are going to learn, how to connect MySql database in C# .NET with ODBC Driver.
  • Selenium Automation Test Cases For The .NET Web ApplicationAug 14, 2016. In this article, you will learn about Selenium Automation test cases for the .NET Web application.
  • Protractor Automation Test Cases For AngularJS UIAug 11, 2016. In this article, you will learn about protractor automation test cases for AngularJS UI.
  • Unit Testing With MS Tests In C#Jul 26, 2016. In this article, I am going to explain the uses of unit testing and writing unit test cases in C#.
  • Creating API In Node.jsJul 22, 2016. In this article, you will learn how to create API in Node.js.
  • Export To Excel In PHP With MySQLJul 16, 2016. In this article, you will learn how to export to excel in PHP with MySQL.
  • Update Column In Database For A Table Having Upper Case ValueJul 06, 2016. In this article, you will learn how to update the column value that has an upper case.
  • How To Setup VM On Azure For PHP WebsitesJul 04, 2016. In this article, you will learn how to set up a VM on Windows Azure, deploy your PHP & MySQL based Website, and get full control over it.
  • Resolve "Member Name Cannot Be the Same as Enclosing Type" ErrorJun 30, 2016. In this article we will see some cases of the error "member name cannot be the same as enclosing type" and then we will resolve it with examples.
  • Login Service In PHP And MySQL For Android ApplicationsJun 28, 2016. In this article, you will learn login service in PHP and MySQL for Android Applications.
  • Learn MySQL Queries With ExamplesJun 23, 2016. In this article, you will learn select, update and delete statements in MySQL queries with examples.
  • SharePoint 2013: Remote Event Receivers On List Item Event - Real Business ScenariosJun 03, 2016. In this article you will learn about Remote Event Receivers and applicable business cases around the Remote Event Handlers.
  • Converting A String To Different Cases And HumanizerMay 30, 2016. In this article, you will learn ways to convert a string to different cases, for example Upper case, Lower case, Title case (capitalize each word), Camel case, Pascal case, Sentence case, Toggle case or converting a string to a sentence using C# code.
  • SharePoint Add-ins (SharePoint Hosted Add-in) - Part TwoMay 28, 2016. In this multi part series, this is part two. In this article I’ll try to cover SharePoint hosted add-in with example.
  • Protect Your Data: Prevent SQL InjectionMay 27, 2016. SQL injection is a code injection technique, used to attack data-driven applications, in which nefarious SQL statements are inserted into an entry field for an execution. How to prevent SQL Injection to protect your data is being imparted through this article.
  • Hibernate and Primefaces CRUD Using NetBeans 8.02 and MySQL Database ServerMay 25, 2016. In this article you will learn about Primefaces 5 and Hibernate 5 CRUD using NetBeans 8.02 and MySQL Database Server.
  • Upgrade SharePoint Hosted Add-Ins(Apps) in SharePoint 2013May 22, 2016. In this article you will learn how to Upgrade SharePoint Hosted Add-Ins(Apps) in SharePoint 2013.
  • SQL Server: Get Last Updated Column Value in GROUP BY StatementMay 22, 2016. In this article you will learn how to get last updated Column Value in GROUP BY Statement SQL Server.
  • Car Rental Web PortalMay 19, 2016. This web portal is designed for a ren- a-car services provider where the user can visit and book their required vehicle online and select their vehicle, duration, driver option etc.
  • SharePoint Add-ins (SharePoint App) - Part OneMay 16, 2016. In these multi part series, I’ll try to cover all the details related to SharePoint Add-ins (SharePoint App). In this article I’ll start with the introduction/basics of SharePoint Add-ins.
  • Tag Helpers In MVC 6May 10, 2016. This article explains in a simple manner what are tag helpers in MVC 6, why do we need tag helpers over the HTML helpers provided by the previous versions of MVC and a simple implementation of a use case using tag helpers.
  • How To Install Apache, MySQL, PHP (LAMP) Stack On Azure Linux VMMay 02, 2016. In this article you will install Linux, Apache, MySQL, PHP (LAMP) Stack on Azure Linux VM in Azure Portal by using PUTTY.
  • How To Import Large SQL Database Files Into MySQL Using Command LineApr 30, 2016. In this article you will learn how to Import large SQL Database Files into MySQL using Command Line.
  • Stored Procedure In MySQLApr 12, 2016. In this article you will learn about stored procedure in MySQL.
  • JSP and Hibernate CRUD application With Pagination, Sorting and export option using NetBeans IDE And MySQL 5Apr 12, 2016. In this article you will learn how to create a JSP CRUD application with Pagination, Sorting and export option using NetBeans IDE and MySQL 5.
  • Install MySQL On WindowsApr 11, 2016. In this article you will learn how to Install MySQL on Windows.
  • SQL Server: Use CASE in WHERE ClauseApr 07, 2016. In this article I am going to show how we can use CASE in WHERE clause.
  • Looping Statements In C# - Part TwoMar 07, 2016. In this article you will learn looping Statements in C#. This is part two of the series.
  • Create A Linked MySQL To SQL ServerFeb 29, 2016. In this article you will learn how to create a linked MySQL to SQL server.
  • Looping Statements In C#: Part OneFeb 27, 2016. In this article you will learn about some looping statements in C#. It will also include single as well as nested loops.
  • Introduction to Knockout.JS - Part FourFeb 15, 2016. In this article we are going to understand the control flow statements in Knockout.js. This is part four of the series.

About case-statement-in-MySQL

NA
Web Development Outsourcing
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.