using System;

using System.Linq;

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        int[] intArray = new int[]{1,4,5,6,7,3,2};

        for(int i=0; i < intArray.Length ; i++)

        {

            for(int j=0 ; j <

                intArray[i]

        }

    }

}

​

​

getproduct(product productID)

{

​

try

{

  using(var db = new ProductDbContext())

{

 var Product = await db.Products.where(p => p.productID == productID).FirstorDefaultAsync();

}

​

SqlConnection connection = new Sqlconnection(Connectionstring);

var Product = connection.ExecuteStoreProcedure("GetProductDetails",ProductID);

​

}

​

Catch(DbconnectionException e)

{

   logError("Error in fetching Product detail"+ e.message);

   //throw new exception("Not able to take product data");

   //throw e;

   retrun new product();

}

Catch(Exception e)

{

   logError("Error in fetching Product detail"+ e.message);

   //throw new exception("Not able to take product data");

   //throw e;

   retrun new product();

}

​

Finally{

if(connection.isopen()){

connection.close()

}

}

​

}

​

​

​

​

​

​

​

​

​

​

​

​

class Product{ public int Number = 1; public string Name = "A"}

Main()

{

product p = new Product();

console.write(p.Number);   //1

console.write(p.Name);     //A

p.Name = "AA";

console.write(p.Name);      //AA

}

​

​

​

​

class Product{ public int Number = 1; public string Name = "A"

public UpdateValues(product p)

{

p.Number = 11;

}

}

Main()

{

product p = new Product();

console.write(p.Number);

console.write(p.Name);

p.Name = "AA"

console.write(p.Name);

p.UpdateValues(p);

console.write(p.Number);  // 11

}

​

​

​

Abstract class Employee

{

   int EmpID;

​

​

 protected abstract virtual int CalculateSalary();

 public void Work(){

    Console.writeline("Working..");

    }

}

​

public class ContractEmployee : Employee

{

​

public override int calculateSalary(){

​

return workinghours*5.5;

} 

​

}

​

public class PermenantEmployee: Employee

{

​

public override int calculateSalary(){

​

return workinghours*5.4;

} 

​

}

​

​

​

​

​

​

​

Public class CC1: ContractEmployee

{

public override calculateSalary()

{

return 100;

}

}

public class CC2: ContractEmployee

{

public override calculateSalary()

{

return 200;

}

}

ContractEmployee ce = new ContractEmployee();

ce.CalculateSalary();

ContractEmployee ce = new CC2();

ce.CalculateSalary();

​

​

​

​

​

​

create table Customer(

CID int Identity(1001,1) primary key,

Name Varchar(50) NOT null,

City Varchar(50) NOT null)

​

​

create table Account(

AccNum int Identity(10001,1) primary key,

AccType Varchar(25) NOT null,

CID int Foreign key (Table Customer Coloum CID))

​

​

​

​

select Max(C.Name),count(1) as NoofAccounts  from Account A

inner join Customer C on A.CID = C.CID

group by 

C.CID

having Count(*)>1

​

​

select C.Name from Account A

full outer join Customer C on A.CID = C.CID

where

A.AccNum is null

​

​

select C.Name from Customer C

left outer Account A on A.CID = C.CID

where

A.AccNum is null

​

​

​

​

​

​

​

​

​

​

​

​

​