Programming/Use SQLite in Csharp - Revision history

Administrator: /* Using Appsettings.json */

2026-03-03T13:34:33Z

Using Appsettings.json

← Older revision		Revision as of 13:34, 3 March 2026
Line 60:		Line 60:
	var connectionString = builder.Configuration.GetConnectionString("DefaultConnection");		var connectionString = builder.Configuration.GetConnectionString("DefaultConnection");
	builder.Services.AddDbContext<DatabaseContext>(options => options.UseSqlite(connectionString));		builder.Services.AddDbContext<DatabaseContext>(options => options.UseSqlite(connectionString));
	<syntaxhighlight>		</syntaxhighlight>

	== Example usage ==		== Example usage ==

2026-03-03T13:34:17Z

← Older revision		Revision as of 13:34, 3 March 2026
Line 47:		Line 47:

	=== Using Appsettings.json ===		=== Using Appsettings.json ===
	Another method is to use <code>Appsettings.json<code>.		Another method is to use <code>Appsettings.json</code>.

	<syntaxhighlight lang="json">		<syntaxhighlight lang="json">
Line 55:		Line 55:
	</syntaxhighlight>		</syntaxhighlight>

	Then in your <code>Proram.cs<code> add the following for DI.		Then in your <code>Proram.cs</code> add the following for DI.

	<syntaxhighlight lang="csharp">		<syntaxhighlight lang="csharp">

2026-03-03T13:33:53Z

Use in C#

@@ Line 44: / Line 44: @@
 builder.Services.AddDbContext<DBContext >(options => options.UseSqlite())
 </syntaxhighlight>
 == Example usage ==

2026-02-27T11:13:19Z

← Older revision		Revision as of 11:13, 27 February 2026
Line 42:		Line 42:

	<syntaxhighlight lang="csharp">		<syntaxhighlight lang="csharp">
	builder.Services.AddDbContext<~~BloggingContext~~>(options => options.UseSqlite(~~connectionString~~))		builder.Services.AddDbContext<DBContext >(options => options.UseSqlite())
	</syntaxhighlight>		</syntaxhighlight>

2026-02-26T11:21:23Z

← Older revision	Revision as of 11:21, 26 February 2026
(No difference)

2026-02-26T11:20:56Z

2026-02-26T11:18:50Z

← Older revision	Revision as of 11:18, 26 February 2026
(No difference)

2026-02-17T23:45:47Z

Use in C#

← Older revision		Revision as of 23:45, 17 February 2026
Line 28:		Line 28:
	{		{
	// Use SQLite + file path		// Use SQLite + file path
	optionsBuilder.UseSqlite(@"Data Source=~~C:\Users\agh\Documents\SQLite\thehuman~~.db");		optionsBuilder.UseSqlite(@"Data Source=MyDdatabase.db");
	}		}
	}		}

2026-02-17T23:45:22Z

Use in C#

← Older revision		Revision as of 23:45, 17 February 2026
Line 9:		Line 9:
	</syntaxhighlight>		</syntaxhighlight>

	Create a ''DBContext'' class~~, such as the one below~~.		Create a ''DBContext'' class.

	<syntaxhighlight lang="csharp">		<syntaxhighlight lang="csharp">
			using Microsoft.EntityFrameworkCore; // EF Core namespace

			namespace SQLiteExampleTest
			{
	public class DBContext : DbContext // Custom EF Core context		public class DBContext : DbContext // Custom EF Core context
	{		{
Line 24:		Line 28:
	{		{
	// Use SQLite + file path		// Use SQLite + file path
	optionsBuilder.UseSqlite(@"Data Source=~~People~~.db");		optionsBuilder.UseSqlite(@"Data Source=C:\Users\agh\Documents\SQLite\thehuman.db");
	}		}
	}		}
			}
	</syntaxhighlight>		</syntaxhighlight>

2026-02-17T23:12:36Z

← Older revision	Revision as of 23:12, 17 February 2026
(No difference)