I have a problem with dbcontext.users.dadd

0

I am making a discord bot and i am writing a function to save jobs but it doesn't get further than var add new jobs..

   public static async Task SaveJobs(string nosaukums, string apraksts, string statuss)
    {
        using (var DBcontext = new SQLiteDBcontext())
        {
            var add = new Jobs
            {
                Apraksts = apraksts,
                Notikums = nosaukums,
                Statuss = statuss,
                Darbinieki = ""
            };

            DBcontext.Jobs.Add(add);
            await DBcontext.SaveChangesAsync();
        }

    }

Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 1: 'no such table: Users'. at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteCommand.PrepareAndEnumerateStatements(Stopwatch timer)+MoveNext() at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider._TrackEntities[TOut,TIn](IEnumerable1 results, QueryContext queryContext, IList1 entityTrackingInfos, IList1 entityAccessors)+MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext() at System.Collections.Generic.List1.AddEnumerable(IEnumerable1 enumerable) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at botLAPD.Core.Data.Data.SaveUser(UInt64 IDofUser) in C:\Users\LIAR\source\repos\botLAPD\botLAPD\Core\Data\Data.cs:line 18

try
                {
**LINE 18**        var check = DBcontext.Users.Where(x => x.IDuser == IDofUser).ToList();
                    if (check == null)
                    {
                        Console.WriteLine("33333333333333333333333333333333333333333333333");
                        DBcontext.Users.Add(new Users
                        {
                            IDuser = IDofUser,
                            Apraksts = " ",
                            Notikums = " ",
                            Statuss = " "
                        });
                        Console.WriteLine("awdawdawdaw3e12415124123123123123123123123");
                    }
                    else
                    {
                        Users Current = DBcontext.Users.Where(x => x.IDuser == IDofUser).FirstOrDefault();
                        DBcontext.Users.Update(Current);
                        Console.WriteLine("BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB");
                    }
                    await DBcontext.SaveChangesAsync();
                    Console.WriteLine("BEIGAS");
                }
                catch(Exception ex)
                {
                    Console.WriteLine(ex);
                Console.WriteLine("BEIGAS");
                }
c#
sqlite
discord.net
asked on Stack Overflow May 19, 2019 by LIAR • edited May 19, 2019 by LIAR

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0