W
W
WasTabon2021-06-22 14:00:34
SQLite
WasTabon, 2021-06-22 14:00:34

Where can I find the created DB in SQLite Visual Studio?

using System;
using System.Data;
using Microsoft.Data.Sqlite;
using Telegram;
using Telegram.Bot;
using Telegram.Bot.Args;
using Telegram.Bot.Types;
using Telegram.Bot.Types.Enums;
using Telegram.Bot.Types.ReplyMarkups;


namespace TelegramSQLBotv2
{
    class Program
    {
        static SqliteConnection connection = new SqliteConnection("Data Source=usersdata.db");
        static TelegramBotClient client = new TelegramBotClient("");
        static void Main(string[] args)
        {
            if (msg.Text == "/123")
            {
                connection.Open();
                SqliteCommand command = new SqliteCommand();
                command.Connection = connection;
                command.CommandText = "CREATE TABLE  MainDataBase(_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, User TEXT NULL)";
                command.ExecuteNonQuery();
                Console.WriteLine("Таблица MainDataBase создана");
            }
        }
}

It is being created, but I can’t find it in any way. I
60d1c2cb740d3168937370.png
use this software.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vorfall, 2021-06-22
@Vorfall

if you do it in visual studio, then on the left there is a database browser
, all the databases to which the project was connected to appear there

W
WasTabon, 2021-06-22
@WasTabon

bin\Debug\netcoreapp3.1
Here is the path where this database is created

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question