public async Task WriteSqlLiteFile() { var ddlResults = await _daosqllite .ExecDDLScriptsForTablesAsync(GetDbItemsTypes()) .ConfigureAwait(false); foreach (var res in ddlResults) { //Logger.Debug(res.Error, $"{(res.Error is null ? "Success:" : "Error:")} {res.Script.ScriptText}"); } Actor[] resultActor = await _dao.GetAllItemsArrayAsync <Actor>(); Film[] resultFilm = await _dao.GetAllItemsArrayAsync <Film>(); Cast[] resultCast = await _dao.GetAllItemsArrayAsync <Cast>(); await _daosqllite.WriteToServerAsync(resultActor); await _daosqllite.WriteToServerAsync(resultFilm); await _daosqllite.WriteToServerAsync(resultCast); }
public async Task WriteSqlServer() { await DropTables(); await CreateTables(); Actor[] resultActor = await _daosqllite.GetAllItemsArrayAsync <Actor>(); Film[] resultFilm = await _daosqllite.GetAllItemsArrayAsync <Film>(); Cast[] resultCast = await _daosqllite.GetAllItemsArrayAsync <Cast>(); await _dao.WriteToServerAsync(resultActor); await _dao.WriteToServerAsync(resultFilm); await _dao.WriteToServerAsync(resultCast); }