{"id":9150,"date":"2018-05-25T10:09:35","date_gmt":"2018-05-25T01:09:35","guid":{"rendered":"http:\/\/www.moonmile.net\/blog\/?p=9150"},"modified":"2018-05-24T00:22:43","modified_gmt":"2018-05-23T15:22:43","slug":"xamarin-froms-net-standard%e3%81%a7%e3%83%ad%e3%83%bc%e3%82%ab%e3%83%ab%e3%81%aa-sqlite-%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%82%92%e4%bd%bf%e3%81%86","status":"publish","type":"post","link":"http:\/\/www.moonmile.net\/blog\/archives\/9150","title":{"rendered":"Xamarin.Froms+.NET Standard\u3067\u30ed\u30fc\u30ab\u30eb\u306a SQLite \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u3046"},"content":{"rendered":"

Xamarin.Forms\u3067SQLite\u3092\u6271\u3046\u8a18\u4e8b\u306f\u3044\u304f\u3064\u304b\u3042\u308b\u306e\u3060\u3051\u3069\u3001.NET Standard 2.0\u3092\u6271\u3063\u305f\u3082\u306e\u306f\u3001\u4ee5\u4e0b\u3057\u304b\u306a\u304b\u3063\u305f\u306e\u3067\u30e1\u30e2\u4ee3\u308f\u308a\u306b\u8a18\u9332\u3057\u3066\u304a\u304f\u3002<\/p>\n

Xamarin.Forms, NET Standard 2.0 et Entity Framework Core avec SQLite ? Christophe Gigax
\nhttp:\/\/www.christophe.gigax.fr\/2017\/11\/23\/xamarin-forms-net-standard-2-0-et-entity-framework-core-avec-sqlite\/<\/a><\/p>\n

\u3057\u304b\u3082\u8a18\u4e8b\u304c\u30d5\u30e9\u30f3\u30b9\u8a9e\u3060\u3068\u3044\u3046…\u30b3\u30fc\u30c9\u3092\u8aad\u3081\u308c\u3070\u5341\u5206\u306a\u3093\u3060\u3051\u3069\u3002<\/p>\n

\u30ed\u30fc\u30ab\u30eb\u306aSQLite\u30d5\u30a1\u30a4\u30eb\u3092\u7528\u610f\u3059\u308b<\/h2>\n

\u5927\u62b5\u306e\u8a18\u4e8b\u304c\u30a2\u30d7\u30ea\u306e\u5b9f\u884c\u6642\u306b\u65b0\u898f\u306bSQLite\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u3063\u3066\u3044\u3066\u3001\u3058\u3083\u3042\u65e2\u5b58\u306eSQLite\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3044\u305f\u3044\u5834\u5408\u306f\u3069\u3046\u3059\u308b\u306e\u304b\uff1f\u3068\u3044\u3046\u306e\u304c\u7121\u304b\u3063\u305f\u3002Android\u306e\u8a18\u4e8b\u3067\u4f3c\u305f\u3082\u306e\u304c\u3042\u3063\u305f\u306e\u3067\u3001\u3053\u308c\u3092\u6d3b\u7528\u3057\u3066\u3044\u304f\u3002<\/p>\n

Android SDK assets\u306e\u5185\u5bb9\u3092\u5168\u3066\u30ed\u30fc\u30ab\u30eb\u306b\u30b3\u30d4\u30fc\u3059\u308b – \u81ea\u5815\u843d\u306a\u307a\u3047\u3058
\nhttp:\/\/d.hatena.ne.jp\/corrupt\/20110203\/1296695472<\/a><\/p>\n

Entitiy Model \u30af\u30e9\u30b9\u306f MySQL \u306e redmine \u304b\u3089\u501f\u308a\u3066\u6765\u308b\u3002\u3072\u3068\u307e\u305a\u3001projects \u3068 issues \u306e\u69cb\u9020\u3092\u7528\u610f\u3057\u3066\u304a\u304f\u3002<\/p>\n

\r\npublic class projects\r\n{\r\n    public int id { get; set; }\r\n    public string name { get; set; }\r\n    public string description { get; set; }\r\n    public string homepage { get; set; }\r\n    public int is_public { get; set; }\r\n    public int? parent_id { get; set; }\r\n    public DateTime? created_on { get; set; }\r\n    public DateTime? updated_on { get; set; }\r\n    public string identifier { get; set; }\r\n    public int status { get; set; }\r\n    public int? lft { get; set; }\r\n    public int? rgt { get; set; }\r\n    public int inherit_members { get; set; }\r\n    public int? default_version_id { get; set; }\r\n}\r\n\r\npublic class issues\r\n{\r\n    public int id { get; set; }\r\n    public int tracker_id { get; set; }\r\n    public int project_id { get; set; }\r\n    public string subject { get; set; }\r\n    public string description { get; set; }\r\n    public DateTime? due_date { get; set; }\r\n    public int? category_id { get; set; }\r\n    public int status_id { get; set; }\r\n    public int? assigned_to_id { get; set; }\r\n    public int priority_id { get; set; }\r\n    public int? fixed_version_id { get; set; }\r\n    public int author_id { get; set; }\r\n    public int lock_version { get; set; }\r\n    public DateTime? created_on { get; set; }\r\n    public DateTime? updated_on { get; set; }\r\n    public DateTime? start_date { get; set; }\r\n    public int done_ratio { get; set; }\r\n    public double? estimated_hours { get; set; }\r\n    public int? parent_id { get; set; }\r\n    public int? root_id { get; set; }\r\n    public int? lft { get; set; }\r\n    public int? rgt { get; set; }\r\n    public int is_private { get; set; }\r\n    public DateTime? closed_on { get; set; }\r\n}\r\n<\/pre>\n
SQLite \u3067\u3042\u3089\u304b\u3058\u3081\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u304a\u304f\u3002<\/p>\n
\r\ncreate table issues (\r\n\tid int PRIMARY KEY AUTOINCREMENT,\r\n\ttracker_id int,\r\n\tproject_id int,\r\n\tsubject text,\r\n\tdescription\ttext,\r\n\tdue_date text,\r\n\tcategory_id int,\r\n\tstatus_id int,\r\n\tassigned_to_id int,\r\n\tpriority_id int,\r\n\tfixed_version_id int,\r\n\tauthor_id int,\r\n\tlock_version int,\r\n\tcreated_on text,\r\n\tupdated_on text,\r\n\tstart_date text,\r\n\tdone_ratio int,\r\n\testimated_hours real,\r\n\tparent_id int,\r\n\troot_id int,\r\n\tlft int,\r\n\trgt int,\r\n\tis_private int,\r\n\tclosed_on text\r\n);\r\ncreate table projects (\r\n\tid integer PRIMARY KEY AUTOINCREMENT,\r\n\tname text,\r\n\tdescription text,\r\n\thomepage text,\r\n\tis_public int,\r\n\tparent_id int,\r\n\tcreated_on text,\r\n\tupdated_on text,\r\n\tidentifier text,\r\n\tstatus int,\r\n\tlft int,\r\n\trgt int,\r\n\tinherit_members int,\r\n\tdefault_version_id int,\r\n\tdefault_assigned_to_id int\r\n);\r\n<\/pre>\n
\u578b\u306e\u5909\u63db\u30eb\u30fc\u30eb\u306f\u3001<\/p>\n