Skip to content

DataTables

Chad Jakoby edited this page Jan 12, 2019 · 4 revisions
public UserRepository : Repository
{
	public UserRepository(RepositoryConfig config) : base(config) { }

	// Without parameters:
	public DataTable GetUsers()
	{
		return GetDataTable("SELECT * FROM Users");
	}

	// With parameters:
	public DataTable GetUser(string id, string name, string email)
	{
		AdoParameters parameters = new AdoParameters();
		parameters.Add("@id", id);
		parameters.Add("@name", name);
		parameters.Add("@email", email);

		return GetDataTable(@"SELECT *
				      FROM Users
				      WHERE Id = @id
				        AND Name = @name
				        AND Email = @email", parameters);
	}
}

Clone this wiki locally