1. Manoj
  2. as SQLite DB Server
  3. Monday, January 22 2018, 10:41 AM
  4.  Subscribe via email
I have a desktop application in C# using SQLite.

I normaly use SQLiteConnection to connect to sqlite DB file and SQLiteDataAdapter , SQLiteCommand to fetch data from DB file ....
This is just same with SQL server also.

Now to shift to Valentina SQLite DB Server .... how should I change my connection string.

There are many places .... where SQLiteConnection is used like
SQLiteConnection conn = new SQLiteConnection(ConStr);

** ConStr is defined at just one place in the entire code ...

Question is where and how much code is required to be changed ?

Thanks in advance for support ... ....
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi Manoj,

The answer was sent by email, and now I will repeat it here:

I think you did

1) Installed Valentina Server on your dev machine
2) Installed VNET (x64) – our plugin to C#
3) Optionally but recommended – install Valentina Studio – helps a lot during development

I could not find any help ... can you guide me to proper steps to do ...

1. Changes in connection string ...(I have downloaded VNET.DLL and ADK .... but there is no straightforward example .... )
2. What needs to be installed on the server... AND
3. What needs to be installed on client machines or user machines .... it's a LOCAL network ....

** VNET contains at least one example for SQLite Server:
After installation, check please your Home folder, Paradigma Software / VNET / Examples / VSqlite

** I should say, that our VNET ADK provides our own 3 interfaces/classes to work with SQLite Server:
IVSqliteDatabase IVSqliteStatement IVSqliteCursor

They are very simple and they follow to native API of SQLite in C.

Our classes described in our Valentina WIKI (easy pseudo-code)
roducts:adk:api:api" target="_blank" rel="nofollow">http://valentina-db.com/docs/dokuwiki/v7/doku.php?id=valentina:products:adk:api:api

** Important to notice that our VNET ADK, contains both
- Client to Valentina SQLite Server
- Local SQLite engine (it is inside of VKERNEL.dll)

So using our VNET API, developer can make C# / C++ / PHP / etc application,
which works with both versions of SQLite: local and remote.

But .. right now in VNET you should use our API.

** TODO – I think, we should try to implement in VNET API similar to ADO.NET.
So developers, which already have app code with that API, can switch easy enough, with only connection string…
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 1
  • Page :
  • 1

There are no replies made for this post yet.
However, you are not allowed to reply to this post.


Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories