tag:blogger.com,1999:blog-26177519361448278982026-02-28T02:11:47.552+05:30Dot Net | C#.Net | ASP.Net | SQL Server OOPs Concepts, C#.Net, Sql-serverYuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-2617751936144827898.post-54015999949642808342021-02-15T22:50:00.001+05:302021-02-15T22:53:28.080+05:30How to check what is in SQL Server plan cache
To see what is in SQL Server plan cache we will make use of the following 3 dynamic management views and functions provided by sql server1. sys.dm_exec_cached_plans2. sys.dm_exec_sql_text3. sys.dm_exec_query_planUse the following query to see what is in the plan cacheSELECT cp.usecounts, cp.cacheobjtype, cp.objtype, st.text, Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-26909610383726183682021-02-15T20:03:00.002+05:302021-02-15T20:03:40.902+05:30Open transactions with text and plansHere’s a little script that tells who has open transactions on the server – not just the single oldest active transaction that DBCC OPENTRAN returns.It gives back:session IDlogin namedatabase contexttransaction begin timehow many log records have been generated by the transactionhow much log space has been taken up by those log recordshow much log space has Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-79941848313208557762015-02-26T23:42:00.001+05:302020-01-18T18:11:19.289+05:30List generic collection class in C#List is a generic collection class which stores strongly typed objects into it.
List is an index based collection of object.
It provides methods to search, sort, Manipulate the lists of objects.
List is generic version of an ArrayList class.
List size can be increased or decreased as per requirement.
See below example of using List class
+Codeusing System;
using Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-17762678900950078292015-02-23T23:31:00.004+05:302020-01-18T18:13:17.834+05:30Dictionary Generic collection class in C#Dictionary class in C# is a generic type which stores objects in a Key-Value format.
We can store objects of TValue type as value with TKey type as its Key.
Retrieval of value using key is very fast.
Every key in dictionary must be unique.
A Key cannot be null, but a value can be null, if a type of value is reference type.
While enumerating dictionary elements using foreach loop, each element inYuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-69287673594448893922015-02-18T22:49:00.000+05:302020-01-18T18:13:42.089+05:30Stack class in C#Stack class object stores elements in Last In First Out(LIFO) manner, i.e. Element that gets added last into the stack will get removed first from the stack.
Element gets added from and removed from same end.
Use stack when you want to access element in the reverse order that they are stored in the collection.
Use stack if you want to discard the element as soon as you retrieve it.
See Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-25759384694380908792015-02-17T23:32:00.001+05:302020-01-18T18:14:59.490+05:30Queue class in C#Queue class is a circular array that stores elements in First In First Out(FIFO) manner, i.e. Element that gets added first into the queue will get removed first from the queue.
Element gets added from one end and removed from other end.
Use queue when you want to access element in the same order that it is stored in the collection.
Use Queue if you want to discard the element as soon as Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-36378257699411531032015-02-16T22:29:00.000+05:302020-01-18T18:15:29.094+05:30ArrayList in C#ArrayList is an index based ordered collection of objects.
It is like array, but like array its size is not fixed. It can dynamically grows or shrinks as per the requirement.
We can add as many Items as possible into arraylist till the memory is available.
As compared to Array, ArrayList is not type safe. Also it stores the objects into it, it is an overhead of boxing and unboxing of objects Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-18235124699685838612015-02-11T23:10:00.000+05:302015-02-16T22:29:31.692+05:30HashTable in C#
Hashtable stores elements in a Key/Value pair format and the elements are organized based on the hash code of the key.
In a Key/Value pair, Key should not be null, but a value can be null. Also Key should be unique, but value can be duplicate.
The Objects used as key are required to override GetHashCode and Equals methods of base class Object.
Like ArrayList, HashTable also have overhead of Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-86211442160914950662015-02-07T16:42:00.000+05:302015-02-11T23:11:55.030+05:30Reflection in C#.NetYou should have Knowledge of assemblies (dll or exe) before continuing this Topic.
Reflection in dot net is used to inspects assemblies(dll or exe) metadata at runtime.
By using reflection we can get all the details of the types(Classes, Interfaces, Stuctures) declared in an assembly and also we can dynamically invokes methods from these assemblies's types.
As you know dot net framework is a Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-70932711141696855132015-02-03T23:39:00.000+05:302015-02-07T20:38:55.611+05:30What is Delegate? What is the use of Delegate?
Delegate is type that references to a method that has signature and parameter type same as delegate signature and parameter type.
Delegates are type safe function pointer.
Delegate declaration is same like a method declaration but without the body.
Delegates allow functions to be passed as parameter to other functions.
using delegate keyword we can declare delegate type in C#.
See Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-9617903271976682042015-01-31T19:08:00.001+05:302015-02-11T23:12:44.776+05:30using block in C#.Net
using block in C# ensures correct use of IDisposable interface.
We can use using block only on the objects that implements IDisposable interface.
using block calls the dispose method of an object in a correct way and it also causes the object to go out of scope when dispose method of that object gets called.
using block gets converted to try..finally block after getting compiled to MSIL code. Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-59053859715981724652015-01-31T17:12:00.001+05:302020-01-18T18:18:29.903+05:30Error handling using Try Catch Finally blockIn C#, try block followed by one or more catch blocks is used for handling run-time Exceptions (Error).
Below is the example of using try catch block.
+Codeusing System;
namespace tryCatchFinally
{
class Program
{
static void Main(string[] args)
 Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-53778624000359023712015-01-13T12:36:00.002+05:302015-02-08T16:54:58.360+05:30Abstract Classes in C#
Abstract classes are special type of classes that we can't instantiate.
It contains abstract methods/Properties that has no implementation like the methods/Properties that we declare in Interface and it also contains methods/Properties with implementation like normal class.
Class deriving from abstact class must provide implementation to the abstract methods/Properties. We have to use overrideYuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-84110990211188694322015-01-07T13:03:00.050+05:302021-02-15T20:09:54.567+05:30SQL-Server Concepts
Return all the tables in the database which user have created
USE YourDataBaseName
GO
SELECT *
FROM sys.Tables
GO
To get all the databases on a server, you can use the same technique, but
just a bit different query.
USE Master
GO
SELECT *
FROM sys.Databases
GO
Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-49639629918542326692015-01-02T00:05:00.000+05:302015-02-07T20:40:17.255+05:30Interface and Use of Interface
We create Interfaces using Interface keyword.
Just like a class, Interface contains methods, Properties, events, delegates but we can only define these terms in Interface and we don’t have implementation for that in an Interface.
Interface can’t contains Fields, constants, operators, constructors, destructors.
Interface members are public by default. We can’t explicitly define access specifiersYuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-53172987937642841342014-12-31T12:29:00.000+05:302015-02-11T23:13:54.798+05:30Properties in C# and use of Properties
Properties are special type of members, declared to read/write private Fields within a declared Type(Class, Struct).
Properties are used as if they are public fields within a declared Type.
Properties have set and get accessor in order to set value to a private fields and get the value of a private fields.
By using properties we can hide private members of our Type.
Properties simplify the Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-3435773054442438492014-12-31T00:53:00.001+05:302015-02-07T20:34:11.051+05:30Partial Classes and Partial Methods
By using Partial keyword we can partly devides our class,Struct, Interface into two or more files. Later when the application gets compiled all the files gets combined.
Splitting application code into several files is helpful,
When there is a large project development, we can devide our class into several different files so that it enables multiple programmers to work simultaneously on that Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com1tag:blogger.com,1999:blog-2617751936144827898.post-80976630557237953892014-12-27T23:06:00.000+05:302015-02-18T23:30:55.860+05:30Structures in CSharp
1. Structure in C# is similar to the class. Just like class, We can encapsulate Fields, Properties, methods in structures.
2. By using Struct Keyword we can declare structure.
3. We can declare struct to represent lightweight objects such as int, enum, double, bool.
4. Struct is a value type.
Below is the example of struct.
+
Code
using System;
namespace constructor_example
{
Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-71752330110999538792014-12-27T20:33:00.000+05:302015-02-11T23:14:53.388+05:30Value Type and Reference Type variables
There are two types of memory available on disk while storing the variables that we declare - 1. Stack memory and Heap memory.
Value Type variables
1. Value type variables gets stored on Stack and stores data in its own memory location, i.e. both variable and data gets stored on stack.
2. When we copy data of one value type variable to another value type variable then 2 different copies of Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-25984584415398557242014-12-27T20:28:00.000+05:302015-02-07T20:35:48.682+05:30Data Type And Variables
A variable is nothing but a data store in which we store data that we are going to use in our application and data type is a term which describe what type of data you are storing in that variable.
So in order to store data in a variables, we first have to declare that variable and also declare the type of data we are storing in it i. e. we have to specify the data type for our variables Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-13935509202013548152014-12-27T20:15:00.000+05:302015-02-11T23:15:35.568+05:30Arrays in C#.Net
Array is a collection of similar data types. It is a sequential arrangements of our data and the data is stored with index starting from 0 index. We can use these index to access elements of an array. Arrays can be single dimensional, Multi dimensional or we can have arrays within array.
below is a syntax to declare array and an example of array.
[Data type][] variableName = new [Data type][Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-22705351177954190402014-11-30T14:15:00.004+05:302015-02-11T23:16:51.920+05:30Access Specifier example
For this example, We create 2 Class library named AccessSpecifier_Demo AND UsingAccessSpecifier. We will declare variables with all access specifiers in class AccessSpecifier_Declaration and will use the dll that is created into other class AccessSpecifier_UseInDifferentAssembly which is in another class library.
For creating class library
1. Open Visual studio
2. Click on New Menu => Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0tag:blogger.com,1999:blog-2617751936144827898.post-44946089243007010802014-11-27T01:57:00.002+05:302015-02-11T23:17:51.479+05:30Class Example
Let say we have a Company having various employees working in it. so now think of Employee is a class and we have Employee details such as Name, BirthDate, Salary as the fields associated with Employee class and we have methods defined as ComputeAnnualSalary, CalculateTotalPendingLeaves for the Employee class. Now we can show this Employee class in actual class format below(class represented Yuvihttp://www.blogger.com/profile/12972961608265789235noreply@blogger.com0