C# Corner

Resources  
  • Angular, Bootstrap and ASP.NET MVC - Bootstrap Form Controls - Part EightFeb 23, 2018. In previous articles we have learned AngularJS project setup, styling with Bootstrap, AngularJS structure, data-binding, routing, copying of Angular objects when a form is saved or canceled, inserting/updating forms, Bootstrap modal forms, and more.
  • Insert And Display Records With Model Binder Using ASP.NET MVCFeb 23, 2018. In this blog, I am going to explain how to insert and display records with Model Binder using ASP.NET and Entity Data Model (DB First Approach).
  • What Does This Little Check Box DoFeb 21, 2018. Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get very tempted to check them. Here is one of those tempting little boxes that seems pretty handy. Use query governor to prevent long running queries.
  • Learn Angular 4.0 In 10 Days - AJAX Request Handling - Day EightFeb 20, 2018. In this article, we will discuss how we can handle AJAX requests for fetching or sending data using Angular 4.0.
  • How To Fetch Data From Task List Using Rest For Workflow History In SharePoint OnlineFeb 20, 2018. I got a requirement to make a history form for a workflow. For that, I had to fetch the data from a task list. We can use Rest API, SP Services, or any other methods for this kind of task. So, I chose REST API for the same. Now, the question is, what will be the scenario? Because Workflow status columns of Assign to and Modified Date are not available in the normal list. Then, I learned that we can fetch it from the task list or history list as in workflow all the information resides in Task list & History List.
  • SQL Database Query Editor In Azure Portal - An IntroductionFeb 19, 2018. Learn SQL Database Query Editor In Azure Portal.
  • VLFs - The Forgotten FoeFeb 19, 2018. How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
  • Import And Export Data Using EPPlus.CoreFeb 19, 2018. In this post, we will see how we can import and export excel data in Asp.net Core. We are using EPPlus.Core library which helps us to perform import and export operations. I hope you will like it.
  • Using jQuery DataTable To Display SharePoint 2013 List Data On SharePoint Site PagesFeb 17, 2018. In this article, we will learn how to pass SharePoint List Data to a jQuery DataTable using REST API and display SharePoint list data on SitePages using DataTable.
  • Download User License Information For PowerApps And Microsoft FlowFeb 16, 2018. PowerApps is one of the services available in the Office 365 environment that enables us to create apps or forms for business and other uses without coding experience. We can connect against external data sources like SQL, SharePoint, Salesforce, etc... to develop an application. PowerApps has its own data source called Common Data Service.
  • WPF - Dropdown Menu/Combobox Menu Data Binding Using Text FileFeb 16, 2018. This article is about WPF dropdown menu/combobox menu data binding using text file
  • How To Get Started With Always Encrypted For Beginners - Part ThreeFeb 15, 2018. A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this solution for a client. The goal of the project was to prevent the DBA from being able to view salary information, while still allowing the application to function without issue.
  • Publish ASP.NET Core 2.0 Application On Azure With SQL ServicesFeb 15, 2018. In this article, we will learn how to deploy or publish an Asp.Net Core 2.0 application on Azure.
  • SQL Coding Best PracticesFeb 14, 2018. While executing your procedure, the system will first scan through all system procedures and then user defined procedures. This means that the procedure might take more time for execution thus decreasing system performance.
  • Pipes In Angular 5Feb 13, 2018. In this article we will be discussing Pipes in Angular 5. Pipes are the operators which is used to format data in Angular. This comes from the symbol (|) used to do this operation. Pipes are there in Angular from Angular2 onwards. But it has evolved over the period of time. There are many inbuilt pipes available in Angular 5 and it gives an easy template to create your own pipe using @angular/cli.
  • Stack, Heap, Value Type, And Reference Type In C#Feb 13, 2018. Now, let’s see what happens when we declare any variable like int a=10 in C#. When C# compiler will run, it will allocate a block of memory which will have name of variable i.e. a, its type i.e. int and its value i.e. 10. Now this memory can be of type Stack or Heap i.e. variable gets store in Stack or Heap.
  • How To Get Started With Always Encrypted For Beginners - Part TwoFeb 12, 2018. In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them inside SQL Server Management Studio or through our applications. You’ll be surprised to see how easy it is.
  • Increase Data Disk Size In AzureFeb 11, 2018. Retaining data in the same VM requires us to increase the disk space when the utilization of allocated space is full. Increasing the disk space in Azure is quite easy with a few clicks.
  • Work With CDN On Azure Storage - Part FiveFeb 10, 2018. This article will help you to work on Azure Storage by adding CDN (Content Delivery Network) to access data with high availability.
  • Amazing Guide To SharePoint Framework Development With React - Part TwoFeb 09, 2018. In my previous article, we walked through how to create a SharePoint Framework web part with React to display the mockup contents step by step. We will continue the same source for displaying the SharePoint data in the web part.
  • How To Get Started With Always Encrypted For Beginners - Part OneFeb 08, 2018. Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database.
  • Introduction To LINQ With Entity Framework In Visual StudioFeb 08, 2018. LINQ queries are similar to SQL query created for developers to maintain standardized coding approach. It deals with the data objects therefore it is similar to OOPs.
  • Synchronous VS Asynchronous Statistics UpdatesFeb 07, 2018. Implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously.
  • Introduction To Microsoft Cloud App SecurityFeb 06, 2018. Security is the million-dollar question for organizations who are moving to the cloud from on-premise. They want their data and applications to be as secure as possible from attacks like phishing, hacking, data breaches, insecure APIs, and recent threats that have come up, namely Ransomware and WannaCry. Like other IT giants, Microsoft is working hard to get its cloud security tight using various tools and technologies, and one of them is Cloud App Security.
  • Cursors In SQL ServerFeb 06, 2018. A cursor is a database object which is used to retrieve data from result sets one row at a time.The cursor can be used when the data needs to be updated row by row.
  • SQL Sequence Vs Identity ColumnFeb 06, 2018. Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever notice it under Programmability in Management Studio. Yep it’s there, SQL Server has this very handy thing called Sequences. Sequences are a relatively new feature that have only existed since SQL Server 2012, but have long existed in Oracle (where there a no identity columns).
  • Properties Of Object.prototype In JavaScriptFeb 05, 2018. Object.prototype is used to inherit properties and methods to the Constructor method, it may be overridden. We can use any constructor to create the object of another type with the help of Object.create() method and assign to the new constructor prototype.
  • How To Create A Simple Approval Flow For SharePoint List From Built-In TemplateFeb 05, 2018. Microsoft Flow is a service that helps you create automated workflows between your favorite apps and services to synchronize files, get notifications, collect data, and more.
  • Learn About Machine Learning BasicsFeb 02, 2018. Machine Learning is the booming research area across the Globe. Advances in Machine Learning will make a big difference in many fields in future. This is a vast area in which there are many types of algorithms embedded in it. This article will help you get started with Basics of Machine Learning.
  • Building A Simple Working Memory Game App With Web API And SignalRFeb 02, 2018. This article will walk you through how to build a simple data-driven mobile game application using the power of Xamarin and Web API. We will also build a real-time leader board page using ASP.NET SignalR.
  • CRUD Operation In MVC Using Kendo UIFeb 01, 2018. In this article, you will learn how to fully enable the Create, Read, Update, Destroy (CRUD) data operations in the Grid in Asp.Net MVC using Kendo UI.
  • How Can You Integrate A JSON Framework With iOSFeb 01, 2018. JavaScript Object Notation, or JSON in short, is commonly used for representing structural data and data interchange in client-server applications, serving as an alternative to XML. It has grown in popularity as it is simple to use and human-readable. It is technically a part of the JavaScript language and provides a way to serialize JavaScript objects. It is supported in a wide variety of programming languages. A lot of the services used every day have JSON-based APIs.
  • Client Side Development With SharePoint Using NodeJS And PnPJan 30, 2018. Nowadays, client side development with SharePoint is growing bigger and bigger with lot of APIs emerging against SharePoint data. @PnP (PnPJS) is a new javascript API from SharePoint Patterns and Practices team.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part TwoJan 30, 2018. Normally, you would want to put your css classes in the .scss file (i.e. YourWebpartName.scss) and import it into the YourWebpartName.ts file (this is actually done automatically during project creation). But I decided to put it in a SharePoint list because my css selectors are grouped and I could not reference them using "styles.selector".
  • Basics Of Angular And Its Versions - Part FiveJan 29, 2018. To deal with asynchronous data Angular provides two models of approaches, we can either use Promises or Observables.
  • Linq To Excel In ActionJan 29, 2018. In this post, we will demonstrate how we use LinqToExcel library to query data from Excel.
  • How To Validate XML Using XSD In C#Jan 29, 2018. Extensible Markup Language (XML) is used to describe data. The XML standard is a flexible way to create information formats and electronically share structured data via the public Internet, as well as via corporate networks. The XML tags are not pre-defined in XML. You will have to create tags according to your needs.
  • Basics Of Angular And Its Versions - Part FourJan 28, 2018. The goal of an Angular team is to provide better performance in a optimized way which results in faster page loading and quicker change detection. So, an Angular team provides two types of compilers and both have their own pros and cons. Based on the need we have to select the compiler.
  • Cache Tag Helper In ASP.NET Core MVCJan 25, 2018. Caching tag helper can improve the performance and scalability of the application dramatically and it cache the data into the internal ASP.NET Core cache provider.
  • Top Five Developer Trends Of 2018Jan 25, 2018. The year 2017 has been one of the most exciting years for developers and technology lovers. Technologies such as big data, machine learning, Internet of Things (IoT), artificial intelligence, drones, autonomous vehicles, wearables, virtual reality, and smart homes are some of the fastest growing innovations.
  • Retrieving List Items From A Specific View Using CSOMJan 25, 2018. In this article, you will learn how we can access the SharePoint data using Client Object Model. Here, I have taken an example of getting the data from SharePoint list specific View. Using this, we can create our own custom View with necessary fields and access them.
  • SharePoint Online Automation - Increase SharePoint Storage Quota In SharePoint Online Using PowerShellJan 24, 2018. As we know when a site collection is created in SharePoint online, we must specify a storage quota. This site size value must be between 100 MB and 100 GB. We will discuss more about site collection quota and usage in the next article.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part OneJan 24, 2018. Supposing there is an existing data in an SQL database, be it Azure or an on-premise database server, you are required to make the data available for CRUD operations in SharePoint for your users. This is a scenario where this article will be of help to you. In this article, I will show you how you can perform CRUD operations on Azure SQL database from a SharePoint web part. Note that the steps are same for on-premise SQL database except for the steps required in setting up Azure database.
  • An Overview Of Power BI Route Map VisualJan 24, 2018. Power BI Route Map Visual is used to define the track of travelling objects on a map. We can achieve this visualization by connecting data containing fields like date time, latitude and longitude of route, start and destination location and route sequence.
  • Dynamic Menu Generation With Web API And AngularJan 24, 2018. In this article, we are going to implement a dynamic menu with the help of ASP.NET Web API and Angular. We will create the login page that has two login type. Admin and User. Admin login will lead to some different menu items and User login will come up with different menu items.
  • CRUD Operation With Angular 5 HTTP Client And ASP.NET Core Web APIJan 23, 2018. HTTP is the messaging system between the client and the server-client which sends the request and server responds with the proper message. Angular HTTP client is the toolkit which enables us to send and receive the data over the restful Http endpoints.
  • Converting SQLite Database To Excel And Excel To SQLite Data In AndroidJan 23, 2018. In this article, we will learn how to export Android SQLite Database to Excel or Import Excel into SQLite Database. We can use SQLiteToExcel library to perform these functionalities.
  • Top 10 New Features Of ASP.NET Core 2.0Jan 22, 2018. .NET is now .NET Core and known as cross-platform and open source platform where you can build your all types of applications. An application could be a web app, desktop app, mobile app or gaming app. All type apps can be created using a single platform and it’s none other than .NET Core.
  • Learn ASP.NET Core WEB API With Angular 5 Using ngForJan 22, 2018. In this article, we will learn ASP.NET Core web API with Angular 5 data binding using with ngFor.
  • Deploying Multiple ASP.NET Core Apps To Docker And AzureJan 22, 2018. API - has controller with CRUD operations for a movies database. It uses a class library Data, which contains repositories. Database is hosted in Azure and connection string stored in application settings (appsettings.json).
  • SharePoint Online/2016/2013 - How To Upload Large Files Using PowerShell AutomationJan 22, 2018. Uploading large files to SharePoint On-Premise or Online is an obvious problem during data migration from any external system like Lotus Notes.In this article I will explain a data upload strategy where we can split a large file into multiple chunks of smaller size.
  • Sharing Data To Third-Party ServicesJan 20, 2018. The ActivityViewController is a controller that allows the current application user to share the data in the form of text, images etc easily between the current application and services. There are a number of services such as social networks, email, and sms that are provided by the operating system where we can share the data easily.
  • Expression Bodied Members In C#Jan 18, 2018. What is Expression Bodied Members?1) Expression Bodied member is introduced in C#6.0 and enhanced in C#7.0. 2) Expression Bodied is a new technique or implementation to make code concise and readable. 3) Expression Bodied makes the type member(Constructor, Destructor, Methods, Property, Indexer) defined in a single expression. 4) Expression Bodied members can only be applied to the below list of type members: Constructor introduced in C#7.0 Destructor introduced in C#7.0 Property get accessor introduced in C#6.0 Property set accessor introduced in C#7.0 Methods introduced in C#6.0 Indexer introduced in C#7.0 The Syntax of expression body definition is:member => expression; where expression should be a valid expression and member can be any from above list of type members.Suppose we have a method or constructor that contain a single expression or line of code. Then In spite of using the traditional way to write code inside a method or constructor code block, we can write them as a single syntax. Those members who can follow this approach is known as Expression Bodied Members.
  • Custom Model Binding In ASP.NET Core 2.0Jan 17, 2018. In an earlier post I discussed how to prevent insecure object references by encrypting the internal references (e.g. table primary keys) using Data Protection API. To avoid duplication of code that encrypts/decrypts on every controller I used filters in that example. In this post I’ll use another complimentary technique: custom model binding.
  • 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.
  • 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.
  • 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.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Learn About Microsoft KaizalaJan 15, 2018. Microsoft Kaizala is a mobile application designed for group communication and work management. It is used to efficiently manage the work or collect data from individuals or large groups, even if they are not part of the organization. It makes easy to connect and co-ordinate work with the field employers, vendors, partners and customer wherever they are.
  • Bulletproof Disposable Types In .NET CoreJan 14, 2018. Whenever I do code review on .NET projects, hands down the number one issue is developers not calling .Dispose() on disposable objects. Ever since .NET was released, I have been preaching how important this is. If not done properly, it’s most likely to create virtual memory issues that will eventually cause the application to stop and possibly freeze server or users’ computer.
  • Google Chart With ASP.NET Core And Visual Studio CodeJan 13, 2018. The Google Chart API lets you dynamically generate charts with a URL string and embed these charts on a web page, or download the image for local or offline use. The Google Chart Tools enable adding live charts to any web page. They provide advantages such as a rich gallery of visualizations provided as image charts and interactive charts and they can read live data from a variety of data sources. Users embed the data and formatting parameters in an HTTP request, and Google returns a PNG image of the chart. Many types of chart are supported, and by making the request into an image tag the chart can be included in a web page.
  • Workflow Initiation Form And Association FormsJan 12, 2018. In SharePoint Workflows, Initiation Forms are used to provide some additional information into the workflow for whom it is triggered or who starts it. Basically, the initiation forms are used to interact with the user, for example - if we want to take some data from the user before the workflow is triggered, this will be done by Initiation Forms. At first, the input will be taken and then the workflow will be triggered. This is the scenario of initiation form.
  • 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.
  • Template Driven Forms In AngularJan 11, 2018. We are going to talk about forms. Forms are really important to get the data from the user.
  • Explore Azure Cosmos DB Without Azure SubscriptionJan 10, 2018. Azure Cosmos DB emulator is an exciting tool for getting started with Cosmos Db. This allows us to play with Cosmos DB without even having an Azure Subscription. That means you can write Cosmos DB code in your .net application and view your data on emulator.
  • Most Popular JavaScript LibrariesJan 10, 2018. Here is a list of the most popular JS libraries. In the past few years, Web development has grown rapidly and so is the use of JavaScript libraries. In this article, I’ve collected data on various JS libraries from various references to list the most used JS libraries.
  • State Management In ASP.NET MVCJan 08, 2018. HTTP is a stateless protocol. Each HTTP request does not know about the previous request. If you are redirecting from one page to other pages, then you have to maintain or persist your data so that you can access it further. To do this, there were many techniques available in Asp.Net like ViewState, SessionState, ApplicationState etc.
  • Ignite UI Data Grid In SharePoint Online Using AJAX - Part OneJan 08, 2018. How to use UI Data Grid in SharePoint Online using AJAX.
  • Hashing In ASP.NET Core 2.0Jan 08, 2018. The new Data Protection API in .NET Core includes functionality to create hashes using PBKDF2algorithm. ASP.NET Core uses this behind the scenes in PasswordHasher class, which is used in ASP.NET Core Identity.
  • Send Email With Attachment In Office 365 (SharePoint Online)Jan 07, 2018. Recently, I came up with a requirement to send an email with attachment in Office 365 (SharePoint Online). This needs to be a custom functionality wherein for each line item in a jQuery Data table (as shown in below image), user needs to send an email with an attachment to specific email address.
  • How To Bind Data To A Drop-Down List And An HTML Table With *ngfor In AngularJan 07, 2018. In this article, you will learn how to bind a data to a drop-down list and to an HTML table on selected item from a drop-down list with *ngFor in Angular4.
  • Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.
  • Xamarin.Forms - Deep Linking Application Using SQLiteJan 06, 2018. Android deep links open a specific page within an app and optionally pass data to it. Developers may find deep links particularly useful for actions such as clicking a notification or sending an app link via email
  • How To Install And Start The Reporting Services SharePoint Service In SharePointJan 05, 2018. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Azure PowerShell Login IssueJan 04, 2018. At times we face issues while logging in to Azure PowerShell. There may be different types of error messages while logging in. This article explains about the resolution of the error message “The PowerShell session has not been properly initialized. Please import the module and try again."
  • Xamarin.Forms - Dynamic GridViewJan 02, 2018. This article demonstrates how to create Dynamic GridView using Xamarin.Forms. If you ever need to show something in a data-bound grid view that is not in your data source, just create that extra row dynamically.
  • Repository Pattern In ASP.NET MVCJan 02, 2018. In this article, we will learn about Repository pattern which is mostly used to create enterprise applications. Repository pattern divides application’s UI, business logic and data access components into different layers that are easily maintainable and testable.
  • Azure PowerShell Module InstallationJan 02, 2018. Azure Cloud Shell and Azure PowerShell are the two different types of shells available to manage the Azure resources through cmdlets. Azure Cloud Shell can be accessed through the browser.
  • Intelligent Image Object Detection Bot Using Cognitive Computer Vision APIJan 02, 2018. Microsoft Cognitive services is set of cloud based intelligence APIs for building richer and smarter application development. Cognitive API will be used for searching meta data from Photos and video and emotions, sentiment analysis and authenticating speakers via voice verification.
  • R Services In SQL Server 2017Jan 02, 2018. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no worries. You can still go through and grab it easily. I will go into details of R language in some other article.
  • 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.
  • How To Display Analog Clock Using BoxView In Xamarin.FormsDec 29, 2017. Although Xamarin.Forms doesn't have a vector graphics programming interface, it does have a BoxView. Although normally used for displaying rectangular blocks of color, BoxView can be sized, positioned, and rotated. This is enough to render a classic analog clock.
  • C# 8.0 - Experimenting With Non-Nullable Reference Type Using Visual Studio 2017Dec 28, 2017. Nullable Reference Type is one of the most popular upcoming features of C# which may be released with C# 8.0. However, C# 8.0 has not been released yet; development is going on so till the final release, its behavior may be a little bit different than the current behavior explained in this article.
  • Types Of Software Testing Dec 27, 2017. In this article I have shared some types of Software Testing
  • ASP.NET MVC 5 - Buttons In Datatables jQuery PluginDec 26, 2017. Table view is one of the most important and basic forms of presenting data on a web page. However, adding action to each row is equally important simply because action for each row leads to different results. Jquery Datatables plugin is one of the most used plugins, as I have demonstrated its integration in ASP.NET MVC5 - Datables Plugin Server Side Integration in one of my articles.
  • Understanding Data Structures - Linked ListsDec 26, 2017. In this article we will go through the basics of linked list data structure and implementation of it in various programming languages like C, C++, C#, Java, Python, VB.Net
  • Validation Of Excel Data In C#Dec 24, 2017. This article demonstrates how to validate an Excel sheet before uploading or storing its data into a database.
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise ModeDec 23, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
  • SharePoint 2013 - Different Ways To Enable User Information ListDec 22, 2017. You can find a great description of User Information List on MSDN, yet if I had to explain it in brief I would say it’s a list which stores the users and their information. The information of the users includes details like their Name, Email ID, Display Name, Login Name, Job Title, About User, and Department. Whenever a user is added to the site, he/she appears in the User Information List. The User Profile Services sync the user data into the User Information List from Active Directory.
  • Fluent Validation With MVVM In Xamarin Forms ApplicationDec 22, 2017. Fluent Validation is used to create the validation logic separate from business logic for any type of objects you want to validate.
  • Indexing In Azure Cosmos DBDec 21, 2017. By default, the Azure Cosmos DB data is indexed. Azure applies its default indexing policy while creating a collection. However, a user can set their customized indexing policy as per requirement.
  • How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal ModeDec 21, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
  • Classify Twitter's Tweets Based On Naive Bayes AlgorithmDec 20, 2017. This article explains the way to classify twitters' tweeted data based on Machine Learning's Naive Bayes Algorithm
  • Xamarin.Android - Working With Firebase Database - Part TwoDec 20, 2017. Today, we are going to learn how to save and retrieve data from Firebase in Android.
  • Querying ConsmosDB Using SQL APIDec 19, 2017. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join operator In DocumentDB
  • Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.
  • Xamarin.Android - Working With Firebase Database - Part OneDec 19, 2017. Today, we are going to learn how to save and retrieve the data from Firebase in Android.

About SQL-data-types-Size

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.