{"id":5010,"date":"2021-02-01T10:12:34","date_gmt":"2021-02-01T10:12:34","guid":{"rendered":"https:\/\/serkanseker.com\/?p=5010"},"modified":"2021-02-01T10:12:34","modified_gmt":"2021-02-01T10:12:34","slug":"xamarin-forms-sqlite-kullanimi","status":"publish","type":"post","link":"https:\/\/serkanseker.com\/tr\/xamarin-forms-sqlite-kullanimi\/","title":{"rendered":"Xamarin.Forms\u2019da SQLite Kullan\u0131m\u0131 | DependencyService"},"content":{"rendered":"
\n

Bu yaz\u0131mda Xamarin.Forms ile daha \u00f6nceden geli\u015ftirdi\u011fim Hava Durumu<\/a> uygulamas\u0131na SQLite ile yerel veritaban\u0131 ekleyece\u011fim.<\/p>\n

1) Xamarin.Forms projenize SQLite eklentisini y\u00fckleyin<\/span><\/h2>\n

\u00d6ncelikle, Xamarin.Forms projenizde SQLite ile bir veritaban\u0131 olu\u015fturabilmek i\u00e7in sqlite-net-pcl<\/a> eklentisini y\u00fcklemelisiniz.<\/p>\n

Paket Y\u00f6neticisi Konsolunda a\u015fa\u011f\u0131daki kodu \u00e7al\u0131\u015ft\u0131rarak eklentiyi y\u00fckleyebilirsiniz. (bkz. Paket Y\u00f6neticisi Konsolu ile NuGet Paketlerini Y\u00fckleme<\/a><\/strong>)<\/p>\n

Install-Package sqlite-net-pcl -Version 1.8.0-beta<\/code><\/pre>\n
Alternatif olarak,\u00a0eklentiyi NuGet Paket Y\u00f6neticisinden de y\u00fckleyebilirsiniz. (bkz. <\/strong><\/a>NuGet Paket Y\u00f6neticisi \u0130le NuGet Paketlerini Y\u00fckleme<\/a><\/strong><\/strong>)<\/p>\n
\n
\"Xamarin
NuGet Paket Y\u00f6neticisi ile SQLite eklentisini y\u00fckleyin<\/figcaption><\/figure>\n<\/div>\n
2) IDatabase interface\u2019si ekleyin<\/span><\/h2>\n
MVVM modelinde<\/a> Data klas\u00f6r\u00fcnde, veritaban\u0131 i\u015flemlerinin yap\u0131laca\u011f\u0131 s\u0131n\u0131flar ve interface\u2019ler yer al\u0131r.<\/p>\n
Projeye Data <\/strong>adl\u0131 bir klas\u00f6r ekleyin ve bu klas\u00f6re IDatabase.cs <\/strong>adl\u0131 bir interface ekleyin. <\/p>\n
IDatabase interface\u2019sinde GetConnection() ad\u0131nda bir method tan\u0131mlay\u0131n. Android yerel platformunda bir veritaban\u0131 ba\u011flant\u0131s\u0131 olu\u015ftururken bu methodu override edeceksiniz. Yani Android platformunun \u00f6zelliklerini DependencyService ile Xamarin.Forms\u2019da kullanacaks\u0131n\u0131z.<\/p>\n
public interface IDatabase\n{\n    SQLiteConnection GetConnection();\n}<\/code><\/pre>\n
3) SQLite Dependecy Service ekleyin<\/span><\/h2>\n
\u015eimdi projenizin Android klas\u00f6r\u00fcne Connection <\/strong>adl\u0131 bir klas\u00f6r ekleyin.\u00a0Ard\u0131ndan Connection klas\u00f6r\u00fcne SQLiteConnection.cs<\/strong> adl\u0131 bir s\u0131n\u0131f ekleyin.\u00a0<\/p>\n
SQLiteConnection.cs<\/strong> s\u0131n\u0131f\u0131 IDatabase interface\u2019sini implement eder ve dolay\u0131s\u0131yla GetConnection() methodunu override etmek zorundad\u0131r. GetConnection() methodu i\u00e7erisinde Places.db ad\u0131nda bir veritaban\u0131 olu\u015fturun ve SQLite ba\u011flant\u0131s\u0131 kurun.<\/p>\n
[assembly: Dependency(typeof(Weather.Droid.Connection.SQLiteConnection))]\nnamespace Weather.Droid.Connection\n{\n    class SQLiteConnection : IDatabase\n    {\n        public SQLite.SQLiteConnection GetConnection()\n        {\n            var filename = "Places.db";\n            var documentspath = System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal);\n            var path = Path.Combine(documentspath, filename);\n            var connection = new SQLite.SQLiteConnection(path);\n            return connection;\n        }\n    }\n}<\/code><\/pre>\n
Ayr\u0131ca bu s\u0131n\u0131f\u0131n bir Dependency oldu\u011funu bildirmeyi unutmay\u0131n.<\/p>\n
[assembly: Dependency(typeof(Weather.Droid.Connection.SQLiteConnection))]<\/code><\/pre>\n
4) Model s\u0131n\u0131f\u0131 ekleyin<\/span><\/h2>\n
Models <\/strong>klas\u00f6r\u00fcne Places.cs<\/strong> adl\u0131 bir s\u0131n\u0131f ekleyin.\u00a0Bu s\u0131n\u0131f, Id, CityName, Latitude, Longitude ve City Key \u00f6zelliklerini i\u00e7erir.\u00a0Places s\u0131n\u0131f\u0131, ekleyece\u011finiz her bir yerin bilgilerini i\u00e7eren model s\u0131n\u0131f\u0131d\u0131r. Yani ileride veritaban\u0131na ekleyece\u011finiz her bir yer bu modele uygun olmal\u0131d\u0131r.<\/p>\n
Id property\u2019sindeki [PrimaryKey, AutoIncrement]<\/strong> ise Id\u2019nin birincil anahar ve otomatik artan bir de\u011fer oldu\u011funu g\u00f6sterir.<\/p>\n
public class Places\n{\n    [PrimaryKey, AutoIncrement]\n    public int Id { get; set; }\n    public string CityName { get; set; }\n    public double CityLat { get; set; }\n    public double CityLon { get; set; }\n    public string CityKey { get; set; }\n    }\n}<\/code><\/pre>\n
5) Database s\u0131n\u0131f\u0131 ekleyin<\/span><\/h2>\n
Projeye Datas <\/strong>ad\u0131nda bir klas\u00f6r ekleyin ve bu klas\u00f6re Database.cs<\/strong> adl\u0131 bir s\u0131n\u0131f ekleyin. <\/p>\n
Bu s\u0131n\u0131f i\u00e7erisinde, \u00f6ncelikle Android platformunda olu\u015fturdu\u011funuz GetConnection() methodunu \u00e7a\u011f\u0131rarak veritaban\u0131 ile ba\u011flant\u0131 kurun.\u00a0Ard\u0131ndan veritaban\u0131nda \u201cPlaces\u201d adl\u0131 bir tablo olu\u015fturun. Daha sonra Places tablosunda CRUD ve di\u011fer veritaban\u0131 i\u015flemlerini uygulay\u0131n.<\/p>\n
public class Database\n{\n    static object locker = new object();\n    SQLiteConnection _sqlconnection;\n    public Database()\n    {\n        _sqlconnection = DependencyService.Get<IDatabase>().GetConnection();\n        _sqlconnection.CreateTable<Places>();\n    }\n    public int Insert(Places place)\n    {\n        lock (locker)\n        {\n            return _sqlconnection.Insert(place);\n        }\n    }\n    public int Update(Places place)\n    {\n        lock (locker)\n        {\n            return _sqlconnection.Update(place);\n        }\n    }\n    public int Delete(int id)\n    {\n        lock (locker)\n        {\n            return _sqlconnection.Delete<Places>(id);\n        }\n    }\n    public IEnumerable<Places> GetAll()\n    {\n        lock (locker)\n        {\n            return (from i in _sqlconnection.Table<Places>() select i).ToList();\n        }\n    }\n    public int FullDelete()\n    {\n        lock (locker)\n        {\n            return _sqlconnection.DeleteAll<Places>();\n        }\n    }\n    public Places Get(int id)\n    {\n        lock (locker)\n        {\n            return _sqlconnection.Table<Places>().FirstOrDefault(t => t.Id == id);\n        }\n    }\n    public List<Places> GetFirst()\n    {\n        lock (locker)\n        {\n            return _sqlconnection.Query<Places>("SELECT * FROM Places LIMIT 1");\n        }\n    }\n    public void Dispose()\n    {\n        _sqlconnection.Dispose();\n    }\n}<\/code><\/pre>\n
6) ViewModel s\u0131n\u0131flar\u0131n\u0131 ekleyin<\/span><\/h2>\n
Projeye SQLite eklerken iki tane Viewmodel s\u0131n\u0131f\u0131na ihtiyac\u0131n\u0131z var.\u00a0<\/p>\n