VIBE CODED

The following is a living list of information about the various metadata files associated with Visual Studio.NET and ClearCase. Folder Hierarchy The Visual Studio.NET (VS.NET) and ClearCase metadata exist in a simple hierarchy of folders. The first folder is the Solution folder and is named after the VS.NET Solution. The Solution folder contains one *.SLN file (see below), at least one *.SUO file (see below), and zero or more VS.NET Project folders. Project folders are named after their VS.NET Projects. The contents of the Project folders vary, but they always contain one *.CSPROJ file (see below) per Project folder, and a *.WEBINFO file (see below) if the Project is a web (ASP.NET) project. SLN (Solution File) The VS.NET Solution metadata is stored in the *.sln file. The Solution and all the Projects associated with it can be opened within VS.NET by opening the *.sln file. It is a text file and can be edited. It is version controlled. CSPROJ (Project File) The metadata file associate...

OVER OVER allows you to get aggregate information without using a GROUP BY. In other words, you can retrieve detail rows, and get aggregate data alongside it. For example, this query: SELECT SUM(Cost) OVER () AS Cost , OrderNum FROM Orders Will return something like this: Cost  OrderNum 10.00 345 10.00 346 10.00 347 10.00 348 Quick translation: SUM(cost) – get me the sum of the COST column OVER – for the set of rows…. () – …that encompasses the entire result set. OVER(PARTITION BY) OVER, as used in our previous example, exposes the entire resultset to the aggregation…”Cost” was the sum of all [Cost]  in the resultset.  We can  break up  that resultset into partitions with the use of PARTITION BY: SELECT SUM(Cost) OVER (PARTITION BY CustomerNo) AS Cost , OrderNum , CustomerNo FROM Orders My partition is by  CustomerNo  – each “window” of a single customer’s orders will be treated separately from each other “window...

In SQL NULL plus anything equals NULL Ex: SELECT MyColumn + 100 In the above case if mycolumn is null then the result is NULL Alternate solutions SELECT          CASE WHEN MyColumn IS NULL                      THEN 0                ELSE MyColumn END  FROM MyTable SELECT ISNULL(mycolumn, 0)  + 100 FROM MyTable

Before that you have to enable the IIS for windows by start Control panel programs Turn windows feature on / off Check the IIS services (4th and 5th checkbox) ok restart the system

Create XML from Database Suppose we have below table in database. Now I want to make xml of all the products which have stock greater than 0. Here I am using  LINQ Pad  to query data from the database. It is a great tool to query data from database using LINQ to SQL, LINQ to XML, LINQ to Entity Framework. CREATE TABLE Product ( ProductID int IDENTITY ( 1 , 1 ) NOT NULL , ProductName varchar ( 50 ) NOT NULL , Price float NOT NULL , Stock int NOT NULL ) GO INSERT INTO Product ( ProductName , Price , Stock ) VALUES ( 'P001' , 12.12 , 100 ) INSERT INTO Product ( ProductName , Price , Stock ) VALUES ( 'P002' , 102.12 , 200 ) INSERT INTO Product ( ProductName , Price , Stock ) VALUES ( 'P003' , 104.12 , 500 ) INSERT INTO Product ( ProductName , Price , Stock ) VALUES ( 'P004' , 108.12 , 100 ) INSERT INTO Product ( ProductName , Price , Stock ) VALUES ( 'P005' , 72.12 , 10 ) INSERT INTO Product ( ProductName , ...

Var VS IEnumerable In previous article I explain the difference between  IEnumerable and IQuerable ,  IEnumerable and IList . In this article I expose the difference between Var and IEnumerable. IEnumerable is an interface that can move forward only over a collection, it can’t move backward and between the items. Var is used to declare implicitly typed local variable means it tells the compiler to figure out the type of the variable at compilation time. A var variable must be initialized at the time of declaration. Both have its own importance to query data and data manipulation. Var Type Since  Var  is anonymous types, hence use it whenever you don't know the type of output or it is anonymous. Suppose you are joining two tables and retrieving data from both the tables then the result will be an Anonymous type. var q =( from e in tblEmployee join d in tblDept on e . DeptID equals d . DeptID select new { e . EmpID , e . FirstName , d . Dept...

https://adblockplus.org/en/chrome