Local Method Calls inside a Linq query - C#

Feb 20, 2019 BY xtreme

LINQLanguage INtegrated Queries are SQL-like C# queries that can be used to manipulate collections of objects. You can call user-defined functions inline. functions that are included in a query whose execution is deferred are not executed until the query is executed.public async Task&...

List All Tables, Views - Sql Server

Feb 20, 2019 BY xtreme

list all tables All Tables In Sql 2000SELECT NAME FROM sysobjects WHERE xtype='U' All Tables In Sql 2005 and above SELECT TABLE_NAME FROM .INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'list all viewsAll Views In Sql 2000 SELECT NAME FROM sysobjects WHERE xtype='V' All Views I...

Nuget Npm Dependencies missing - DotNet Core

Feb 20, 2019 BY xtreme

NPM DependenciesIn Visual Studio, Make sure Node.js path is set. Right click on npm node in solution explorer > configure External Tools.  By default Node.js is located at C:\Program Files\nodejs\ or C:\Program Files (x86)\nodejs\ Or other Driver where OS is installed.After ad...

Tab n MultiView Control In Asp.Net

Feb 19, 2019 BY xtreme

INTRODUCED IN ASP.NET 2.0The New MultiView control works in tandem with an embedded View Control. Each View Control acts as a content container and behaves very much like a Panel or Canvas Area. At run time, the MultiView control manages the view controls to ensure only one View is visible at a time...

Dynamic Charts In ASP.NET MVC RAZOR - Chart Helper AND Linq

Feb 18, 2019 BY xtreme

INTRODUCTIONYou can easily create Charts from database using Charts Helper class in ASP.NET MVC Razor. System.Web.Helpers namespace supports a rich set of chart options and methods including bar, line, pie, doughnut, funnel, area and more..You can easily install System.Web.Helpers&nbs...

Drop all tables n stored procedure in Sql Server

Feb 18, 2019 BY xtreme

Can Remove all Tables and Store Procedure for a Database at once. Drop all user defined tables EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"Drop all user defined Stored ProceduresDeclare @pName varchar(500) Declare sqlcur Cursor For Select [name] From sys.objects where type = 'p' Open sqlcu...