Selasa, 28 Maret 2017

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

Running Asp.net Core Web Application and Web API project on Ubuntu

Posted: 28 Mar 2017 03:34 AM PDT

Step 1: Install .Net Core on Ubuntu using this link Step 2: On Terminal (Cntrl + Alt + T), go to /home/ directory.  Create dir.  i.e.: mkdir coredemo  If you are new to ubuntu:  /home/ directory is place where it is good to store user specific stuff. Step 3: If you are creating Asp.net Core web application, run command:  dotnet web Asp.net web api, run command:  dotnet api Step 4: dotnet

Efficient way of performing filtering, sorting and pagination with MongoDB C#

Posted: 28 Mar 2017 02:46 AM PDT

Problem: I run into issue where pagination was bringing almost all the rows from the collection and then doing pagination.  In other words it is doing in memory pagination which is inefficient.  Recommendation:  In order to do MongoDB pagination: avoid using LINQ Query. Solution: With following way you can easily and efficiently do filtering, sorting and pagination on mongoDB collection.  Below

Rabu, 01 Maret 2017

ASP.Net, C#, SQL Server Information

ASP.Net, C#, SQL Server Information

Link to ASP.Net, C#, SQL, JQuery, Sharepoint

Getting SQL Server admin access

Posted: 28 Feb 2017 10:22 AM PST

Following commands will provide you admin access for SQL Server instance. Step 1:  Run > Services.msc Step 2: Stop SQL Server (Express) Step 3: sc start mssql$sqlexpress -m -T3659 -T4010 -T4022 Step 4: sqlcmd -S [SQLInstanceName] -E Example: sqlcmd -S ComputerName\sqlexpress -E Step 5: exec SP_ADDSRVROLEMEMBER 'domainname\username', 'sysadmin' go exit Example: exec