C# Corner

Resources  
  • Encrypt And Decrypt User Password In SQL Server DB Using C# Winform ApplicationSep 18, 2017. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login form.
  • Two Ways To Get Data From Entity FrameworkSep 15, 2017. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
  • Create Immutable Type In C#Sep 14, 2017. A public constructor that accepts initialization data is required so that the client can pass-in minimum state for the type to be valid. Private constructor, on the other hand, is used by methods to construct a new object and set its entire state.
  • Azure SQL Data Warehouse - Why Enterprises Should Now Consider It SeriouslySep 14, 2017. Today we will explore some of the reasons why enterprise should choose Azure SQL Data Warehouse.
  • How To Insert Form Data In Multiple Table In DatabaseSep 13, 2017. In this article, we gonna learn about how to insert from data in multiple tables using jquery ajax in asp.net web application.In real time applications it is not a good practice to save all customer data in one table.They save data in multiple tables and link them using relations(using foreign keys).
  • ASP.NET Core 2.0 ConfigurationSep 11, 2017. ASP.NET Core has a simple mechanism to read application settings from various sources like JSON files, Environment variables or even custom data sources. It is also simple to use the settings, thanks to Dependency Injection.
  • Data Science Machine Learning In R ProgrammingSep 09, 2017. In this article, I am going to describe what machine learning and data science are and then we will see how we can apply machine learning techniques in data science and then we will do some practical implementations in R language of data pre-processing.
  • Frequent Pattern And Market Basket ImplementationSep 09, 2017. Frequent pattern mining is about the item sets and sequences which appear in a data set.
  • Working With Azure Tables - Part TwoSep 09, 2017. Let us look at the basic sample, which retrieves the Azure table data into the applications using Node JS.
  • Azure Cosmos DB With SQL Query Cheat Sheet PDFSep 08, 2017. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
  • Get Office 365 Data In Excel Using MS Graph APISep 08, 2017. In this article, I will show how you can quickly fetch Office 365 data of your organization in MS Excel using Microsoft Graph API.
  • Data Mining And Market Basket ImplementationSep 08, 2017. This article talks about the major techniques which are used in data mining to extract raw data for the following steps like data cleaning, data pre-processing, etc. and constructing useful datasets which are used for prediction.
  • Getting Started With Azure Cosmos DB - Table APISep 08, 2017. The table is made up of one or more partitions. Partition Key and Row Key are suitable to optimize your solution. The account name, table name, and partitionkKey together identify the partition within the same storage service where your table service stores the entity.
  • Create TableView In Xamarin.iOSSep 07, 2017. In this tutorial, I am going to share how to create a table view in Xamarin IOS applications using C# and how to use navigation controller in our application.
  • Use Wikipedia As A Data Source To Prepare Power BI ReportSep 07, 2017. Power BI is a business intelligence tool. It supports so many data sources to prepare a report. As we all know Wikipedia is a very good resource of useful information. We can consume Wikipedia data as a data source and prepare a Power BI report.
  • How To Consume Web API Through SSIS PackageSep 07, 2017. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and process the data, etc.
  • Find Out Creation And Modification Date Of Database Objects Like Tables And Stored ProceduresSep 07, 2017. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • How Should We Store Images And Blob Files In SQL ServerSep 06, 2017. There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects also know as BLOBs, such as images and sounds, into SQL Server.
  • 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.
  • Understanding Bot Service In AzureSep 06, 2017. This article will give an overview about the MS bot framework. Open azure portal and click on add and choose category “Data + Analytics” and then select the option “Bot Service”.
  • The Basic Concepts Of Data ScienceSep 04, 2017. The basics concepts of data science can be separated two important parts. Maybe some people can argue with me because I have to tell you supervised learning and unsupervised learning and decision trees algorithms. But my intend is not explaining the concepts of Data science. This article is related to some knowledge about who wants to be started as data scientist.
  • Search Data From Xamarin.Forms List ViewSep 04, 2017. In this article, we are going to search some data from list view of xamarin forms. Firstly we can create a list in xamarin forms PCL application. Then add some data in list and make a search bar to search data form list.
  • What Is Meant By Big DataSep 04, 2017. Big data is a term that describes the large volume of data - both structured and unstructured - that overload a business on a day to day basis.But it's not the amount of data that's important.It's what all the - organisations do with the data that matters big data can be analyzed for insights thats load to better decisions and strategic business moves "Big data" is similar to "small data",but it is bigger in size.Big data is the collection of both structured and unstructured data which are from different sources like social data,machine generated data and traditional enterprises.
  • How To Perform Web Scraping Using Python ProgramSep 04, 2017. Web Scraping (also known as Screen Scraping, Web Data Extraction, Web Harvesting etc.) is a process to scrap (extract) data from web pages, web document, HTML document or XML document in a structured manner and then store in database, text file as a spreadsheet , as a XML , or in whatever file format we want to save in.
  • 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”.
  • Getting Started With Azure TablesSep 01, 2017. In this article, we will walk through some important concepts of Azure Tables through Emulator. Create the Azure Tables by using Microsoft Azure Storage Explorer.
  • Display Office 365 Data Using MS Graph API In Power BISep 01, 2017. In this article, I will show how you can display Office 365 data of your organization in Power BI report using MS Graph API. I will show how you can fetch your organization’s users with MS Graph API, and quickly create a report using Power BI Desktop. Once you learn to use MS Graph API in Power BI, you can explore more options to create some interesting reports on your own.
  • Working With Azure Tables - Part OneAug 31, 2017. You will see the introduction to Azure tables, accessing the table using emulator, and managing tables manually.
  • 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.
  • Data Structures and Algorithm (DSA) – Performance, Complexity And Big-O NotationAug 28, 2017. In this article we will be talking about what performance of an algorithm is and how Complexity is used to measure performance and what Big-O notation is.
  • New in Machine Learning - An Intent Based Network ManagementAug 28, 2017. Implementation and application of Machine Learning are growing rapidly across different industries. The next big thing is Intent-Based Network or IBN.
  • Learn About Azure Mobile ServicesAug 28, 2017. Azure mobile app service provides high scale functionality of azure app services to add sign -in, push notifications, data sync and many more. It also helps us to connect your app to many Enterprise systems. It provides a scale up facility for many customers across multiple geographies.
  • Working With JSON In SQL Server 2016Aug 28, 2017. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popular data interchange format nowadays. Most modern services return the data into the JSON text.
  • 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.
  • Use SharePoint Online List As A Data Source In Power BIAug 26, 2017. In this article, we will check how we can use SharePoint list as a Data source in Microsoft Power BI.
  • Accessing Microsoft Graph Data Using Azure AD Authentications From SPFxAug 24, 2017. Let us see how to call Microsoft cloud data using Azure Active Directory authentications from SharePoint framework components.
  • Understand Azure Cosmos DB - DocumentDB API (SQL)Aug 24, 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. It is schema-less and generally classified as a NoSQL database. In this article I am going to create an Azure Cosmos DB using SQL.
  • Virtual Machine Scale SetAug 23, 2017. Virtual Machines are highly flexible such that they can be changed in their size and the performance based on the requirement of the user. The resources which we actually require can be decided by us and then the user can be able to scale up or down the Virtual Machine. When making changes to the Virtual Machine size, the cost that is charged for the Virtual Machine will also vary. Here the size of the Virtual Machine will include the number of cores, the Random-Access Memory, number of data disks, the IOPS range, SSD size, load balancing feature and premium disk support.
  • 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.
  • Responsive Tables Using FootableAug 20, 2017. This article explains how to make an html table responsive using footable plugin.
  • 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.
  • 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.
  • Invoking AWS Lambda Function Using AWS API GatewayAug 17, 2017. In this article we will learn how Lambda function can be invoked through AWS API Gateway.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Learn Azure Blob StorageAug 11, 2017. Basically, it represents the durable store in the Azure cloud. And also, it allows storing blob, tables, messages, and queues.
  • 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.
  • 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.
  • 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.
  • AWS Lambda And Serverless ComputingAug 02, 2017. Before we learn and understand one of the great features provided by AWS known as AWS lambdas, let’s try to understand what Serverless Computing is.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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
  • 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.
  • 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.
  • 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.
  • 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
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • Writing Complex Queries Using LINQ And LambdaJun 22, 2017. I am writing this article based on request by some developers regarding how to write some complex queries using LINQ & Lambda expression which consist of joins / groupby / aggregate functions
  • Learn About Bootstrap TablesJun 21, 2017. In this article we will see how to create Bootstrap tables.

About Data-Table-Lambda-Expression

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!