Posts

Showing posts with the label sqllite

Xamarin Form - SqLite

Copy Below Code: Please watch video  to understand code. public class SqlHelper { public static string Username { get; set; } public static string Email { get; set; } public static string Language { get; set; } public static int CompanyID { get; set; } readonly SQLiteAsyncConnection database; public static string root = string.Empty; public SqlHelper() { var location = "demoDB.db2"; location = System.IO.Path.Combine(root, location); database = new SQLiteAsyncConnection(location); database.CreateTableAsync<tblCredentials>().Wait(); } public Task<int> InsertCredential(tblCredentials tbl) => database.InsertAsync(tbl); public Task<int> insert(tblCredentials tbl) { return database.InsertAsync(tbl); } public Task<int> UpdateCredential(List<tblCredentials> tbl) => data