ASP Materials

How to install Azure Service Fabric in local machine.

2023-10-03T00:23:00.004-07:00

In this Post, I will guide you how to install Azure Service Fabric in your local Machine.

First download Service Fabric run time from below link.

https://download.microsoft.com/download/b/8/a/b8a2fb98-0ec1-41e5-be98-9d8b5abf7856/MicrosoftServiceFabric.9.1.1583.9590.exe

Then download Service fabric SDK from below link.

https://download.microsoft.com/download/b/8/a/b8a2fb98-0ec1-41e5-be98-9d8b5abf7856/MicrosoftServiceFabricSDK.6.1.1583.msi

Now Install each above downloaded file as below.

1. Service Fabric Runtime

Open CMD in administrative mode and paste the command as below

C:\Users\sony\Downloads>MicrosoftServiceFabric.9.1.1583.9590.exe /accepteula

2. Service Fabric SDK

Click on Service Fabric SDK msi package and Install it.

Once Installed, go to

C:\Program Files\Microsoft SDKs\Service Fabric\ClusterSetup folder and open DevClusterSetup.ps1 file in Power Shell(Open PS in admin mode) and execute this file.

Or paste below code in Power Shell

& "$ENV:ProgramFiles\Microsoft SDKs\Service Fabric\ClusterSetup\DevClusterSetup.ps1"

Once DevClusterSetup.ps1 file execute successfully, it will create service fabric cluster in your local machine.

Service Fabric Cluster:-

What is the difference between round and ceiling in SQL Server?

2023-09-23T10:39:00.001-07:00

In SQL Server, both the ROUND and CEILING functions are used to perform mathematical rounding of numerical values, but they have different behaviors:

ROUND:
- The ROUND function is used to round a numeric value to a specified number of decimal places.
- It performs "normal" rounding, which means that if the decimal part is equal to or greater than 0.5, it rounds up; otherwise, it rounds down.
- It can be used with both positive and negative numbers.
- The ROUND function takes two arguments: the numeric value to be rounded and the number of decimal places to round to.
Example:
```
SELECT ROUND(3.14159, 2); -- Returns 3.14 
```
SELECT ROUND(3.6); -- Returns 4
SELECT ROUND(-3.6); -- Returns -4
CEILING:
- The CEILING function is used to round a numeric value up to the nearest integer that is greater than or equal to the original value.
- It always rounds up, regardless of the decimal part of the number.
- It is commonly used when you want to ensure that a value is rounded up to the nearest whole number, even if the decimal part is very small.
- The CEILING function takes a single argument, which is the numeric value to be rounded up.
Example:
```
SELECT CEILING(3.14159); -- Returns 4
SELECT CEILING(3.6); -- Returns 4
SELECT CEILING(-3.6); -- Returns -3
```

In summary, the key difference between ROUND and CEILING in SQL Server is in how they handle rounding. ROUND performs standard rounding based on the decimal part of the number, while CEILING always rounds up to the next integer, regardless of the decimal part. Your choice between them depends on the specific rounding behavior you need for your calculations.

How to implement Azure Application Insight in Web app?

2023-09-23T02:49:00.003-07:00

Azure Application Insights is a powerful service for monitoring and gaining insights into the performance and usage of your web applications. To implement Application Insights in a web app, follow these steps:

Step 1: Create an Application Insights resource

Click on "+ Create a resource" on the left-hand menu.

Search for "Application Insights" in the Azure Marketplace.

Select "Application Insights" from the search results.

Click the "Create" button to create a new Application Insights resource.

Fill in the required details like Subscription, Resource Group, Region, and give it a name. You can also configure the pricing tier based on your needs. Click "Review + create" and then "Create" to provision the resource.

Step 2: Instrument your Web App

Now that you have an Application Insights resource, you need to instrument your web app to send telemetry data to it. This involves adding the Application Insights SDK to your application code. The exact steps may vary depending on the technology stack of your web app.

Below are some common scenarios:

