Expert Dot Net

Trust me to find new way !

LINQ Aggregate on an array with tenary operator

18. January 2017 Vijaya C#.Net, LINQ (0)

using System;

using System.Collections;

using System.Collections.Generic;

using System.Text;

using System.Linq;

 

public class LINQDemo2{

   public static void Main(){

       int[] numbers = { 9, 3, 5, 4, 2, 6, 7, 1, 8 };

       var query = numbers.Aggregate(5, (a,b) => ( (a < b) ? (a * b) : a));

    }

}

 

LINQ Aggregate Use

18. January 2017 Vijaya C#.Net, LINQ (0)

using System;

using System.Collections;

using System.Collections.Generic;

using System.Text;

using System.Linq;

 

public class LINQDemo1 {

    public static void Main() {

        int[] numbers = { 1, 2, 3, 4, 5, 6, 7, 8, 9 };

        var query = numbers.Aggregate((a, b) => a * b);

    }

}

What is – DML, DDL, DCL and TCL

15. January 2017 Vijaya SQL Server (0)

DML - is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database.

e.g.: SELECT, UPDATE, INSERT statements

DDL - is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database.

e.g.: CREATE, ALTER, DROP statements

DCL -is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.

e.g.: GRANT, REVOKE statements

TCL - is abbreviation of Transactional Control Language. It is used to manage different transactions occurring within a database.

Introduction to SQL

15. January 2017 Vijaya SQL Server (0)

Introduction to SQL

  1. SQL stands for Structured Query Language
  2. SQL lets you access and manipulate databases
  3. SQL is an ANSI (American National Standards Institute) standard
Use of SQL

  1. SQL can execute queries against a database
  2. SQL can retrieve data from a database
  3. SQL can insert records in a database
  4. SQL can update records in a database
  5. SQL can delete records from a database
  6. SQL can create new databases
  7. SQL can create new tables in a database
  8. SQL can create stored procedures in a database
  9. SQL can create views in a database
  10. SQL can set permissions on tables, procedures, and views

How to Create Basic HTTP Binding in WCF

13. January 2017 Vijaya (0)

BasicHttpBinding

BasicHttpBinding is suitable for communicating with ASP.NET Web Service (ASMX) based services that conform to the WS-Basic Profile that conforms with Web Services.

  1. This binding uses HTTP as the transport and text/XML as the default message encoding.
  2. Security is disabled by default.
  3. This binding does not support WS-* functionalities like WS- Addressing, WS-Security, WS-ReliableMessaging.

Let's get started. Use the following procedure.

  1. Create a WCF basicHttpBinding project.
  2. Start Visual Studio and select New Project from the Start page or from the File menu, select New and then Project.
  3. After selecting, a dialog will pop up showing all the templates provided by Visual Studio.
  4. From the Installed Templates select C# then inside that select WCF and inside that you will select WCF Service Application. 

Introduction to WCF

13. January 2017 Vijaya Programming, WCF, Web Service (0)

Introduction to WCF

Windows Communication Foundation (Code named Indigo) is a programming platform and runtime system for building, configuring and deploying network-distributed services. It is the latest service oriented technology; Interoperability is the fundamental characteristics of WCF. It is unified programming model provided in .Net Framework 3.0. WCF is a combined features of Web Service, Remoting, MSMQ and COM+. WCF provides a common platform for all .NET communication.


Please refer the below Image




There are certain advantages and disadvantages as well which is given below :


Advantage

WCF is interoperable with other services when compared to .Net Remoting,where the client and service have to be .Net.

WCF services provide better reliability and security in compared to ASMX web services.

In WCF, there is no need to make much change in code for implementing the security model and changing the binding. Small changes in the configuration will make your requirements.

WCF has integrated logging mechanism, changing the configuration file settings will provide this functionality. In other technology developer has to write the code.

Disadvantage

Making right design for your requirement is little bit difficult. I will try to help you on solving these difficulties in the following article.