public async Task Update(vCardsAlbum album)
{
using (DbConnection db = new SqlConnection(connectionString))
{
string _query = "update vCardsAlboms set album_usid=@album_usid, album_name=@album_name, album_description=@album_description";
await db.ExecuteAsync(_query, album);
}
}
public async Task Create(vCardsAlbum album)
{
using (DbConnection db = new SqlConnection(connectionString))
{
string _query = "insert into vCardsAlbums album_id, album_usid, album_name, album_description values (@album_id, @album_usid, @album_name, @album_description); select cast(scope_identity() as int)";
int? _album_id = (await db.QueryAsync <int>(_query, album)).FirstOrDefault();
album.vCardsAlbum_id = _album_id.Value;
}
}