ASP.NET Core Application (C#):

Open your ASP.NET Core project in Visual Studio.

Install the Microsoft.ApplicationInsights.AspNetCore NuGet package if not already installed:

Install-Package Microsoft.ApplicationInsights.AspNetCore

In the Startup.cs file, add the following code in the ConfigureServices method to configure Application Insights:

services.AddApplicationInsightsTelemetry(Configuration["ApplicationInsights:InstrumentationKey"]);

In the appsettings.json file, add your Application Insights Instrumentation Key:

"ApplicationInsights": {

"InstrumentationKey": "YOUR_INSTRUMENTATION_KEY"

}

Node.js Application:

Install the applicationinsights npm package:

npm install applicationinsights --save

In your Node.js code, require and configure Application Insights using your Instrumentation Key:

const appInsights = require("applicationinsights");

appInsights.setup("YOUR_INSTRUMENTATION_KEY").start();

Other Platforms: Application Insights has SDKs and integrations for various platforms. You can find specific instructions for your technology stack in the official documentation.

Step 3: Verify Integration

After instrumenting your web app, you can verify if telemetry data is being sent to Application Insights:

Run your web app.

In the Azure portal, navigate to your Application Insights resource.

Go to the "Overview" or "Logs" section to see telemetry data, including requests, exceptions, and performance metrics.

Step 4: Analyze and Monitor

With Application Insights set up, you can use it to:

Monitor application performance and detect issues.
Create custom dashboards and alerts.
Analyze user behavior and track conversions.
Debug and diagnose problems using distributed tracing.

Application Insights is a powerful tool for gaining insights into your web app's behaviour and performance, helping you improve its reliability and user experience.

Whay is difference between Azure Service Fabric and Azure Function App.

2023-09-23T02:12:00.003-07:00

Azure Service Fabric and Azure Function App are both Azure services that can be used for building and deploying applications, but they serve different purposes and have distinct characteristics. Here's a comparison of Azure Service Fabric and Azure Function App: Azure Service Fabric: Service Type: Service Fabric is a platform for building and managing microservices-based applications. It allows you to create and manage services that can be stateful or stateless and supports complex, multi-service applications. Programming Model: You have more control over the code and architecture of your services in Service Fabric. You can choose to use various programming languages (e.g., C#, Java, etc.) and frameworks (e.g., ASP.NET Core, Java Spring Boot) to develop your services. Service Types: Service Fabric supports stateful and stateless services, allowing you to build applications with persistent data and complex service orchestration. Scaling: It provides more granular control over scaling and load balancing. You can manually scale or use auto-scaling rules. Application Types: Service Fabric is suitable for building a wide range of applications, including microservices, containers, and legacy applications. Deployment: You have more control over how services are deployed and upgraded, including version management and rolling upgrades. Use Cases: It's ideal for complex, large-scale applications, especially those requiring high availability, stateful services, and complex service orchestration. Azure Function App: Service Type: Azure Functions is a serverless compute service that allows you to execute code in response to events without managing the underlying infrastructure. Programming Model: Azure Functions use a serverless programming model, where you write individual functions that are triggered by events (e.g., HTTP requests, timers, message queues). You don't need to worry about infrastructure management. Service Types: Azure Functions are typically stateless and designed to execute small units of code in a stateless manner. Scaling: Scaling is handled automatically by Azure Functions based on the number of incoming events or requests. You're billed only for the actual compute resources used during execution. Application Types: Azure Functions are well-suited for event-driven, small-to-medium-sized workloads where you want to focus on code and not worry about infrastructure management. Deployment: You deploy individual functions or sets of functions. Each function can have its own dependencies. Use Cases: Azure Functions are great for event-driven scenarios, such as processing messages from queues, handling HTTP requests, or responding to changes in data. In summary, the choice between Azure Service Fabric and Azure Function App depends on your specific application requirements: Choose Azure Service Fabric if you need fine-grained control over service architecture, stateful services, complex service orchestration, and you're building larger, complex applications. Choose Azure Function App if you want a serverless, event-driven architecture that automatically scales and you're building smaller, more focused functions that respond to events and triggers. Often, both services can be used together within a larger Azure solution to handle different parts of your application's functionality.

ReactJs Interview Questions Part -3

2022-08-20T21:07:00.004-07:00

21. What are forward refs?

Ref forwarding is a feature that lets some components take a ref they receive, and pass it further down to a child.

const ButtonElement = React.forwardRef((props, ref) => (

  <button ref={ref} className="CustomButton">

    {props.children}

  </button>

));

// Create ref to the DOM button:

const ref = React.createRef();

<ButtonElement ref={ref}>{'Forward Ref'}</ButtonElement>

22. Which is preferred option with in callback refs and findDOMNode()?

It is preferred to use callback refs over findDOMNode() API. Because findDOMNode() prevents certain improvements in React in the future.

The legacy approach of using findDOMNode:

class MyComponent extends Component {

  componentDidMount() {

    findDOMNode(this).scrollIntoView()

  render() {

    return <div />

The recommended approach is:

class MyComponent extends Component {

  constructor(props){

    super(props);

    this.node = createRef();

  componentDidMount() {

    this.node.current.scrollIntoView();

  render() {

    return <div ref={this.node} />

23. Why are String Refs legacy?

If you worked with React before, you might be familiar with an older API where the ref attribute is a string, like ref={'textInput'}, and the DOM node is accessed as this.refs.textInput. We advise against it because string refs have below issues, and are considered legacy. String refs were removed in React v16.

i. They force React to keep track of currently executing component. This is problematic because it makes react module stateful, and thus causes weird errors when react module is duplicated in the bundle.

ii. They are not composable — if a library puts a ref on the passed child, the user can't put another ref on it. Callback refs are perfectly composable.

iii. They don't work with static analysis like Flow. Flow can't guess the magic that framework does to make the string ref appear on this.refs, as well as its type (which could be different). Callback refs are friendlier to static analysis.

iv. It doesn't work as most people would expect with the "render callback" pattern (e.g. )

            v.     class MyComponent extends Component {

           vi.       renderRow = (index) => {

         vii.         // This won't work. Ref will get attached to DataTable rather than MyComponent:

        viii.         return <input ref={'input-' + index} />;

ix.

            x.         // This would work though! Callback refs are awesome.

           xi.         return <input ref={input => this['input-' + index] = input} />;

         xii.       }

        xiii.

         xiv.       render() {

           xv.         return <DataTable data={this.props.data} renderRow={this.renderRow} />

         xvi.       }

24. What is Virtual DOM?

The Virtual DOM (VDOM) is an in-memory representation of Real DOM. The representation of a UI is kept in memory and synced with the "real" DOM. It's a step that happens between the render function being called and the displaying of elements on the screen. This entire process is called reconciliation.

25. How Virtual DOM works?

The Virtual DOM works in three simple steps.

i. Whenever any underlying data changes, the entire UI is re-rendered in Virtual DOM representation.

ii. Then the difference between the previous DOM representation and the new one is calculated.

iii. Once the calculations are done, the real DOM will be updated with only the things that have actually changed.

26. What is the difference between Shadow DOM and Virtual DOM?

The Shadow DOM is a browser technology designed primarily for scoping variables and CSS in web components. The Virtual DOM is a concept implemented by libraries in JavaScript on top of browser APIs.

27. What is React Fiber?

Fiber is the new reconciliation engine or reimplementation of core algorithm in React v16. The goal of React Fiber is to increase its suitability for areas like animation, layout, gestures, ability to pause, abort, or reuse work and assign priority to different types of updates; and new concurrency primitives.

28. What is the main goal of React Fiber?

The goal of React Fiber is to increase its suitability for areas like animation, layout, and gestures. Its headline feature is incremental rendering: the ability to split rendering work into chunks and spread it out over multiple frames.

from documentation

Its main goals are:

i. Ability to split interruptible work in chunks.

ii. Ability to prioritize, rebase and reuse work in progress.

iii. Ability to yield back and forth between parents and children to support layout in React.

iv. Ability to return multiple elements from render().

v. Better support for error boundaries.

29. What are controlled components?

A component that controls the input elements within the forms on subsequent user input is called Controlled Component, i.e, every state mutation will have an associated handler function.

For example, to write all the names in uppercase letters, we use handleChange as below,

handleChange(event) {

  this.setState({value: event.target.value.toUpperCase()})

30. What are uncontrolled components?

The Uncontrolled Components are the ones that store their own state internally, and you query the DOM using a ref to find its current value when you need it. This is a bit more like traditional HTML.

In the below UserProfile component, the name input is accessed using ref.

class UserProfile extends React.Component {

  constructor(props) {

    super(props)

    this.handleSubmit = this.handleSubmit.bind(this)

    this.input = React.createRef()

  handleSubmit(event) {

    alert('A name was submitted: ' + this.input.current.value)

    event.preventDefault()

  render() {

    return (

      <form onSubmit={this.handleSubmit}>

        <label>

          {'Name:'}

          <input type="text" ref={this.input} />

        </label>

        <input type="submit" value="Submit" />

      </form>

);

In most cases, it's recommend to use controlled components to implement forms. In a controlled component, form data is handled by a React component. The alternative is uncontrolled components, where form data is handled by the DOM itself.

ReactJs interview Questions Part 2

2022-08-10T08:34:00.002-07:00

11. Why should we not update the state directly?

If you try to update the state directly then it won't re-render the component.

//Wrong

this.state.message = 'Hello world'

Instead use setState() method. It schedules an update to a component's state object. When state changes, the component responds by re-rendering.

//Correct

this.setState({ message: 'Hello World' })

Note: You can directly assign to the state object either in constructor or using latest javascript's class field declaration syntax.

12.What is the purpose of callback function as an argument of `setState()`?

The callback function is invoked when setState finished and the component gets rendered. Since setState() is asynchronous the callback function is used for any post action.

Note: It is recommended to use lifecycle method rather than this callback function.

setState({ name: 'John' }, () => console.log('The name has updated and component re-rendered'))

13. What is the difference between HTML and React event handling?

Below are some of the main differences between HTML and React event handling,

i. In HTML, the event name usually represents in lowercase as a convention:

<button onclick='activateLasers()'>

Whereas in React it follows camelCase convention:

<button onClick={activateLasers}>

ii. In HTML, you can return false to prevent default behavior:

<a href='#' onclick='console.log("The link was clicked."); return false;' />

Whereas in React you must call preventDefault() explicitly:

function handleClick(event) {

  event.preventDefault()

  console.log('The link was clicked.')

iii. In HTML, you need to invoke the function by appending () Whereas in react you should not append () with the function name. (refer "activateLasers" function in the first point for example)

14. How to bind methods or event handlers in JSX callbacks?

There are 3 possible ways to achieve this:

i. Binding in Constructor: In JavaScript classes, the methods are not bound by default. The same thing applies for React event handlers defined as class methods. Normally we bind them in constructor.

           ii.     class Foo extends Component {

         iii.       constructor(props) {

           iv.         super(props);

            v.         this.handleClick = this.handleClick.bind(this);

           vi.       }

         vii.       handleClick() {

        viii.         console.log('Click happened');

           ix.       }

            x.       render() {

           xi.         return <button onClick={this.handleClick}>Click Me</button>;

         xii.       }

xiii. Public class fields syntax: If you don't like to use bind approach then public class fields syntax can be used to correctly bind callbacks.

         xiv.     handleClick = () => {

           xv.       console.log('this is:', this)

<button onClick={this.handleClick}>

  {'Click me'}

</button>

xvi. Arrow functions in callbacks: You can use arrow functions directly in the callbacks.

        xvii.     handleClick() {

      xviii.         console.log('Click happened');

         xix.     }

           xx.     render() {

         xxi.         return <button onClick={() => this.handleClick()}>Click Me</button>;

Note: If the callback is passed as prop to child components, those components might do an extra re-rendering. In those cases, it is preferred to go with .bind() or public class fields syntax approach considering performance.

15. How to pass a parameter to an event handler or callback?

You can use an arrow function to wrap around an event handler and pass parameters:

<button onClick={() => this.handleClick(id)} />

This is an equivalent to calling .bind:

<button onClick={this.handleClick.bind(this, id)} />

Apart from these two approaches, you can also pass arguments to a function which is defined as arrow function

<button onClick={this.handleClick(id)} />

handleClick = (id) => () => {

    console.log("Hello, your ticket number is", id)

};

16.What are synthetic events in React?

SyntheticEvent is a cross-browser wrapper around the browser's native event. Its API is same as the browser's native event, including stopPropagation() and preventDefault(), except the events work identically across all browsers.

17. What are inline conditional expressions?

You can use either if statements or ternary expressions which are available from JS to conditionally render expressions. Apart from these approaches, you can also embed any expressions in JSX by wrapping them in curly braces and then followed by JS logical operator &&.

<h1>Hello!</h1>

    messages.length > 0 && !isLogin?

      <h2>

          You have {messages.length} unread messages.

      </h2>

      <h2>

          You don't have unread messages.

      </h2>

18. What is "key" prop and what is the benefit of using it in arrays of elements?

A key is a special string attribute you should include when creating arrays of elements. Key prop helps React identify which items have changed, are added, or are removed.

Most often we use ID from our data as key:

const todoItems = todos.map((todo) =>

  <li key={todo.id}>

    {todo.text}

  </li>

When you don't have stable IDs for rendered items, you may use the item index as a key as a last resort:

const todoItems = todos.map((todo, index) =>

  <li key={index}>

    {todo.text}

  </li>

Note:

i. Using indexes for keys is not recommended if the order of items may change. This can negatively impact performance and may cause issues with component state.

ii. If you extract list item as separate component then apply keys on list component instead of li tag.

iii. There will be a warning message in the console if the key prop is not present on list items.

19. What is the use of refs?

The ref is used to return a reference to the element. They should be avoided in most cases, however, they can be useful when you need a direct access to the DOM element or an instance of a component.

20. How to create refs?

There are two approaches

i. This is a recently added approach. Refs are created using React.createRef() method and attached to React elements via the ref attribute. In order to use refs throughout the component, just assign the ref to the instance property within constructor.

                               ii.     class MyComponent extends React.Component {

                             iii.       constructor(props) {

                               iv.         super(props)

                                v.         this.myRef = React.createRef()

                               vi.       }

                             vii.       render() {

                            viii.         return <div ref={this.myRef} />

                                   ix.       }

x. You can also use ref callbacks approach regardless of React version. For example, the search bar component's input element is accessed as follows,

                           xi.     class SearchBar extends Component {

                         xii.        constructor(props) {

                            xiii.           super(props);

                         xiv.           this.txtSearch = null;

                               xv.           this.state = { term: '' };

                         xvi.           this.setInputSearchRef = e => {

                        xvii.              this.txtSearch = e;

                          xviii.           }

                         xix.        }

                           xx.        onInputChange(event) {

                         xxi.           this.setState({ term: this.txtSearch.value });

                        xxii.        }

                          xxiii.        render() {

                        xxiv.           return (

                         xxv.              <input

                        xxvi.                 value={this.state.term}

                          xxvii.                 onChange={this.onInputChange.bind(this)}

                         xxviii.                 ref={this.setInputSearchRef} />

                        xxix.           );

                             xxx.        }

You can also use refs in function components using closures.

Note: You can also use inline ref callbacks even though it is not a recommended approach.

Source : https://github.com/sudheerj/reactjs-interview-questions#table-of-contents.

ReactJs Interview Questions Part 1

2022-08-06T03:10:00.005-07:00

1. What is React?

React is an open-source front-end JavaScript library that is used for building user interfaces, especially for single-page applications. It is used for handling view layer for web and mobile apps. React was created by Jordan Walke, a software engineer working for Facebook. React was first deployed on Facebook's News Feed in 2011 and on Instagram in 2012.

2. What are the major features of React?

The major features of React are:

o It uses VirtualDOM instead of RealDOM considering that RealDOM manipulations are expensive.

o Supports server-side rendering.

o Follows Unidirectional data flow or data binding.

o Uses reusable/composable UI components to develop the view.

3. What is JSX?

JSX is a XML-like syntax extension to ECMAScript (the acronym stands for JavaScript XML). Basically it just provides syntactic sugar for the React.createElement() function, giving us expressiveness of JavaScript along with HTML like template syntax.

In the example below text inside <h1> tag is returned as JavaScript function to the render function.

class App extends React.Component {

  render() {

    return(

      <div>

        <h1>{'Welcome to React world!'}</h1>

      </div>

4. What is the difference between Element and Component?

An Element is a plain object describing what you want to appear on the screen in terms of the DOM nodes or other components. Elements can contain other Elements in their props. Creating a React element is cheap. Once an element is created, it is never mutated.

The object representation of React Element would be as follows:

const element = React.createElement(

  'div',

  {id: 'login-btn'},

  'Login'

The above React.createElement() function returns an object:

  type: 'div',

  props: {

    children: 'Login',

    id: 'login-btn'

And finally it renders to the DOM using ReactDOM.render():

<div id='login-btn'>Login</div>

Whereas a component can be declared in several different ways. It can be a class with a render() method or it can be defined as a function. In either case, it takes props as an input, and returns a JSX tree as the output:

const Button = ({ onLogin }) =>

  <div id={'login-btn'} onClick={onLogin}>Login</div>

Then JSX gets transpiled to a React.createElement() function tree:

const Button = ({ onLogin }) => React.createElement(

  'div',

  { id: 'login-btn', onClick: onLogin },

  'Login'

5. How to create components in React?

There are two possible ways to create a component.

i. Function Components: This is the simplest way to create a component. Those are pure JavaScript functions that accept props object as the first parameter and return React elements:

           ii.     function Greeting({ message }) {

         iii.       return <h1>{`Hello, ${message}`}</h1>

iv.

v. Class Components: You can also use ES6 class to define a component. The above function component can be written as:

           vi.     class Greeting extends React.Component {

         vii.       render() {

        viii.         return <h1>{`Hello, ${this.props.message}`}</h1>

           ix.       }

6. When to use a Class Component over a Function Component?

If the component needs state or lifecycle methods then use class component otherwise use function component. However, from React 16.8 with the addition of Hooks, you could use state , lifecycle methods and other features that were only available in class component right in your function component. *So, it is always recommended to use Function components, unless you need a React functionality whose Function component equivalent is not present yet, like Error Boundaries *

7. What are Pure Components?

React.PureComponent is exactly the same as React.Component except that it handles the shouldComponentUpdate() method for you. When props or state changes, PureComponent will do a shallow comparison on both props and state. Component on the other hand won't compare current props and state to next out of the box. Thus, the component will re-render by default whenever shouldComponentUpdate is called.

8. What is state in React?

State of a component is an object that holds some information that may change over the lifetime of the component. We should always try to make our state as simple as possible and minimize the number of stateful components.

Let's create a user component with message state,

class User extends React.Component {

  constructor(props) {

    super(props)

    this.state = {

      message: 'Welcome to React world'

  render() {

    return (

      <div>

        <h1>{this.state.message}</h1>

      </div>

State is similar to props, but it is private and fully controlled by the component ,i.e., it is not accessible to any other component till the owner component decides to pass it.

9. What are props in React?

Props are inputs to components. They are single values or objects containing a set of values that are passed to components on creation using a naming convention similar to HTML-tag attributes. They are data passed down from a parent component to a child component.

The primary purpose of props in React is to provide following component functionality:

. Pass custom data to your component.

i. Trigger state changes.

ii. Use via this.props.reactProp inside component's render() method.

For example, let us create an element with reactProp property:

<Element reactProp={'1'} />

This reactProp (or whatever you came up with) name then becomes a property attached to React's native props object which originally already exists on all components created using React library.

props.reactProp

10. What is the difference between state and props?

Both props and state are plain JavaScript objects. While both of them hold information that influences the output of render, they are different in their functionality with respect to component. Props get passed to the component similar to function parameters whereas state is managed within the component similar to variables declared within a function.

Source : https://github.com/sudheerj/reactjs-interview-questions#table-of-contents.

What is Azure Service Fabrics.

2019-05-23T12:27:00.000-07:00

What is Azure Service Fabrics?

Azure Service Fabric is a distributed systems platform that makes it easy to package, deploy, and manage scalable and reliable microservices and containers. Service Fabric also addresses the significant challenges in developing and managing cloud native applications. Developers and administrators can avoid complex infrastructure problems and focus on implementing mission-critical, demanding workloads that are scalable, reliable, and manageable. Service Fabric represents the next-generation platform for building and managing these enterprise-class, tier-1, cloud-scale applications running in containers.

Key Point for Azure Service Fabrics :-

· Deploy to Azure or to on-premises datacenters that run Windows or Linux with zero code changes. Write once, and then deploy anywhere to any Service Fabric cluster.

· Develop scalable applications that are composed of microservices by using the Service Fabric programming models, containers, or any code.

· Develop highly reliable stateless and stateful microservices. Simplify the design of your application by using stateful microservices.

· Use the novel Reliable Actors programming model to create cloud objects with self contained code and state.

· Deploy and orchestrate containers that include Windows containers and Linux containers. Service Fabric is a data aware, stateful, container orchestrator.

· Deploy applications in seconds, at high density with hundreds or thousands of applications or containers per machine.

· Deploy different versions of the same application side by side, and upgrade each application independently.

· Manage the lifecycle of your applications without any downtime, including breaking and nonbreaking upgrades.

· Scale out or scale in the number of nodes in a cluster. As you scale nodes, your applications automatically scale.

· Monitor and diagnose the health of your applications and set policies for performing automatic repairs.

· Watch the resource balancer orchestrate the redistribution of applications across the cluster. Service Fabric recovers from failures and optimizes the distribution of load based on available resources.

Angular2 Fundamental Questions

2019-05-23T11:53:00.000-07:00

Angular2 fundamentals Questions

• 1 What is AngularJS?

• 2 What is Angular and what are the various versions of Angular?

• 3 Why was version 3 skipped?

• 4 Why we need Angular?

• 5 What is the problem in Angular JS so we are using Angular?

• 6 Which language we can use with Angular for Component creation?

• 7 What is need of TypeScript in Angular?

• 8 Can I use another language except TypeScript for Angular?

• 9 What is Angular CLI?

• 10 Why we are using Angular CLI while we have another method for Angular application creation?

• 11 What is the difference between various version of Angular?

• 12 What are the prerequisites for Angular?

• 13 How can we check the version of Angular?

• 14 What are the best IDE for Angular?

• 15 How can we run two Angular projects simultaneously?

• 16 What is bootstrapping in Angular? Is it possible to start Angular in any other way rather than appmodule? If yes, then how?

• 17 How does an Angular application get start?

• 18 What is the Architecture Overview of Angular?

• 19 We cannot reload our Angular application after changing in code It automatically changes this code How?

• 20 Which files bundled and injected in index HTML at runtime by webpack?

• 21 Can we create the Angular application without Angular CLI?

• 22 What is npm and what is the need for Angular application?

• 23 What is the difference between AOT and JIT?

• 24 What is transpilation concept of Angular?

• 25 Can we add more than one component in bootstrap in @NgModule?

Class 'Subject' incorrectly extends base class 'Observable' [duplicate]

2019-01-17T02:36:00.002-08:00

in the compiler-options for typescript (tsconfig.json) set

    "skipLibCheck": true

The operation could not be completed. invalid pointer - Visual Studio 2015 Update 3

2019-01-16T02:25:00.001-08:00

This is an old thread but the same symptom has come back but based on a new cause.

Please, clear the Visual Studio component cache, restart Visual Studio and retry. I suspect that you have some version conflict between components after update. The component cache is located at

Users\{yourusername}\AppData\Local\Microsoft\VisualStudio\14.0\ComponentModelCache

and afterwards restart the Visual studio.

XML interview Questions?

2017-09-06T00:14:00.000-07:00

What is XML?

XML is a file extension for an Extensible Markup Language (XML) file format used to create common information formats and share both the format and the data on the World Wide Web, intranets, and elsewhere using standard ASCII text.

XML is similar to HTML. Both XML and HTML contain markup symbols to describe the contents of a page or file. HTML, however, describes the content of a Web page (mainly text and graphic images) only in terms of how it is to be displayed and interacted with. For example, the letter "p" placed within markup tags starts a new paragraph.

What is the version information in XML?

“version” tag shows which version of XML is used.

Its used to uniquely identify the XML and enable the developer to identify which XML to be used in appropriate places.

What is ROOT element in XML?

In any markup language, the first element to appear is called the "root element", which defines what kind of document the file will be. In an HTML file, the <html> tag is the root element. An HTML file will always have the HTML element as the root element, while in an XML file, it can be anything.

In an XML file, there can only be one root element. The root element must encapsulate all other elements--meaning, these other elements must show up after the opening root tag and before the closing root tag. Here is an example of an XML document with the root element "phonebook".

XML Code:-

</number>

<name>

</name>

</phonebook>

If XML does not have closing tag will it work?

No, every tag in XML which is opened should have a closing tag. For instance in the top if I remove </discount> tag that XML will not be understood by lot of application.

Is XML case sensitive?

Yes - XML is case sensitive.

What is the difference between XML and HTML?

XML was designed to carry data - with focus on what data is
HTML was designed to display data - with focus on how data looks
XML tags are not predefined like HTML tags are
XML store data - HTML present it

Is XML meant to replace HTML?

No. XML itself does not replace HTML. Instead, it provides an alternative which allows you to define your own set of markup elements. HTML is expected to remain in common use on the web, and the current versions of HTML (XHTML and HTML5) are in XML syntax.

XML is designed to make the writing of processing software much easier than with SGML, which is what the original HTML was based on.

Can you explain why your project needed XML?

XML was meant to exchange data between two entities as you can define your user friendly tags with ease. In real world scenarios XML is meant to exchange data. For
instance you have two applications who want to exchange information. But because they
work in two complete opposite technologies it’s difficult to do it technically. For instance
one application is made in JAVA and the other in .NET. But both languages understand
XML so one of the applications will spit XML file which will be consumed and parsed by
other applications

What is DTD (Document Type Definition)?

A DTD is a Document Type Definition.

A DTD defines the structure and the legal elements and attributes of an XML document.

Why Use a DTD?

With a DTD, independent groups of people can agree on a standard DTD for interchanging data.

An application can use a DTD to verify that XML data is valid.

An Internal DTD Declaration

If the DTD is declared inside the XML file, it must be wrapped inside the <!DOCTYPE> definition:

XML document with an internal DTD

<?xml version="1.0"?>
<!DOCTYPE note [
<!ELEMENT note (to,from,heading,body)>
<!ELEMENT to (#PCDATA)>
<!ELEMENT from (#PCDATA)>
<!ELEMENT heading (#PCDATA)>
<!ELEMENT body (#PCDATA)>
]>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend</body>
</note>

An External DTD Declaration

<?xml version="1.0"?>
<!DOCTYPE note SYSTEM "note.dtd">
<note>
  <to>Tove</to>
  <from>Jani</from>
  <heading>Reminder</heading>
  <body>Don't forget me this weekend!</body>
</note>

And here is the file "note.dtd", which contains the DTD:

If the DTD is declared in an external file, the <!DOCTYPE> definition must contain a reference to the DTD file:

<!ELEMENT note (to,from,heading,body)>
<!ELEMENT to (#PCDATA)>
<!ELEMENT from (#PCDATA)>
<!ELEMENT heading (#PCDATA)>
<!ELEMENT body (#PCDATA)>

What is well formed XML?

An XML document with correct syntax is called "Well Formed".

An XML document validated against a DTD is both "Well Formed" and "Valid".

What is a valid XML?

What is CDATA section in XML?

The CDATASection object represents a CDATA section in a document.

A CDATA section contains text that will NOT be parsed by a parser. Tags inside a CDATA section will NOT be treated as markup and entities will not be expanded. The primary purpose is for including material such as XML fragments, without needing to escape all the delimiters.

The only delimiter that is recognized in a CDATA section is "]]>" - which indicates the end of the CDATA section. CDATA sections cannot be nested.

Example:

The following markup code shows an example of CDATA. Here, each character written inside the CDATA section is ignored by the parser.

<![CDATA[

<message> Welcome to TutorialsPoint </message>

]] >

</script >

What is XSL?

What is element and attributes in XML?

Element :-

An XML element is everything from (including) the element's start tag to (including) the element's end tag.

Example:-

Attribute :

Attribute values must always be quoted. Either single or double quotes can be used.

For a person's gender, the <person> element can be written like this:

Example:

Which are the namespaces in .NET used for XML?

System.Xml Namespaces

What are the standard ways of parsing XML document?

By using XMLDocument and XDocument

In What scenarios will you use a DOM parser and SAX parser?

How was XML handled during COM times?

What is the main difference between MSML and .NET Framework XML classes?

What are the core functionalities in XML .NET framework? Can you explain in detail those

functionalities?

What is XSLT?

With XSLT you can transform an XML document into HTML.

Define XPATH?

XPath is a major element in the XSLT standard.

XPath can be used to navigate through elements and attributes in an XML document.

What is the concept of XPOINTER?

What is an XMLReader Class?

What is XMLTextReader?

How do we access attributes using “XmlReader”?

Explain simple Walk through of XmlReader.

What does XmlValidatingReader class do?

C#.Net Basic Questions?

2017-08-18T02:48:00.003-07:00

What is an IL code?
Why IL code is not fully compiled?
Who compiles the IL code and how does it work?
How does JIT compilationwork?
What are different types of JIT?
What is Native Image Generator (Ngen.exe)?
So does it mean that NGEN.EXE will always improve performance?
What is a CLR?
What is the difference betweenmanaged and unmanaged code?
What is a garbage collector?
What are generations in Garbage collector (Gen 0, 1 and 2)?
Garbage collector cleans managed code, howdo we clean unmanaged code?
But when we create a destructor the performance falls down?
So how can we clean unmanaged objects and also maintain performance?
Can we force garbage collector to run?
What is the difference between finalize and dispose?
What is CTS?
What is a CLS (Common Language Specification)?
What is an Assembly?
What are the different types of Assembly?
What is Namespace?
What is Difference between NameSpace and Assembly?
What is ILDASM?
What is Manifest?
Where is the version information stored of an assembly?
Is versioning applicable to private assemblies?
What is the use of strong names?
What is Delay signing?
What is GAC?
How to add and remove an assembly from GAC?
If we have two versions of the same assembly in GAC how to we make a choice?
What is reflection?
What are stack and heap?
What are Value types and Reference types?
What is concept of Boxing and Unboxing?
How performance is affected due to boxing and unboxing?
How can we avoid boxing and unboxing?
How to prevent my .NET DLL to be decompiled?
What is the difference between Convert.toString and .toString () method?
How can we handle exceptions in .NET?
How can I know from which source the exception occurred?
What if we do not catch the exception?
What are system level exceptions and application level exceptions?
Can two catch blocks be executed?
What are different types of collections in .NET?
What is the difference between arraylist and list?
Are Arraylist faster or Arrays?
What are hashtable collections?
What are Queues and stack collection?
Can you explain generics in .NET?
Can you explain the concept of generic collection?
What is the difference between dictionary and hashtable?
What are the generic equivalent for array list,stack, queues and hashtable?
What is the use of IEnumerable, ICollection, Ilist and IDictionary?
What is code access security (CAS)?
So how does CAS actually work?
Is CAS supported in .NET 4.0?
What is sandboxing?
How can we create a windows service using .NET?
What is serialization and deserialization in .NET?
Can you mention some scenarios where we can use serialization?
When should we use binary serialization as compared to XML serialization?
Can you explain the concept of “Short Circuiting”?
What is the difference between “Typeof” and “GetType”?
Will the following c# code compile?

Virtual vs Overriding vs New keyword in c#?

2017-01-14T23:37:00.001-08:00

Virtual and Overriding keyword are used for method overriding. Method overriding is concept of Polymorphism. New keyword is used for method hiding.

Now we check how to use this keyword in c# by example.

Example 1:-

namespace ConsoleProg

{

class A

{

public void show()

{

Console.WriteLine("A");

}

class B : A

{

public void show()

{

Console.WriteLine("B");

}

class C : B

{

public void show()

{

Console.WriteLine("C");

}

class Program

{

static void Main()

{

A a = new A();

a.show(); // print-- A

B b = new B();

b.show(); // print-- B

C c = new C();

c.show(); // print-- C

A a1 = new B();

a1.show(); // print-- A

}

Note:- But it show some warning message.

1.) 'ConsoleProg.B.show()' hides inherited member 'ConsoleProg.A.show()'. Use the new keyword if hiding was intended.

2.) ‘ConsoleProg.C.show()' hides inherited member 'ConsoleProg.B.show()'. Use the new keyword if hiding was intended.

Solution of the above warning is use either new keyword or overriding keyword in derived class in method.

Virtual And Overriding keyword (Method overriding):-

If you want to be method overriding in the derived class, then the base class method must have the virtual keyword otherwise it will throw an error.

Example 2:-

namespace ConsoleProg

{

class A

{

public virtual void show()

{

Console.WriteLine("A");

}

class B : A

{

public override void show()

{

Console.WriteLine("B");

}

class C : B

{

public override void show()

{

Console.WriteLine("C");

}

class Program

{

static void Main()

{

A a = new A();

a.show(); // print-- A

B b = new B();

b.show(); // print-- B

C c = new C();

c.show(); // print-- C

A a1 = new B();

a1.show(); // print-- B

}

New Keyword (Method hiding):

New keyword is used for method hiding the base class method from derived class.

Example 3:-

namespace ConsoleProg

{

class A

{

public void show()

{

Console.WriteLine("A");

}

class B : A

{

public new void show()

{

Console.WriteLine("B");

}

class Program

{

static void Main()

{

A a = new A();

a.show(); // print-- A

B b = new B();

b.show(); // print-- B

A a1 = new B();

a1.show(); // print-- B

}

Method Overriding and Hiding:-

Example 4:-

namespace ConsoleProg

{

class A

{

public void show()

{

Console.WriteLine("A");

}

class B : A

{

public new virtual void show()

{

Console.WriteLine("B");

}

class C : B

{

public override void show()

{

Console.WriteLine("C");

}

class Program

{

static void Main()

{

A a = new A();

a.show(); // print-- A

B b = new B();

b.show(); // print-- B

C c = new C();

c.show(); // print-- C

A a1 = new B();

a1.show(); // print-- A

B b2 = new C();

b2.show(); // print-- C

A a2 = new C();

a2.show();// print-- A

}

Example 5:

namespace ConsoleProg

{

class A

{

public virtual void show()

{

Console.WriteLine("A");

}

class B : A

{

public override void show()

{

Console.WriteLine("B");

}

class C : B

{

public override void show()

{

Console.WriteLine("C");

}

class Program

{

static void Main()

{

A a = new A();

a.show(); // print-- A

B b = new B();

b.show(); // print-- B

C c = new C();

c.show(); // print-- C

A a1 = new B();

a1.show(); // print-- A

B b2 = new C();

b2.show();// print-- C

A a2 = new C();

a2.show();// print-- C

}

Example 6:

namespace ConsoleProg

{

class A

{

public virtual void show()

{

Console.WriteLine("A");

}

class B : A

{

public override void show()

{

Console.WriteLine("B");

}

class C : B

{

public new void show()

{

Console.WriteLine("C");

}

class Program

{

static void Main()

{

A a = new A();

a.show(); // print-- A

B b = new B();

b.show(); // print-- B

C c = new C();

c.show(); // print-- C

A a1 = new B();

a1.show(); // print-- A

B b2 = new C();

b2.show(); // print-- B

A a2 = new C();

a2.show(); // print-- B

}

Important Point:

Override:-

1.) Use this keyword polymorphism implementation along with virtual.

2.) With same name and parameter as in base class.

3.) It is call called as run time polymorphism.

4.) Also called as late binding.

New :-

1.) It is used in polymorphism concept.

2.) With same name and different parameters.

3.) Compile time bindig.

4.) Also called early binding.

How to achieve method overloading in MVC? Or is it possible to achieve Method overloading in asp.net mvc?

2016-12-15T02:59:00.005-08:00

Method overloading is possible in asp.net MVC.

This is general question which is asked in an interview.

Overloading or in other word we can say Polymorphism, it is the part of c# language. Http does not aware of this thing. Http works on URL concept and URL should be unique.

We can achieve overloading by the use of acceptverb attribute like HttpGet or HttpPost etc.

We can also use ActionMethod attribute above the method name in controller.

Example:-

public class HomeController : Controller

{

public ActionResult MethodName()

{

return Content("Method overloading with no parameter.");

}

[ActionName("TestMethod")]

public ActionResult MethodName(string name)

{

return Content("Method overloading with with parameter:" + name);

}

Note:-

If you didn’t put attribute ActionName above Method name then it will error at run time.

What is ISNUMERIC in SQL Server 2008R2?

2016-12-11T23:15:00.002-08:00

Definition:-

ISNUMERIC () is a function to determines where an expression is valid numeric type or not.

ISNUMERIC return 1 when input expression is valid numeric data type, otherwise it return 0.

Syntax:-

ISNUMERIC (expression)

ReturnType:-

Int

Note:-

ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($).

Example:-

Select ISNUMERIC('123')

Select ISNUMERIC(123)

Output:

References taken from MSDN.

Practical difference between constant and readonly in c#?

2016-11-25T09:15:00.001-08:00

Constant(const)	Readonly
Constant is immutable values and do not change their value for the life of program. Constants are known as compile time.	ReadOnly is also immutable value and do not change their value for the life of program. ReadOnly is known as runtime.
Assigned a value at the time of declaration. Ex:- public const int number = 0;	Assigned a value either at run time or inside a constructor(instance initialization). Ex:- class Program { public readonly int number = 10; public Program() { number = 20; } }
Constant cannot be static i.e you cannot declared constant as static. Ex:- public static const int number = 10; It will throw error at compile time.	Readonly can be static i.e you can declare readonly as static. Ex:- public static readonly int number = 10; It will not give an error.
Constant value can access with class name. Ex:- class Program { public const int number = 10; static void Main() { Console.Write(Program.number); } }	Readonly value can access by instance of class. Ex:- class Program { public readonly int number = 10; static void Main() { Program p=new Program(); Console.Write(p.number); } }

What will happen if exception will occur in exception block in c #?

2016-10-18T04:54:00.004-07:00

If exception will occur in try block then exception or error is cached by catch block. If final block is with try catch then after exception final block will execute.

In some scenario, if exception occurs in catch block, then code will abort in catch block because no catch block is there for catching an error or exception. So we check our code and will use nested try catch in application.

Example:-

static void Main(string[] args)

{

try

{

int a = 10;

int b = 0;

int c = a / b;

Console.WriteLine("divide by zero");

}

catch(Exception ex) // exception will catch here

{

string path=@"D:\Test\";

File.Copy(path + "xml.xml", path + "xml.xml"); // trying to copy a file but here path does not exist so again exception throw and then code will abort

Console.WriteLine("");

}

finally

{

Console.WriteLine("Final");

}

In the above example, exception will occur in try block and it will catch by catch block. But again exception will occur in catch block because path does not exist. So after that code will abort here means execution will stop here. So final block will not execute.

So according to you requirement or you know that exception will again occur in catch block then you use nested try-catch block.

How to get columns value separated by comma in MS-SQL?

2016-10-10T04:52:00.003-07:00

There are many scenario come to show columns value separated by comma.

This can be achieved by FOR XML PATH with STUFF function.

Now you have tabled like below.

Now you want to fetch the records from table to show student name , corresponding subject which is separated by comma.

SQL-Query:-

Select distinct s1.studentname,

STUFF((select distinct ','+s2.[subject]

from tbl_student s2 where s1.studentname=s2.studentname

for xml Path(''),Type).value('.','varchar(max)'),1,1,'')subject

from tbl_student s1

OutPut:-

How to auto refresh of web user control in web page in asp.net ?

2016-10-08T05:48:00.002-07:00

By using Timer control , you can auto refresh a user control inside a page in asp.net. You can use timer control along with update panel control to auto refresh a user control.

Let’s see a simple example . I have created a user control and I keep one label, one timer and update panel control. Put label control inside update panel control. Keep timer control outside of update panel control.

UserControl.ascx:-

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="WebUserControl1.ascx.cs" Inherits="WebApplicationTest.UserControl1" %>

<asp:ScriptManager ID="ScriptManager1" runat="server" />

<asp:Timer runat="server" id="UpdateTimer" interval="5000" ontick="UpdateTimer_Tick" />

<asp:UpdatePanel runat="server" id="TimedPanel" updatemode="Conditional">

<asp:AsyncPostBackTrigger controlid="UpdateTimer" eventname="Tick" />

</Triggers>

Time On UserControl :

<asp:Label runat="server" id="DateLabel" />

</ContentTemplate>

</asp:UpdatePanel>

UserControl.ascx.cs:-

protected void UpdateTimer_Tick(object sender, EventArgs e)

{

DateLabel.Text = DateTime.Now.ToString();

}

Now create one default.aspx page and drag and drop usercontrol.ascx control on default.aspx page.

Default.aspx:-

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplicationTest.Default" %>

<%@ Register src="UserControl1.ascx" tagname="UserControl1" tagprefix="uc1" %>

<!DOCTYPE html>

</head>

<body>

<div>

Time on Default Page:<asp:Label runat="server" id="Label1" />

</div>

<uc1:WebUserControl1 ID="UserControl11" runat="server" />

</form>

</body>

</html>

Default.aspx.cs:-

protected void Page_Load(object sender, EventArgs e)

{

Label1.Text = DateTime.Now.ToString();

}

This is very simple. In Above code Timer is used, which will Tick every 5 second. So every 5 seconds it will show the updated time on user control.

Difference between PATINDEX and CHARINDEX in SQL SERVER 2008R2?

2016-10-07T00:32:00.000-07:00

CHARINDEX :- It is used to find a start_position of a specified text in the expression. It accepts two parameters.

Syantax:-

Select CHARINDEX(string_expression,target_expression)

Example:-

Select CHARINDEX('e','abcdeavb')

In the above we try to find postion of ‘e’ in ‘abcdeavb’ expression.

PATINDEX:- It is also used to find start_position of specified text in the expression. It accepts two parameters. In PATINDEX we can use wildcard character like ‘%’ and ‘_’ .

Syntax:-

Select PATINDEX(search_pattern_literal,expression)

Example:-

Select PATINDEX('%ab%','sadabdfkjafbksdfk')

Output:-

Select PATINDEX('%a_b%','sadabdfkjafbksdfk')

Output:-

What is the meaning of httpGetEnabled or httpsgetEnabled is True/False in WCF?

2016-10-07T00:23:00.004-07:00

httpGetEnabled or httpsgetEnabled expose the metadata via WSDL through default url, even if you did not defined MEX endpoint in the service.

Difference between @html.Partial and @html.RenderPartial in mvc?

2016-09-30T03:44:00.001-07:00

@Html.Partial :- It’s return MvcHtmlString.

We can use Partial when you want to store little bit of text that need to be stored in variable.

It is slower than @Html.renderPartial.

@Html.RenderPartial :- It’s return void.
It is use like custom control in asp.net where lots of html that not need to be stored in variable.
It is faster than @Html.Partial.

How to take a backUp of single table in SQL Server 2008R2?

2016-09-29T02:02:00.000-07:00

Select * into new_tabel_Name from tablename

new_table_Name :- new table in which you want to store data(No need to create a table. It automatically create when you run the query)

tablename :- Existing table from which you want to take a back up

What is Automatic Activation in WCF?

2016-09-13T03:30:00.001-07:00

Automatic Activation means service will start\activate when a message request is received. In IIS, service is not always running. Service is monitored by ISS itself. IIS check if service is idle or unresponsive then it stops the service process. The next time a client calls the service, the process is recycled and restarted.

Note:-

IIS and WAS provides Automatic Activation.

Reference:- MSDN

ASP Materials

How to install Azure Service Fabric in local machine.

What is the difference between round and ceiling in SQL Server?

How to implement Azure Application Insight in Web app?

Whay is difference between Azure Service Fabric and Azure Function App.

ReactJs Interview Questions Part -3

21. What are forward refs?

22. Which is preferred option with in callback refs and findDOMNode()?

23. Why are String Refs legacy?

24. What is Virtual DOM?

25. How Virtual DOM works?

26. What is the difference between Shadow DOM and Virtual DOM?

27. What is React Fiber?

28. What is the main goal of React Fiber?

29. What are controlled components?

30. What are uncontrolled components?

ReactJs interview Questions Part 2

11. Why should we not update the state directly?

12.What is the purpose of callback function as an argument of setState()?

13. What is the difference between HTML and React event handling?

14. How to bind methods or event handlers in JSX callbacks?

15. How to pass a parameter to an event handler or callback?

16.What are synthetic events in React?

17. What are inline conditional expressions?

18. What is "key" prop and what is the benefit of using it in arrays of elements?

19. What is the use of refs?

20. How to create refs?

ReactJs Interview Questions Part 1

1. What is React?

2. What are the major features of React?

3. What is JSX?

4. What is the difference between Element and Component?

5. How to create components in React?

6. When to use a Class Component over a Function Component?

7. What are Pure Components?

8. What is state in React?

9. What are props in React?

10. What is the difference between state and props?

What is Azure Service Fabrics.

Angular2 Fundamental Questions

Angular2 fundamentals Questions

Class 'Subject' incorrectly extends base class 'Observable' [duplicate]

The operation could not be completed. invalid pointer - Visual Studio 2015 Update 3

XML interview Questions?

C#.Net Basic Questions?

Virtual vs Overriding vs New keyword in c#?

How to achieve method overloading in MVC? Or is it possible to achieve Method overloading in asp.net mvc?

What is ISNUMERIC in SQL Server 2008R2?

Definition:-

Syntax:-

ReturnType:-

Practical difference between constant and readonly in c#?

What will happen if exception will occur in exception block in c #?

How to get columns value separated by comma in MS-SQL?

How to auto refresh of web user control in web page in asp.net ?

Difference between PATINDEX and CHARINDEX in SQL SERVER 2008R2?

What is the meaning of httpGetEnabled or httpsgetEnabled is True/False in WCF?

Difference between @html.Partial and @html.RenderPartial in mvc?

How to take a backUp of single table in SQL Server 2008R2?

What is Automatic Activation in WCF?

12.What is the purpose of callback function as an argument of `setState()`?