Skip to main content

Posts

Azure Service Bus Vs Azure Web Job

MENU Home SUBSCRIBE Today, we will be talking about Azure service bus and how to use them with Webjobs. Azure Service Bus  is a messaging infrastructure that sits between applications allowing them to exchange messages for improved scale and resiliency. It offers the following capabilities: Queues: offers simple first in, first out guaranteed message delivery. When to use Azure Service Bus? Service Bus queues are a general-purpose technology that can be used for a wide variety of scenarios: Communication between web and worker roles in a multi-tier Azure application Communication between on-premises apps and Azure hosted apps in a hybrid solution Communication between components of a distributed application running on-premises in different organizations or departments of an organization There are also Topics and Relay capabiliteis but we will talk about them in the future. A figure that illustrates how Azure Service Bus works. There is a sender who send a mes...
Post a Comment
Read more
Recent posts

Store Data in to Micro-Services Static class using c# dot net core (Key Based API for Reduce Database hit)

Find Code From Here :  Code Testing : 1. 1st Time Entry with Null key value and Adding New Value into Class Testing : 2 . 2nd Time Entry with unique key value and updating existing entry into Class Testing : 3. Same Time Another Hit Came From different User for for update Data  Testing 4: If Step is 4 then we are inserting data into our database and Deleting data from class using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; // For more information on enabling Web API for empty projects, visit https://go.microsoft.com/fwlink/?LinkID=397860 namespace AppForStaticCls.Controllers {     [Route("api/[controller]")]     public class MutiplePostController : Controller     {         // GET: api/<controller>         [HttpGet]         public IEnumerab...
Post a Comment
Read more

SQL Large File Execution from CMD

sqlcmd -s DatabaseServerName -i FilePath
Post a Comment
Read more

Convert Nested XML to C# class object and C# Class object to Nested XML File

Convert Nested XML to C# class object and C# Class object to Nested XML File Download Project Introduction In this Article we learn how to deserialize XML to C# objects and reverse from C# objects to XML files. In this article we will do practical with example with demo class and xml files. using System; using System.Collections; using System.IO; using System.Xml.Serialization; namespace TestApp {     public class Serializer     {              public T Deserialize<T>(string input) where T : class         {             System.Xml.Serialization.XmlSerializer ser = new System.Xml.Serialization.XmlSerializer(typeof(T));             using (StringReader sr = new StringReader(input))             {                 return (T)ser.Deserialize(sr);  ...
Post a Comment
Read more

Difference between Table scan,index scan and index seek

Dear Readers, In this Article i am going to introduce "What is the difference between TABLE SCAN , INDEX SCAN and INDEX SEEK". Table Scan:  These all are related to Optimization technique in SQL Server. When we are fetching data from table, By default we are scanning whole table to get our particular data. This is called Table Scan. Ex : Select * From Employee  Index Scan :   Now we are creating index For Employee Table on there id . Ex :  CREATE INDEX index_employee_id ON Employee(id); Now we will run same Query "Select * from Employee", In this case we will scan only Index. So it is called Index Scan. Index Seek : In this case after creating Index we are executing "Select * from employee where id=1". Means we are fetching data with Id. As we are created index on Employee table by there id . So it is called Index Seek.
Post a Comment
Read more

Sql Server BCP(Bulk Copy Process) for Save file in csv format through stored procedure

Hi Techies,            Today i am going to provide you a solutions for copy data from database and save that data in csv or any type of format in same or another location.  So, For this type of work i used to BCP ( Bulk copy process ) using " xp_cmdshell " command in sql server.  For this process we need Admin rights on SQL Server and  xp_cmdshell access rights.  After taking rights we have to write bellow query in stored procedure.  -------------------------------------------------------------------------------------------------------------- --EXEC ExportTest Create Proc ExportTest AS BEGIN         declare @cmd varchar(1000)     set @cmd ='bcp "SELECT * FROM databasename.[dbo].[tablename]" queryout "C:\\FileTest\test.csv" -c -t ,  -S 10.XXXXXXXX -U username-P Password-T'    exec xp_cmdshell @cmd END -----------------------------------------------...
Post a Comment
Read more

Angular Step By Step Installation Process

# Angular Step By Step  Hello Techies,        In this post i am going to guide you to install Angular and create and run your first app. Please follow bellow steps.. Step 1 (Node NPM Installation) Node Js ( NPM)  should be installed on system. So for installation of Node Js follow bellow steps. Open  https://nodejs.org/en  .  Download stable Version (LTS) of Node js. After complete the installation open CMD and check the version. Step : 2 (Install Angular by NPM) Type " npm install -g @angular/cli "  2.  Select folder where you are going to create Angular Project.  3. Type ng new 'your app-name' EX:  ng new my-dream-app And Relax it will take some couple of minute to create app , because its downloading all the package from server by npm in you local system. Type : " cd my-dream-app " to select project which is created.  Now Type " ng serve " to run the project...
Read more