Here we’ll talk about modern ADO.Net with SQLite DB connecting with VB and C# using sample code. Microsoft.Data.Sqlite is a lightweight package for SQLite that runs in.net core environments such as 5/6/7 ADO.net.
Use the following command in the Package Manager Console to install the Microsoft Data. SQLite Package.
1 | Install-Package Microsoft.Data.Sqlite |
SQLite with VB Example code.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | <span class="token keyword keyword-Imports">Imports</span> <span class="token keyword keyword-System">System</span> <span class="token keyword keyword-Imports">Imports</span> Microsoft.<span class="token keyword keyword-Data">Data</span>.Sqlite <span class="token keyword keyword-Module">Module</span> Module1 <span class="token keyword keyword-Sub">Sub</span> Main<span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token keyword keyword-Dim">Dim</span> connectionString <span class="token keyword keyword-As">As</span> <span class="token keyword keyword-String">String</span> <span class="token operator">=</span> <span class="token string">"Data Source=mydatabase.db"</span> <span class="token keyword keyword-Using">Using</span> connection <span class="token keyword keyword-As">As</span> <span class="token keyword keyword-New">New</span> SqliteConnection<span class="token punctuation">(</span>connectionString<span class="token punctuation">)</span> connection.<span class="token keyword keyword-Open">Open</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token comment">' Create a table</span> <span class="token keyword keyword-Dim">Dim</span> createTableQuery <span class="token keyword keyword-As">As</span> <span class="token keyword keyword-String">String</span> <span class="token operator">=</span> <span class="token string">"CREATE TABLE IF NOT EXISTS SampleTable (Id INTEGER PRIMARY KEY, Name TEXT)"</span> <span class="token keyword keyword-Using">Using</span> createCommand <span class="token keyword keyword-As">As</span> <span class="token keyword keyword-New">New</span> SqliteCommand<span class="token punctuation">(</span>createTableQuery<span class="token punctuation">,</span> connection<span class="token punctuation">)</span> createCommand.ExecuteNonQuery<span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token keyword keyword-End">End</span> <span class="token keyword keyword-Using">Using</span> <span class="token comment">' Insert a record</span> <span class="token keyword keyword-Dim">Dim</span> insertQuery <span class="token keyword keyword-As">As</span> <span class="token keyword keyword-String">String</span> <span class="token operator">=</span> <span class="token string">"INSERT INTO SampleTable (Name) VALUES ('John Doe')"</span> <span class="token keyword keyword-Using">Using</span> insertCommand <span class="token keyword keyword-As">As</span> <span class="token keyword keyword-New">New</span> SqliteCommand<span class="token punctuation">(</span>insertQuery<span class="token punctuation">,</span> connection<span class="token punctuation">)</span> insertCommand.ExecuteNonQuery<span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token keyword keyword-End">End</span> <span class="token keyword keyword-Using">Using</span> <span class="token comment">' Read records</span> <span class="token keyword keyword-Dim">Dim</span> selectQuery <span class="token keyword keyword-As">As</span> <span class="token keyword keyword-String">String</span> <span class="token operator">=</span> <span class="token string">"SELECT * FROM SampleTable"</span> <span class="token keyword keyword-Using">Using</span> selectCommand <span class="token keyword keyword-As">As</span> <span class="token keyword keyword-New">New</span> SqliteCommand<span class="token punctuation">(</span>selectQuery<span class="token punctuation">,</span> connection<span class="token punctuation">)</span> <span class="token keyword keyword-Using">Using</span> reader <span class="token keyword keyword-As">As</span> SqliteDataReader <span class="token operator">=</span> selectCommand.ExecuteReader<span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token keyword keyword-While">While</span> reader.<span class="token keyword keyword-Read">Read</span><span class="token punctuation">(</span><span class="token punctuation">)</span> Console.WriteLine<span class="token punctuation">(</span>$<span class="token string">"Id: {reader("</span>Id<span class="token string">")}, Name: {reader("</span><span class="token keyword keyword-Name">Name</span><span class="token string">")}"</span><span class="token punctuation">)</span> <span class="token keyword keyword-End">End</span> <span class="token keyword keyword-While">While</span> <span class="token keyword keyword-End">End</span> <span class="token keyword keyword-Using">Using</span> <span class="token keyword keyword-End">End</span> <span class="token keyword keyword-Using">Using</span> <span class="token keyword keyword-End">End</span> <span class="token keyword keyword-Using">Using</span> <span class="token keyword keyword-End">End</span> <span class="token keyword keyword-Sub">Sub</span> <span class="token keyword keyword-End">End</span> <span class="token keyword keyword-Module">Module</span> |
SQLite DB with c# example.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | <span class="token keyword keyword-using">using</span> <span class="token namespace">System</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token namespace">Microsoft<span class="token punctuation">.</span>Data<span class="token punctuation">.</span>Sqlite</span><span class="token punctuation">;</span> <span class="token keyword keyword-class">class</span> <span class="token class-name">Program</span> <span class="token punctuation">{</span> <span class="token keyword keyword-static">static</span> <span class="token return-type class-name"><span class="token keyword keyword-void">void</span></span> <span class="token function">Main</span><span class="token punctuation">(</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token class-name"><span class="token keyword keyword-string">string</span></span> connectionString <span class="token operator">=</span> <span class="token string">"Data Source=mydatabase.db"</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> connection <span class="token operator">=</span> <span class="token keyword keyword-new">new</span> <span class="token constructor-invocation class-name">SqliteConnection</span><span class="token punctuation">(</span>connectionString<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> connection<span class="token punctuation">.</span><span class="token function">Open</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token comment">// Create table query</span> <span class="token class-name"><span class="token keyword keyword-string">string</span></span> createTableQuery <span class="token operator">=</span> <span class="token string">"CREATE TABLE IF NOT EXISTS SampleTable (Id INTEGER PRIMARY KEY, Name TEXT)"</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> createCommand <span class="token operator">=</span> <span class="token keyword keyword-new">new</span> <span class="token constructor-invocation class-name">SqliteCommand</span><span class="token punctuation">(</span>createTableQuery<span class="token punctuation">,</span> connection<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> createCommand<span class="token punctuation">.</span><span class="token function">ExecuteNonQuery</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token comment">// Insert data query</span> <span class="token class-name"><span class="token keyword keyword-string">string</span></span> insertQuery <span class="token operator">=</span> <span class="token string">"INSERT INTO SampleTable (Name) VALUES ('John Doe')"</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> insertCommand <span class="token operator">=</span> <span class="token keyword keyword-new">new</span> <span class="token constructor-invocation class-name">SqliteCommand</span><span class="token punctuation">(</span>insertQuery<span class="token punctuation">,</span> connection<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> insertCommand<span class="token punctuation">.</span><span class="token function">ExecuteNonQuery</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token comment">// Select data query</span> <span class="token class-name"><span class="token keyword keyword-string">string</span></span> selectQuery <span class="token operator">=</span> <span class="token string">"SELECT * FROM SampleTable"</span><span class="token punctuation">;</span> <span class="token keyword keyword-using">using</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> selectCommand <span class="token operator">=</span> <span class="token keyword keyword-new">new</span> <span class="token constructor-invocation class-name">SqliteCommand</span><span class="token punctuation">(</span>selectQuery<span class="token punctuation">,</span> connection<span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token keyword keyword-using">using</span> <span class="token punctuation">(</span><span class="token class-name"><span class="token keyword keyword-var">var</span></span> reader <span class="token operator">=</span> selectCommand<span class="token punctuation">.</span><span class="token function">ExecuteReader</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> <span class="token keyword keyword-while">while</span> <span class="token punctuation">(</span>reader<span class="token punctuation">.</span><span class="token function">Read</span><span class="token punctuation">(</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">{</span> Console<span class="token punctuation">.</span><span class="token function">WriteLine</span><span class="token punctuation">(</span><span class="token interpolation-string"><span class="token string">$"Id: </span><span class="token interpolation"><span class="token punctuation">{</span><span class="token expression language-csharp">reader<span class="token punctuation">[</span><span class="token string">"Id"</span><span class="token punctuation">]</span></span><span class="token punctuation">}</span></span><span class="token string">, Name: </span><span class="token interpolation"><span class="token punctuation">{</span><span class="token expression language-csharp">reader<span class="token punctuation">[</span><span class="token string">"Name"</span><span class="token punctuation">]</span></span><span class="token punctuation">}</span></span><span class="token string">"</span></span><span class="token punctuation">)</span><span class="token punctuation">;</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span> <span class="token punctuation">}</span> |
Output
ASP.NET 8.0.11 Hosting Recommendation
ASP.NET is a powerful platform for creating web applications and services. You must be comfortable with JavaScript, HTML, CSS, and C# before developing a web application in ASP.NET. On the market, there are thousands of web hosting companies providing ASP.NET Hosting. But, only very few web hosting companies could provide high quality ASP.NET hosting solution.
ASP.NET is the best development language in Windows platform, which is released by Microsoft and widely used to build all types of dynamic Web sites and XML Web services. With this article, we’re going to help you to find the best ASP.NET Hosting solution in Europe based on reliability, features, price, performance and technical support. After we reviewed about 30+ ASP.NET hosting providers in Europe, our Best ASP.NET Hosting Award in Europe goes to HostForLIFE.eu, one of the fastest growing private companies and one of the most reliable hosting providers in Europe.