C# Corner

Resources  
  • How To Use Microsoft Graph Provider In Visual Studio Connected ServicesAug 22, 2017. In this article, I am introducing the newly added Microsoft Graph Provider in Visual Studio 15.3.1. This article demonstrates how a developer can use this feature to work with Microsoft Graph API.
  • Creating Virtual Machine Using PowerShellAug 22, 2017. This article is about the creation of Virtual Machines in the Azure Cloud Service with the help of PowerShell commands.
  • Azure Cloud - A Close LookAug 22, 2017. Every two or three years, a new technology comes along which carries the potential to change the world, and “Cloud Computing” is the one. However, there are numerous terms and definitions floating around in the industry for “the cloud”, “cloud computing”, “cloud services”, etc.
  • How To Build A Linear Regression Web Service In Azure ML ModelAug 22, 2017. In this article, we are going to build a linear regression model. After building the model, we will train it and publish it as a web service so that we can use the service in any application.
  • 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.
  • Introduction To Azure Media ServicesAug 21, 2017. In this article, we will see how to create and use Media Services in Azure.
  • Getting Started With Microsoft Azure Machine Learning - Part OneAug 19, 2017. It’s a data modeling environment from which we can get an end-to-end approach to a problem to an answer. Use Azure Machine Learning to deploy your model into production as a web service in minutes—a web service that can be called from any device, anywhere and that can use any data source.
  • How To Consume Web Service Through SSIS PackageAug 19, 2017. This article illustrates the purpose of SSIS with Web Service.
  • Google APIs - Google Web AuthenticationAug 18, 2017. Google provides a variety of API services such as Google Cloud APIs, G Suite APIs, Google Map APIs, Mobile APIs, Social APIs. Now, we will discuss how to add Google Authentication to your web site.
  • Creating A Web App Service Using AzureAug 18, 2017. In this article, you’re going to learn how to host your web app using Azure and how to update your app using Staging slot and external repository such as GitHub.
  • Setup And Start The SharePoint 2013 User Profile ServiceAug 17, 2017. In this article, you will learn how to setup and start the SharePoint 2013 User Profile Service.
  • Understanding Media Services In AzureAug 17, 2017. Azure helps you to build custom media workflows in the cloud. It’s an end-to-end solution that delivers audio and video virtually in any device anywhere. It offers end-to-end workflow which is very highly scalable in coding, packaging, storing and distribution of media content to a wide range of devices including TV, PC, and mobile devices.
  • Getting Started With Windows AzureAug 17, 2017. Windows Azure can be anything you want it to be. As a cloud platform from Microsoft that gives a wide variety of different services, windows Azure helps you to construct, install, and manipulate solutions for nearly any motive you may consider. In different words, windows Azure is a global service of unlimited possibilities.
  • Connecting Login Form In C# With Database For User Type AuthenticationAug 15, 2017. This article describes how to connect a Login Form designed in C# with a database so that the user gets validated based upon the password given by the administrator who has created the login database.
  • Load Twitter Data Into SQL DatabaseAug 15, 2017. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that into SQL Server 2016 Database.
  • Consuming Restful Services In Xamarin.Forms - Part TwoAug 14, 2017. In the first part, we called a fake RESTFul service, got some data from the service, and displayed it in a list view. Now in this article, we will continue where we left and add, delete some data which we displayed in previous part.
  • Understand Service Scheduler In AzureAug 14, 2017. It is a task scheduling service provided by Microsoft Azure. It can perform many actions regarding the job details in the scheduler and can also check Scheduler’s monitoring and management capabilities.
  • Universal SMTP Code To Send Emails In .NET AppsAug 13, 2017. As already mentioned quite clearly in the tagline, the only reason to write this article is to cover the basic requirements of every SMTP vendor's code in .NET applications, If your vendor is Google's mail service, — Gmail — then you can most likely leave this article and go back to the article, which I wrote quite a lot of time ago to share how to send emails through a C# programs, sending emails over .NET framework, and general problems – using C# code.
  • Google OAuth 2.0 Authorization In Azure APIAug 13, 2017. Here, I am going to demonstrate how can we use Google OAuth 2.0 in Azure API. App Service Authentication/Authorization is exposed in the Azure Preview Management Portal.
  • Consuming RESTful Services In Xamarin.Forms - Part OneAug 13, 2017. In this article, we are going to learn how to consume a RESTful service in Xamarin.Forms PCL application. Xamarin.Forms are used to build cross-platform mobile applications by using C# and XAML.
  • Key Capabilities Of Azure Cosmos DBAug 12, 2017. A few years ago, Microsoft offered DocumentDB as a Service (DaaS) that supported a limited set of features and functionalities. Today, most of the cloud-based services, such as Bing, Azure, and Office 365 are using DocumentDB. Microsoft took DocumentDB to the next level and came up with Azure Cosmos DB - A globally distributed, multi-model database.
  • Deploying Batch Services On Azure PortalAug 11, 2017. In this article, I am going to describe what Batch Services are and show how to deploy them on the Azure Portal.
  • Deploying Batch Services In User Subscription Mode On Azure PortalAug 11, 2017. This article is in continuation of my previous one and we'll learn how to use User Subscription for Batch Services in Azure portal.
  • Buy Domains Using Azure App Service DomainAug 10, 2017. Here, I’m going to explain how to purchase a domain using Azure App Service domain.
  • Understanding Azure Mobile ServicesAug 09, 2017. This article will give you an idea about the Azure Mobile Services. It allows the functionality of Azure App Service to add sign-in, push notifications, and data sync to your mobile app. Connect your app to enterprise systems and on-premises resources.
  • Understanding DocumentDB In AzureAug 08, 2017. This article will give you a feel for Azure DocumentDB. It is a NoSQL document database service designed from the ground up to natively support JSON and JavaScript directly inside the database engine.
  • SQL Azure With Entity FrameworkAug 08, 2017. Exploring SQL Azure With Entity Framework
  • Create SQL Server Database Project With Visual StudioAug 08, 2017. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
  • Getting started With Azure Ethereum Consortium BlockchainAug 08, 2017. Azure started supporting a number of distributed ledger technologies that fulfill business requirements in security domains and many more. Azure has started Blockchain as a Service (BaaS). It will emerge as platform for creating applications rapidly on cloud technologies. Azure has come up with many blockchain solutions like Ethereum Consortium, STRATO Blockchain LTS, Emercoin Blockchain etc.
  • Understanding Azure Data Lake AnalyticsAug 07, 2017. This article will give an overview of Data Lake analytics account and create U-SQL job and execute this job to put data into the .csv file.
  • Overview Of The AWS Lambda StructureAug 06, 2017. In this article we will dive deep into AWS Lambda and learn its structure as well as the execution.
  • Understanding SQL Azure - Part OneAug 06, 2017. This article will give a idea about creating SQL DB in Azure and using it in Visual Studio
  • Introduction To jQuery And Web API 2 Controller’s Method Relationship Using jQuery AJAX In ASP.NET MVC RazorAug 06, 2017. ASP.NET Web API is a smart framework to build HTTP services which can be consumed by Multi platform clients including desktops or smart phone devices, irrespective of browsers or Operating Systems being used.
  • How To Determine The Version And Edition Of SQL Server And Its ComponentsAug 06, 2017. For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the client-side computers to obtain the latest fixes while developing SSIS packages, SSRS reports, or Analysis Services cubes.
  • Understanding App Service In AzureAug 06, 2017. It will allow you to get started with the app-services in Azure.
  • Understanding SQL Azure - Part TwoAug 06, 2017. This article will allow us to connect with SQL Azure and perform CRUD operations using EF.
  • Compare Azure SQL Database And Azure SQL Data WarehouseAug 05, 2017. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.
  • Setup And Connect To Azure SQLAug 03, 2017. Microsoft Azure SQL Database (formerly known as SQL Azure) is a managed cloud database i.e. Software as a Service (SaaS) provided by Microsoft Azure. In simple words, Microsoft Azure SQL is a cloud database that runs on a cloud computing platform and access to it is provided as a Service.
  • Azure Portal New Preview Of App Service DomainAug 02, 2017. Azure team continues working on improvement of their website, and keeps adding more user-friendly and easy options for users. In this series, now they have launched a new preview of app service domain.
  • Understand About Cloud Before Stepping On To Any Cloud Service ProvidersAug 02, 2017. I will be writing a series of articles on Amazon Web Service and on Azure Cloud. But, before that let's learn with the help of this article why we should move towards the Cloud.
  • Creating EC2 In Amazon Web ServicesAug 01, 2017. This article is about the creation of the EC2 service in the AWS. EC2 is nothing but a virtual machine which we generally create in other cloud platforms like Azure, Google cloud, etc.
  • How To Use Visual Studio For Azure SQL DatabaseJul 31, 2017. This article demonstrates using Visual Studio step by step for Azure SQL Database operation.
  • How To Create Web Job in Azure Web appJul 31, 2017. Azure web job is the most useful feature in Azure web app service. It will be great helpful when you want to run the scripts or programs as background processes in app services, api app and mobile app .
  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
  • Getting Started With Visual Studio Team ServicesJul 28, 2017. In this article, we will discuss in detail about the Visual Studio Team Services, walk through VSTS features, compare with VSTS and TFS, learn how to create VSTS account and how to publish the source code to VSTS.
  • Azure WebApps - A Complete Walk Through ItJul 28, 2017. This article is about Azure WebApps which is a service from Azure App Service. Azure WebApps is a completely computed platform from Microsoft Azure which helps us to host, manage, create slots, go with traffic manager and many more flexible options to make your WebApp an easier one for the client and for developer.
  • Creating Web API With ASP.NET Core Using Visual Studio CodeJul 28, 2017. Web API is is framework that allows us to build web or http based endpoints. If you are building services today for mobile, HTML 5, and even client-server desktop applications, all these different types of applications need services in the backend.
  • Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical DataJul 26, 2017. How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
  • RDLC Integration In MVC Application - Report Display Using IframeJul 25, 2017. This article demonstrates how to integrate RDLC report in ASP.Net MVC application. Build the solution and run, navigate to Report view, then we will be able to see the following screen that the report displayed in View.
  • Getting Started With Microsoft FlowJul 25, 2017. Microsoft Flow is a product to help us set up an automated Workflows between your favourite apps and services to synchronize files, get notifications, collect data, and more by the internet.
  • Create Your First VM In AzureJul 25, 2017. Cloud computing can be a complex term nowadays, as there are already many services that can run on Cloud. Services like Data mining, Machine learning, creating virtual machines, host APIs for mobile applications and many other endless services.
  • Learn Web API : Using SQL Helper ClassJul 25, 2017. This article demonstrates how to use Web API Using SQL Helper Class with easy to use data base access in Visual Studio 2017.
  • How To Use Query Editor For Azure SQL Database In Azure PortalJul 24, 2017. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
  • Creating An Azure SQL Database And Connecting Through SQL Server Management StudioJul 23, 2017. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
  • AngularJS OTP Verification With Third Party AuthenticationJul 21, 2017. Goto to Controller.js and Service.js page and follow the below steps.
  • Get User Profile Properties Data in SharePoint Designer 2013 WorkflowJul 18, 2017. Workflows helps SharePoint users to collaborate on documents, list items and to manage tasks by implementing business processes on documents and list items. Creating and assigning tasks to Manager is a very common scenario in workflows. All the user related information is stored in User profile service application (UPA). Although this sounds very straightforward, getting the user profile properties of the logged in user is very tricky in SPD 2013 workflow.
  • Taking Script From Database In SQL Server In Different ModeJul 17, 2017. This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, update or delete then create our database based on our database modification.
  • Create SSRS Drilldown ReportJul 17, 2017. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
  • Creating C# Wrapper Over Firebase API For Basic CRUDJul 17, 2017. Firebase is a platform provided by Google, which provides many services. Firebase Realtime Database is one of them. Firebase provides many SDKs for different platforms as well as it provides REST API to interact with database. Here we will build wrapper in C# around REST api to easily perform CRUD operations in our C# applications.
  • Create A Microsoft Azure Cognitive Service Face API Application In 30 MinutesJul 17, 2017. In this article, we are going to create Microsoft Azure Cognitive Service Face API in half an hour. Microsoft Azure Cognitive Services are set of APIs and Services available for the developers to make their applications more interactive and intelligent. This was formerly known as Project Oxford. Here Microsoft uses Machine Learning in the background to create these APIs.
  • ABC Of WPFJul 15, 2017. Basically I am working on .Net/Sql. For the project requirements I went through the WPF. I visited so many online tutorials and videos to get the knowledge. In this article I am going to share my understanding with you.
  • How Autodiscover Service Works In ExchangeJul 14, 2017. In this article, we will cover how Autodiscover works in Exchange to configure outlook profile for users without manual intermission of the user or administrator. Let’s begin!!
  • Uploading File To AWS S3 Using ASP.NETJul 14, 2017. In this article, I will show you how to upload a file (image/video) to Amazon S3 Bucket through a Asp.Net web application. For this first you need to have an account in Amazon web services. You can create an aws free tier account which is valid for 12 months. Visit this link to know more about a free tier account.
  • How To Create And Deploy Azure Web AppsJul 14, 2017. In this article, we are going to learn how we can create Azure Web App and how to deploy it. Unlike other services, Azure Web Apps service enables us to build and host web applications in the programming language of our choice without managing infrastructure. It offers auto-scaling and high availability, and supports both Windows and Linux.
  • Deploying Event Hubs In Azure PortalJul 14, 2017. This article shows how to deploy the Event hub in the Azure portal. Azure Event Hubs are highly scalable data streaming platforms and event ingestion services capable of receiving and processing millions of events per second. Event Hubs can process and store events, data, or telemetry produced by distributed software and devices.
  • Creating DLP Policies In Office 365Jul 13, 2017. Many organizations and large-scale companies are now making their way to Office 365, leveraging various services offered by Microsoft such as SharePoint, Exchange, Project Online, Microsoft Dynamics etc.
  • Connecting And Working With Azure SQL Database Using Visual Studio 2017Jul 12, 2017. This article shows how to connect and work with the Azure SQL Database. In this article, I am going to demonstrate how to connect and work with the Azure SQL Database using Visual Studio 2017.
  • Get To Know Microsoft 365Jul 12, 2017. Microsoft 365 is a new service which was introduced by Satya Nadella 2 days ago on Microsoft Inspire which brings together Office 365, Windows 10 and Enterprise Mobility + Security, delivering a complete, intelligent and secure solution to empower employees.
  • Mirroring Database In SQL ServerJul 12, 2017. When there is any automatic failure we need another server that will monitor the principal server.
  • How To Fix TF30063 Error - You Are Not Authorized To Access Team Foundation Service ErrorJul 10, 2017. Recently I was working with Microsoft Visual Studio 2017 and got the following error with TFS, which says, “You are not authorized to access Team Foundation Service”. The error code was TF30063. This was a surprise for me because it was working earlier. I do not have any clue about this.
  • Monitoring Our Database When Accessing From Outside Or Applications In SQL ServerJul 08, 2017. This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
  • Chat Bot Using Microsoft Bot Framework With LUIS - Part TwoJul 08, 2017. Click on ‘Publish App’ option in left hand side bar menu. It will show following page. Here you can choose Endpoint Key. Select purchased key. If you have not purchased any key then select Bootstrap key, which is for experimental purposes. In ‘Publish Settings’, you can select Endpoint slots as Staging or Production. If you select it as Staging, it will be available over http but you can’t access it though chat bot app. For our development select it as Production.
  • Get Started With Azure DevTest Creating Server Machines With ArtifactsJul 07, 2017. Azure DevTest is an effective resource that Azure has come up with for supporting developers and testers to avoid environment delays, allow self-service actions on turning the VM’s (Virtual Machines) on or off, and works with simple cost effective solutions to leverage the application which we host on the cloud.
  • Deploying Logic Apps Service In Azure PortalJul 06, 2017. Logic Apps are used as fully managed iPaaS (integration Platform as a Service) allowing developers not to have to worry about building hosting, scalability, availability and management.A logic app begins with a trigger after firing and can begin many combinations of actions, conversions, and condition logic. It also provides the path to simplify and implement scalable integrations and workflows in the cloud. It provides a visual designer to model and automate your process as a series of steps known as a workflow.
  • Apache Spark Apache Ambari And Notepads On Microsoft Azure HDInsight - Part TwoJul 06, 2017. Apache Ambari is for management and monitoring of Hadoop clusters in form of WEB UI and REST services, Ambari is used to monitor the clusters and make changes in configuration. Ambari used for provision, monitoring and managing the cluster in an easier way. Using Ambari you can manage central security setup and fully visibility into cluster health.
  • Installing SQL Server vNext On Linux - Part TwoJul 04, 2017. With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on Windows but it is on Linux also and people who love Linux can check the flavor of SQL Server in the Linux environment.
  • Microsoft Azure Automation Using PowerShell Desired State Configuration And Node Configuration And ManagementJul 04, 2017. Microsoft Azure is very aggressive about providing Automation Solutions and Services to users by Azure Automation Service, by which we can automate the manual, long running and frequent, periodically repeating tasks of the cloud and can manage and configure a number of nodes
  • Create A Bot With Microsoft Bot Framework Using Node.jsJul 03, 2017. In this article, you will learn how to create a Bot using Bot Framework with newly launched Custom Vision service.
  • Chat Bot Using Microsoft Bot Framework With LUIS - Part OneJul 03, 2017. LUIS: Language Understanding Intelligent Service. We can teach this service to understand intention and extract the entities from user query/activity. Client app (e.g. chat bot) can consume this output using HTTP endpoint of LUIS application.
  • Deploying An Azure SQL Database In Microsoft Azure PortalJul 03, 2017. This article shows how to create and configure the firewall and how to run sample sample queries in the SQL Database using Azure Portal.
  • Top Cognitive Services APIs for DevelopersJul 02, 2017. In this article, I compare various cognitive services for developers.
  • How To Download SQL Records In Excel Format Using MVCJul 02, 2017. I will explain how to download records in Excel format from database.
  • Learn AWS With MS-SQL(DB) Using SQL ClientJul 01, 2017. You want to login to the AWS console here. If you have no login register new users in here. After registering amazon will provide one year free access.
  • FAQs Answering bot using Bot Framework and QnA Maker serviceJun 30, 2017. In a previous article, I have explained how to educate QnA maker for questions and answers. In this article we will discuss about how to consume QnA maker service in Bot applications created using Microsoft Bot Framework.
  • Deploying A Simple QnA Bot Using Bot Services In Microsoft AzureJun 30, 2017. In this demonstration , I am going to show how to create and deploy the QnA bot in Microsoft Azure using Bot Services.
  • Emotion Recognition In Xamarin.Forms With Microsoft Cognitive ServicesJun 29, 2017. Microsoft Cognitive Services offer awesome APIs and services for developers to create more intelligent applications. You can add interesting features, like people's emotions and video detection, face, speech, and vision recognition and speech and language understanding into your application.
  • Deploying A Simple LUIS Bot Using Microsoft Azure Bot ServicesJun 28, 2017. LUIS stands For Language Understanding Intelligent Service which offers a fast and effective way of adding language understanding to applications. With LUIS, you can use pre existing, world class, pre built models from Bing and Cortana whenever they suit your purposes and when you need specialized models, LUIS guides you through the process of quickly building them.It is also part of Microsoft Cognitive Service.
  • Deploying The Azure DNS Using Microsoft Azure PortalJun 28, 2017. An Azure DNS is used to host the DNS records for a particular domain and the Domain Name System, or DNS, is responsible for translating (or resolving) a website or service name to its IP address. Azure DNS is a hosting service for DNS domains, providing name resolution using Microsoft Azure infrastructure. By hosting your domains in Azure, you can manage your DNS records using the same credentials, APIs, tools, and billing as your other Azure services.
  • Cognitive Services APIs In AzureJun 28, 2017. Microsoft Cognitive services provides good number of API and services for vast developers that helps you to create more intelligent applications.
  • Getting Started With QnA Maker ServiceJun 28, 2017. In simple language, it is a service to educate a bot with static answers for specified set of questions. Let’s take an example of FAQs. FAQs are set of questions and answers which are going to remain same irrespective of user.
  • Deploying A Proactive Bot Using The Microsoft Azure Bot ServiceJun 27, 2017. This article demonstrates how to create the proactive bot using Microsoft Azure Bot Services.
  • Deploying A Form Bot Using Microsoft Azure Bot ServiceJun 26, 2017. This article shows how to create,deploy and test the Form Bot using Microsoft Azure Bot services.
  • Angular Demo Application With ASP.NET Core MVC (Rent A Car)Jun 26, 2017. This project is a simple rent a car project developed in ASP.NET Core MVC and Angular with backend as SQL Server 2008 R2.
  • How To Create Azure SQL Database And Access It Through Visual Studio CodeJun 26, 2017. In this article, I’m going to cover how to create Azure SQL database and how you can access it through Visual Studio code.
  • Getting Started With Microsoft Azure Cognitive Services APIs AccountJun 25, 2017. Microsoft Cognitive Services offer awesome APIs and services for developers to create more intelligent applications. You can add more interesting feature like people emotion and video detection, facial, speech and vision recognition and speech and language understanding into all the applications.
  • Managing System Services Using Windows PowerShellJun 24, 2017. You can easily manage system services using Windows PowerShell by just typing some simple Cmdlets. Below are some of the examples that help you to manage system services using Windows PowerShell.
  • Daily Shrink Database Log Automatically Using Jobs In SQL ServerJun 24, 2017. This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script manually.
  • Different Formats In Report Generation Using JSReport ServerJun 23, 2017. The JSReport Server supports different types of formats in report generation like pdf, xlsx, html, text, html to xlsx etc. In previous article the report was generated in PDF format.
  • Xamarin.Android - List View Using SQL Server DatabaseJun 21, 2017. In this article you will create a Xamarin Android List View using SQL Server.
  • Automatic Daily Database Backup To Specific Database In SQL ServerJun 21, 2017. Automatic Daily Database Backup To Specific Database In SQL Server.

About SQL-reporting-service

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!