Asp.Net Identity SQLite Provider on Empty Web Forms project

  Previously, I installed the Asp.Net Identity SQLite on a non-empty Web Form Project. This time, I'll try installing it on an Empty Web Form project so I can minimize the Nuget packages installed and I can learn which Nuget packages it depends on.


Firstly, I create a ASP.NET Empty Web Site targeting .Net Framework 4.7.1

Then on Nuget Package Manager for Solution, Uninstall all the Nuget Packages. This will make it truely empty Web Form project.

Asp.Net Identity SQLite Provider on a Web Forms project

  Mostly, the tutorial or sample I found from googling was for MVC and C#. So I decided to install the Asp.Net.Identity.SQLite by following the guide from MVC then modify it to work for Web Forms then convert it to VB.

I'm using Visual Studio 2017.

Create a new ASP.NET Web Forms Site project, targeting .Net Framework 4.7.1

Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found

Happens when installing nuget package System.Data.SQLite.Core.

Easy solution on my part:

1. Copy the 'SQLite.Interop.dll' from the "packages\System.Data.SQLite.Core.1.0.106.0\build\net45\x86\SQLite.Interop.dll"
2. Paste it into the 'Bin' folder

I am using Visual Studio 2017, Webform project targeting .net 4.5

Attempt Compiling LESS into CSS with Visual Studio 2015 via Web Compiler.

So far, I only write CSS for my website presentation. But I heard that VS2015 can compile LESS to CSS and minify it. But I heard wrong. The feature is never in VS2015 but in the previous version that is in the VS2013. That is disappointing.

So I try searching for any extension on the net. Bumped to this in the VisualStudioGallery called Web Compiler. I decided to download and install it.

Then I just have to right-click on the LESS file (in Solution Explorer) and choose compile (right?).

OLEDB error. "Operation must use an updatable query."

At one time I published a web project that used OLEDB to connect to Ms Access and update some data I got an error "Operation must use an updatable query."

Some googling reached me on this site: “Operation must use an updateable query” error in MS Access

The chosen as answer doesn't really solve my problem. but the second answer really solve it.

The Answer:

There is no error in the code, but the error is thrown due to the following:

 - Please check whether you have given Read-write permission to MS-Access database file.
 - The Database file where it is stored (say in Folder1) is read-only..? 

suppose you are stored the database (MS-Access file) in read only folder, while running your application the connection is not force-fully opened. Hence change the file permission / its containing folder permission like in C:\Program files all most all c drive files been set read-only so changing this permission solves this Problem.

So I change the permission on my folder (App_Data) that stored my Ms Access database to full control.

Problem solved.