System.Data.SQLite | A lightweight ADO.NET wrapper around SQLite | Database library

My code is working properly except when I try to Retrieve float/reel number from database , it return only the integer part as the screenshots shows. the value in the database is 145.55 but the textbox show 145 only.

*I tried with MessageBox to make sure the problem is not in the textbox but in the value returned by the sql query.

iteminformation.cs

I set my program to launch at startup by the below code:

I want to create my own custom package for System.Data.SQLite. I have the all the dll's I need but I'm unsure how to structure it and create the nuspec for it. Current folder structure of the dll's is this, whereabouts would I put the different interop dlls to have them copied correctly to the output and what do I need to add to the nuspec?

I am creating a writable application database in \AppData\Roaming\ProjectName to keep authorization and cache.

1. So firstly, i have database.db in my project that i will copy to AppData, when App is started for the first time. But i have no idea how write a Connection string in App.Config that case. Now it is:

   ...

I am pretty new to coding with C# and SQlite, and this is my first post on Stack Overflow, so any advise would be appreciate.

I have created a Winforms database app to track assessment scores. Everything works great when I run it from inside Visual Studio or from the .exe in the debug folder.

A sample of my code for the SQLite connection is below

I'm trying to insert this string 2021-02-22T16:11 into sqlite database. I use VARCHAR(20) to store this this string. When I execute sql query from SQLite studio everything is fine. But when I run the same code from my ASP Net Core app, it throws an error:

code = Error (1), message = System.Data.SQLite.SQLiteException (0x800007BF): SQL logic error unrecognized token: "22T16"

I've tried different data types for this column (TEXT, STRING, DATETIME), but nothing works. Can't understand why it can't insert string even into VARCHAR column.

The function that invokes insert query:

For Some reason my code does not recognize the attributes. Like it does in Xamarin when creating a C# SQlite Database class.

There is an application that uses SQLite. Link to System.Data.SQLite and SQLite.Interop.dll (for x64 and x86 platforms) added statically, version 1.0.112.0. (all 3 files) (SQLite was added to the test project via NuGet, and from there copied to the current project). The System.Data.SQLite and SQLite.Interop.dll files (in the x86 and x64 folders) are present on the client machine. .Net version is 4.7.2.

Most clients work fine, but a few throw an exception with the text "Unable to load DLL 'SQLite.Interop.dll'". I build test versions for x86 and x64 on my machine, in each case SQLite.Interop.dll was loaded from the corresponding folder (If SQLite.Interop.dll does not exist on the corresponding path, then there was an exception).

Where to look to avoid this exception on all client machines?

There is a hunch that the client is missing Microsoft Visual C ++ Redistributable. But later I find out that Redistributable was installed.

The next assumption is that the system can find SQLite.Interop.dll, but an error occurs during loading or initialization, which is interpreted by the wrapper(System.Data.SQLite) as DllNotFoundException.

I'm trying to create SQLite table using System.Data.SQLite library under .NET Framework 4.7.2 with statement