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, IReadOnlyDictionary
2 parameterValues)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable
1.Enumerator.MoveNext()
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider._TrackEntities[TOut,TIn](IEnumerable1 results, QueryContext queryContext, IList
1 entityTrackingInfos, IList1 entityAccessors)+MoveNext()
at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor
1.EnumeratorExceptionInterceptor.MoveNext()
at System.Collections.Generic.List1.AddEnumerable(IEnumerable
1 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");
}
User contributions licensed under CC BY-SA 3.0