C# Corner

Resources  
  • The Data Science Process With Azure Machine LearningAug 19, 2017. It’s no secret today that all our applications and devices are generating tons of data; thus making data analytics a very hot topic. Microsoft Azure has all the tools necessary to ingest, manage and process all this data, which is also known as Big Data.
  • 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.
  • Introduction To ProtractorAug 18, 2017. Protractor is an E2E UI automation testing tool for angular or Angular JS and it is very similar to selenium webdriver. Angularhas some extra web elements like ng-model, ng-if so we can’t test angular applications without Protractor. Protractor is built on the top of WebDriverJS that uses native events and browser-specific drivers which interact with web application.
  • Understand Azure Cosmos DB - Table APIAug 18, 2017. Cosmos DB is a globally distributed multi-model database. Using the API, applications running on Azure Table storage can take advantage of secondary indexes, turnkey global distribution, dedicated throughput, and single digit millisecond latency with 99.99% comprehensive SLAs.
  • Reading An Excel File Using HTML 5 And jQueryAug 18, 2017. This article explains how to export data from an Excel file to an HTML table using jQuery & HTML5.
  • Custom Model Binding In ASP.NET Core MVCAug 17, 2017. Model binding in MVC maps HTTP request data to the parameters of the controller's action method. The parameter may either be of simple type like integers, strings, double etc. or complex types. MVC binds the request data to the action parameter by parameter name.
  • 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.
  • 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.
  • CRUD Operation With JSON File Data In C#Aug 15, 2017. This article will demonstrate how to implement CRUD functionality with JSON file in a project using C# code.
  • Configuring Azure AD With App Permissions For SharePoint REST API AuthenticationsAug 15, 2017. Let us see how to setup the Azure Active Directory with necessary app permissions for accessing the Microsoft data using graph API.
  • 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.
  • 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.
  • Creating A Data Volume In Windows PowerShellAug 12, 2017. We shall now try creating a data volume which can be used by more than one container images.
  • IoT Solutions - Architecture/Design And Business AspectsAug 11, 2017. IoT is the abbreviated term meaning "Internet of Things". By definition Internet of Things is: the inter-networking of physical devices, vehicles (also referred to as "connected devices" and "smart devices"), buildings, and other items embedded with electronics, software, sensors, actuators, and network connectivity which enable these objects to collect and exchange data.
  • Download Files In Zip Format Using ASP.NET MVC Razor And SweetAlert LibraryAug 10, 2017. There are so many websites that display a list of files to the end user. The user can then select one or more files from the list and request a zipped bundle of those files as a single download. In this article, I will show you this implementation using MVC.
  • Data Structures In Java - Linear ArrayAug 10, 2017. Data structure means organizing the data by using models in the computer memory. A linear data structure that represents a relationship between elements by successive memory location is known as the array, where as a linear data structure that represents a relationship between elements by pointer and link is known as linked list.
  • How To Do Paging With ASP.NET Web APIAug 10, 2017. In this article, we are going to learn how to do paging with Web API. In this modern era where there are tons of data to share and consume here we cannot send all data at one go or consumer we need to slice the data into pieces to share known as paging.
  • 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.
  • Passing Data To AWS Lambda Function And Invoking It Using AWS CLIAug 09, 2017. In previous article, we learnt about AWS lambda structure and how a lambda function can be invoked. Before we go further, there are couple of things which are very important to consider while doing local development and production deployment.
  • Accessing XML Data From XML Document In C# Console ApplicationAug 09, 2017. In this article, I am going to give the best way to access XML data from XML document and also how to find common record node counts.
  • Overview Of Azure Data LakeAug 09, 2017. In this article, we will walk through some important concepts of Azure Data Lake and its implementation.
  • Using Category To Store Your Master DataAug 08, 2017. In every CRM implementation, we deal with some sort of master data in CRM. Normally we use the traditional way to store master records by creating custom entities. But we do have a better way to store master data using Category entity.
  • 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.
  • 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.
  • 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.
  • Dependency Injection - Part One -Tightly Coupled ApplicationAug 07, 2017. It is a best practice to use interfaces instead of concrete classes. These interfaces can then be mocked at the time of unit testing, which will prevent any call to the actual database. Also, it is a good practice to stop "newing-up" objects in classes.
  • 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.
  • Angular, Bootstrap And ASP.NET MVC - Part Seven (Bootstrap Modal Forms)Aug 02, 2017. In previous articles, we have learned AngularJS project setup, styling with bootstrap, AngularJS structure, data-binding, routing, copying of angular object when form is saved or cancelled, inserting/updating forms, etc.
  • Selecting An Enterprise Content Management System (CMS) - Part TwoJul 31, 2017. In continuation of my previous article on – “Selecting a Content Management System that supports Your Business”, I thought of writing this article on selecting an Enterprise CMS. Nowadays, Mobile, Big Data and E-Commerce are causing drastic changes in the business landscape and all those companies who ignored their online presence are at the risk of losing customers and revenue.
  • 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.
  • ImageView In Xamarin Native Platform With ExampleJul 31, 2017. After the process completes, the Xamarin dashboard appears. At the top right, you will see Solution Explorer. There is your application solution.Select application name; extract to resources. The Layout folder appears in which there is Main.axml* file.
  • 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.
  • Statistics And Cost Estimation Internals - Part OneJul 30, 2017. Incorrect cardinality and Cost Estimation may lead query optimizer to choose inefficient plans which can have a negative impact on the database performance. In this article we are going to look deep inside Statistics.
  • Angular, Bootstrap And ASP.NET MVC - Part Six Jul 29, 2017. In previous articles, we have learnt AngularJS project setup, styling with bootstrap, AngularJS structure, data-binding, routing, copying of angular object when form is saved or cancelled, etc.
  • Introduce Entity Framework With ADO.NET Entity Data ModelJul 28, 2017. In this article, we will learn the Entity Framework with Data Model.
  • Data Science - Basics Of Statistics - Part OneJul 28, 2017. Data Science means Science which is being driven by data, by means of getting useful insights from the set of data available, plotting the data visually and predicting the future.
  • AngularJS, Bootstrap And ASP.NET MVC - Part Five (Saving/ Cancelling Form)Jul 28, 2017. In previous articles, we have learned AngularJS project setup, styling with bootstrap, AngularJS structure, data-binding, routing, etc. In this tutorial, we are going to learn how we can save the form data when save button is clicked and reset the form when cancel button is clicked.
  • ASP.NET MVC Model Validations Using Data AnnotationsJul 27, 2017. In this article, I will explain how to implement model validations using data annotations in asp.net mvc. In asp.net mvc we can easily implement validation by using Data Annotation properties.
  • Angular, Bootstrap And ASP.NET MVC - Part Three (Data Binding In AngularJS)Jul 26, 2017. In this article, we are going to learn data binding in AngularJS. We learn how data is set into the form and how data is retrieved from the form. In AngularJS, data is stored in “$scope” variable in the controller.
  • 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.
  • Learn MVC Using Angular Dynamic Control In DataTableJul 26, 2017. In this article, we will learn MVC using Angular data binding for dynamic control in datatable from server side Web API using visual studio 2017.
  • Extracting Data From Large Spreadsheets Using Python And OpenpyxlJul 26, 2017. At least once in life, every computer user has to handle some spreadsheets or, excel files. Sometimes it's to put formulas in for accounting, sometimes it's to store data from Google forms or other surveys. So what do you actually do when the spreadsheet contains just survey data or no numbers to apply formulas at all? I know you'll get your hands dirty and do it manually.
  • 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.
  • 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.
  • 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.
  • React Tutorials - Day Six - FluxJul 24, 2017. Flux is a programming architecture and concept where data flows in an unidirectional way. Flux is not a framework or library, it is just an architecture pattern that was developed by Facebook along with the React View library to manage the data flow into our application. Flux makes it easier to track the changes and bugs during development.
  • 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.
  • Entity Framework Core Triggers In Action (Unofficial Package)Jul 24, 2017. This article shows you how to work with database triggers in Entity Framework Core using a third party library.
  • 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.
  • Chat Bot with SharePoint authentication - Part TwoJul 19, 2017. In the previous part of the article, we have completed the initial setup. In this part of the article, we will implement chat bot which will access data from SharePoint.
  • Using PowerShell To Create Log/CSV Files And File Out CommandsJul 19, 2017. In many instances while developing using Powershell we need to get the logfile in a specific folder and format.
  • 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.
  • 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
  • Create SSRS Drilldown ReportJul 17, 2017. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
  • Selecting A Content Management System That Supports Your BusinessJul 17, 2017. Recently, a customer asked for a Content Management System (CMS), and being a SharePoint developer and consultant, I proposed SharePoint Server as CMS. Afterwards, by analyzing different CMS in the market, I thought of writing this article and will focus mainly on a CMS named – “Sitefinity” (http://www.sitefinity.com/).
  • Integrating SharePoint Data Into Node.JS With Access TokenJul 17, 2017. In this article, you will learn how to integrate SharePoint applications data into node applications with access token.
  • 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.
  • Using PowerApps - Authoring Made Simple And PowerfulJul 16, 2017. I am glad to bring you up with the latest change in the PowerApps Studio, in the latest version (2.0.660), the enhanced capabilities are showed and discussed in this article, PowerApps Studio had changes in the Properties Panel, Viewing data with the edit form, global variables, and the reset function.
  • Best Practices For MVCJul 14, 2017. Add a class library project to the solution, named Store.Model. This library is where we ‘ll keep all of our domain objects. Entity Framework will count on them in order to build the database but we are not going to configure Code First using DataAnnotations attributes on this project. Instead, we are going to put all the Code First configuration in specific Configuration classes using the Fluent API. Add a folder named Models.
  • What Is Big Data?Jul 14, 2017. This topic is one of the hottest topics trending today. And it is growing day by day. The demand for Data Scientists (Big Data experts) is very high.
  • 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.
  • How To Create A List/Library Programmatically In SharePoint 2013Jul 13, 2017. We need to install Visual Studio in our machine for creating a list using SharePoint Server Object Model. The Server Object Model will be executed in the server side & it provides a rich set of classes in representing & manipulating SharePoint objects. Server object model is like production server environment to access the data where Sharepoint is installed on the machine.
  • Integrating SharePoint Data Into Node.JS ApplicationJul 13, 2017. In this article, you will learn how to integrate SharePoint applications or data into node applications.
  • Mirroring Database In SQL ServerJul 12, 2017. When there is any automatic failure we need another server that will monitor the principal server.
  • 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.
  • Creating A Database-Driven MVC Image Gallery With ThumbnailsJul 12, 2017. MVC Image Gallery, Save Image in a database, Retrieve Images from a database, Create Image thumbnail from the database, Upload Image through Ajax, Fancy Box Gallery
  • How To Upload Records From Excel File to Database Using Stored Procedure In MVCJul 10, 2017. In this article, I will explain how to upload records from Excel files in the database using store procedure and also how to check all types of validation.
  • Getting Started With MongoDB - MongoDB In Azure Cosmos DBJul 10, 2017. My last article demonstrated how to interact with the MongoDB database server from a simple C# console application. Now, when you build enterprise applications using MongoDB, your local database server should always be up and running for 365 days or more. This is not appropriate for enterprise applications.
  • 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.
  • Algorithms Of Microsoft Azure Machine LearningJul 05, 2017. Every Data Science and Machine Learning beginner has only one question in mind: how to start with Machine Learning or how to choose algorithms in Machine Learning, So let's understand Algorithms of Microsoft Azure Machine learning in this article
  • Binding Dropdown List In Angular With ASP.NET Core Web APIJul 05, 2017. After selecting a project a new dialog will pop up with name “New Project” now from the left panel just select Templates inside Templates select Visual C# à The Web after that choosing it will show a list of Project Templates as shown in below dialog.
  • Data Persistence Using SQLite In Xamarin.FormsJul 04, 2017. In this article, we are going to make our data persistence using SQLite in Xamarin.Forms. Firstly we will setup SQLite db for our project than make a table in it and add some data in this table. After this whenever we open our application we will see that our data is now persisted and saved in local db of application.
  • Overview Of MongoDBJul 04, 2017. This article explains the basics of MongoDB, doing CRUD operations on it using command prompt and then CRUD operations with a sample ASP.Net WebAPI.
  • 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.
  • 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.
  • Creating TreeView For MVC 5Jul 03, 2017. We're going to extend JsTree from JS to MVC and we'll render HTML tags from the database using custom development in the model.
  • Setting Up SQLite In Xamarin.FormsJul 03, 2017. In this article, we will learn to set up SQLite in xamarin.forms. It doesn’t require too much time and it is not difficult like setting up other databases.
  • How To Download SQL Records In Excel Format Using MVCJul 02, 2017. I will explain how to download records in Excel format from database.
  • Xamarin.Forms - Using ListView HeaderTemplate And FooterTemplate To Display DataJun 30, 2017. In this article we will learn how to use ListView HeaderTemplate and FooterTemplate to display data from our ViewModel using Visual Studio Community 2017.
  • React Tutorials - Day Four - Props And StateJun 30, 2017. Today, we will learn about Props and State in React. Props and State are used to store and follow the data in applications.
  • How To Create A Grid Dynamically Using AngularJun 30, 2017. Create a grid dynamically with angularjs without hardcoding column names. AngularJS provides various features. One of them is 2 way data binding. In this article I will explain how you can create a grid dynamically from Angular.
  • Learn MVC Using Angular UI SelectJun 28, 2017. In this article, you will learn MVC Using Angular UI Select.
  • Overview of Reactive Approach In AngularJun 27, 2017. In this tutorial, I am talking about two approaches that Angular offers - Template Driven and Data Driven (Reactive Approach).
  • An Introduction To IoTJun 27, 2017. IoT is a network of physical objects, devices (like Arduino, Raspberry), vehicles, electronic components, software, sndf sensors that connect with each other and exchange data.
  • 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.
  • Working With PowerShell DrivesJun 25, 2017. Windows PowerShell drives are data store locations that you can access like any other ?le system drives in Windows PowerShell. The Windows PS providers create some drives for you, such as the ?le system drives (including C: and D:). Below examples provides you how to work with PowerShell Drives in Windows PowerShell.
  • Multiple Ways To Bind Data To Kendo Grid In MVCJun 24, 2017. In this article, we will learn how to bind data to Kendo Grid in MVC using multiple ways.
  • 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.
  • How To Operate With Data Persistence In Xamarin.Forms - Part TwoJun 23, 2017. In this one, I’ll show you how to use the file system to save data using Xamarin with the .Forms UI Technology and the PCL (Portable Class Library) code sharing strategy.
  • Automatic Daily Database Backup To Specific Database In SQL ServerJun 21, 2017. Automatic Daily Database Backup To Specific Database In SQL Server.
  • Database Driven Development And Developing The User Interface Using C#Jun 21, 2017. In this article, I am going to explain about Database Driven Development and Developing the User Interface Using C#.
  • Xamarin.Android - List View Using SQL Server DatabaseJun 21, 2017. In this article you will create a Xamarin Android List View using SQL Server.
  • Creating Azure Data Lake Analytics Using Microsoft Azure PortalJun 20, 2017. This article shows how to create a data-lake analytics using Azure portal.
  • Populating Hierarchical Data In TreeView In WPF Using MVVMJun 20, 2017. TreeView Hierarchical Data Binding In WPF MVVM.
  • Create Database Project In Visual Studio 2015Jun 20, 2017. Create Database Project In Visual Studio 2015.
  • Render SPFx Properties Pane Based On List DataJun 18, 2017. Let us see how to render the SharePoint Framework web part properties pane dynamically using SharePoint list data.
  • Entity-Framework Code First Migration With WebAPI 2.0 - Extending ASP.NET Identity DatabaseJun 18, 2017. Here, we will see how to extend ASP.NET Identity database using Code First migration in Web API 2.0.

About select-a-specific-data-from-database

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!