.Net Archives - Nitesh Kejriwal

22/06/2016 by Nitesh

Solution: Error with Entity Framework – Incorrect syntax near ‘OFFSET’

Friends, This post explains the solution to an issue that occurs with Entity Framework used against SQL Server 2008 database. The error is – An error occurred while executing the command definition. See the inner exception for details. —> System.Data.SqlClient.SqlException: Incorrect syntax near ‘OFFSET’. The error occurs if you are using Entity Framework EDMX file…

12/05/2016 by Nitesh

How To Install Spire.Office On your Machine

In this post we will see how to install Spire.Office software on your machine. Spire.Office for .NET is a combination of Enterprise-Level Office .NET components that includes Spire.Doc, Spire XLS, Spire.Spreadsheet, Spire.Presentation, Spire.PDF, Spire.DataExport, Spire.PDFViewer, Spire.DocViewer and Spire.BarCode. This product enables developers to open, create, modify, convert, print, View Office and PDF documents without the…

02/05/2016 by Nitesh

Managing Word Documents With Spire.Doc Library Functions

Around a year ago, I wrote a post on How To Create a Word Document using Spire.Doc library. A few days back, one of my readers emailed me asking to help with some other functions in the library. Hence, this post is here where I explain various Spire.Doc Library Functions that eases the life of…

30/03/2016 by Nitesh

How To Convert a DateTime object into specific TimeZone in C#

Friends, Many times we store Date in our database by passing DateTime.Now as parameter value or by using GETDATE() in SQL Server. In both the cases, the time of the current machine is passed as the value. It is OK in case of Desktop applications however, when we move to web applications, the current computer…

14/06/2015 by Nitesh

How To Install a Nuget Package In Project

Friends, If you are a Microsoft developer, you must be aware about Nuget. In case you’re not aware, it is the package manager for the Microsoft development platform including .NET. The NuGet Gallery is the central package repository used by all package authors and consumers. In this post, I will show you how can you…