All Questions
10 questions
0
votes
0
answers
21
views
Keep application-specific fields synced with database
I have a GameConsole model :
public class GameConsole
{
public int ID { get; protected set; } = 0;
public string Identifier { get; protected set; } = "GameConsole";
public ...
0
votes
1
answer
268
views
SQLite attendance date records table structure | delete where | primary key
I have a Xamarin.Forms app I'm building with a SQLite database. I want to keep records of students' attendance. I wanted to make an attendance table with just 2 columns:
public class Attendance
{
...
- 3,830
-1
votes
1
answer
1k
views
Data deleting logically from table but still sqlite db file size same
I am using sqlite database.
I created fresh database and I performed bulk insert of 20K rows in a transaction and then commited the transaction.
Later I perormed delete query
delete from Table
After ...
- 447
0
votes
2
answers
523
views
InsertWithChildrenAsync() and duplicate primary keys
I get a list of objects from a webservice. The data should be stored in a SQLite database. Thereby I can store the first item in the database with InsertWithChildrenAsync(), on the second I get an ...
- 20.3k
-2
votes
2
answers
695
views
Should I create separate tables for each category?
So, I have recently been tasked with transferring an old Flat File System Scheduling system into a SQL Database using C#.
The main issue I am finding is the fact that the tasks (See snippet below) ...
- 9
0
votes
0
answers
66
views
Hide queries without ORM
So I have an application where I need to save data to database, but the data structure is based on user. Basically user inserts a .csv or .txt file to my application and it generates table with data ...
- 3,935
0
votes
0
answers
111
views
How do I setup a Sqlite3 Model Class Generation class for use in Unity 5+ Using C#
TLDR Short and Sweet
I want to generate Sqlite Database Model Classes Programmatically or Infer them using C# for the use of a Database system in Unity.
Overview & Full Explanation
So First off ...
- 17
1
vote
2
answers
1k
views
SQLite3 -- storing variable size arraylists in C#
I've never attempted to store any objects in my SQLite database and doing some searching on the subject didn't help. I'm using VS 2012, the NuGet SQLite DLLs, and C# with .NET 4.5.
Here are the ...
- 2,301
4
votes
3
answers
2k
views
ConstraintException when querying SQlite database with C#
I’m hoping somebody will be able to help with my SQLite database problem.
I’m receiving a ConstraintException when querying my SQLite database with C#. The full exception message is “Failed to ...
- 571
8
votes
4
answers
6k
views
C# Application - storing of preferences in database or config file?
I have an application that uses SQLite, which is extremely light weight and quick. I have some preferences that don't necessarily need to be loaded on startup, but might need to be used at various ...
- 515