Resume creator

 https://enhancv.com/resume-examples/senior-software-engineer/

azure logs

 Azure Links

sonata interview questions

 1.virtual and abstract class difference?

2.static and interface ,override,overload,

3.what is web api?

4.different type of authentication?

5.primary key unique key difference?

6.indexer?

7.di in core?

8.filter array duplicates?

9.function,view dif

10.angular decorators annotation?

11.angular js angular difference?

12.final and dispose?

13.

c# split and get last list read txt file line by line

 After spliting we get last item in c#

string lastName = "Abraham Lincoln".Split().Last();

namespace New
{
    class Program
    {
        static void Main(string[] args)
        {
           
                string line;

            int counter = 0;
            System.IO.StreamReader file = new System.IO.StreamReader(@"F:\test111.txt");
                while ((line = file.ReadLine()) != null)
                {
                var data = line.Split(';').Last();
                Console.WriteLine(data);
                var parts = data.Split('^');

                Console.WriteLine("Id :-" + parts[0]);
                Console.WriteLine("Delivery Code :-" + parts[1]);

                counter++;
                }

                file.Close();
                System.Console.WriteLine("There were {0} lines.", counter);

                System.Console.ReadLine();
            }
    }
}

C# interview qstns

 check this links of interview questions

https://www.youtube.com/watch?v=VCcXcwsH9G4

c#

solid Principles Solid Principles

solid principles example SOLID

sql remove not existing ids in table one

How to Delete Rows That do not Exist in Another Table

 select a.orderid from web.orderHeader a

 WHERE web.orderHeader.orderid NOT IN (SELECT f.orderid 

                        FROM web.orderdetail f)

Using NOT IN:

DELETE FROM orderHeader
 WHERE orderid NOT IN (SELECT f.orderid 
                        FROM orderdetail f)

Using NOT EXISTS:

DELETE FROM orderHeader
 WHERE NOT EXISTS(SELECT NULL
                    FROM orderdetail f
                   WHERE f.id = fileid)

azure Blob Storage upload video

 

1.issue is the azure upload file container is like below

2.

2. upload code to azure blob storage we need to put we need follow the above screen shot 

and then we can access the blob storage  using above we need to create token and update it accordingly

in angular then we can upload it azure blob storage without backene

here is the angular code Link