When to use core data and sqlite

when to use core data and sqlite They provided an utility called Realm Browser. Work with SQLite in an ASP. Although there are advantages and disadvantages from each kind of database, there's a winner. Even though Core Data knows how to use a SQLite database as its persistent store, that doesn't mean you can hand it any SQLite database. With all being said, Core Data is capable of managing complex object graphs for apps with thousands(or even million users!) . Core Data is fast, efficient, an object store, and provides some great integration with Table Views. sqlite-wal . What is the best way to sync storage records of the SQLite database with iCloud (without using Core Data)? Update Cancel. 0 on the iPhone, SQLite was the choice for database implementation on the iPhone. NET Core Runtime. This very component comes as a part of the UI application based on the Electron framework and serves to get lists of users and groups or messages within a stated Hi, I am new to iOS app development. Under the hood on iOS it uses a SQLite database for data persistance. It is possible to reverse engineer a core data sqlite file, but know that Apple may change how it works at any time. Hi, I am new to iOS app development. Four different ways to handle SQLite concurrency. I realize this is an implementation detail, but I was curious as to why that's the case Assuming you use the default SQLite data store, there's no reason you can't change your mind at any time or even mix use of Core Data with direct SQL calls. You can get something that looks kind of like full text search (if you squint) with NSPredicate and CONTAINS or BEGINSWITH , but it becomes really slow (see Performance) with larger data sets. What really impressed me is that Realm is not only very well built, but also very fast. When you use the simulator to test your app, all of the sandboxed files are written to the device directory. The amazing engineers at Realm thought about this too. SQLite. Has there been any discussion about integrating sqlite with Apple's iCloud, either by using Apple's Core Data as the Virtual Machine's database engine (so Moving Core Data Files May 15, 2017 · 3 minute read Core Data Using Core Data with an SQLite database and need to move the location of the store or replace the contents? Core Data and Database Browser for SQLite OK, so you’ve started to work with Core Data and the persistent store coordinator. It is the replacement for core data and SQLite. Core Data and Database Browser for SQLite. The thing to remember is that sometimes clever is good — and sometimes clever is a big mistake. Since the addition of core data to the iPhone SDK, using SQLite with low level C function calls is no longer the only option, and now a question often asked is about which to use. It is important to realize that although you can use Core Data in this way (in fact, it works very well like this), that Core Data actually operates over a different domain to SQLite — meaning that it provides lots of services that SQLite doesn't but also that Core Data can't provide some of the services that SQLite can. While this is not a perfect approach (because a single data set cannot possibly illustrate all of the capabilities of Core Data and SQLite), for practical purposes, it is a reasonable approach. February 25, 2015 Using Swift to Seed a Core Data Database. There are many ways to retrieve and store data on the iPhone, from property lists to NSCoding, from SQLite to Core Data. In this part we are going to explain you how to work with the Core Data framework by using the Magical Record project. “Microsoft. Sqlite“, is an open source library and is also available as NuGet package. This video is unavailable. What’s new in Core Data Swift 3. SQLite or Core Data? Core Data interfaces directly with SQLite, Using Core Data the developer would drag their schema from the data designer in Xcode into an interface builder Finally I realized I had to switch away from Core Data and use SQLite more directly. SQLite and Core Data have been common choices for iOS database until the release of Realm. binary) or SQLite (. Core Data wraps the persistent store, which in many cases is the built-in SQLite library for OS X, iOS, watchOS, and tvOS. With so many other great frameworks like System. g. Here’s the Github source code for reference. Gus wrote it. This new player has advanced features that provide greater flexibility to developers in the creation of If you are familiar with user interface then move on to the Core Data implementation in Swift section Create a new File -> New -> Project and select template Single View Application Enter Product Name, Language as Swift and select “ Use Core Data ” for the new Project. This article covers the pros and cons of each option and discusses the process of switching to Realm if you are already using SQLite or Core Data. sqlite to view you database from the command line. However, the rest of your code may very Core Data and Aggregate Fetches In Swift. Note that I assume you have a basic understanding of Core Data. Prior to the release of OS 3. Adding Full Text Search to a Core Data App Using SQLite Full text search is one area where the base iOS SDK doesn't have a lot to offer. We’ll use the code-first approach to define and generate a local SQLite database with one table, and and then perform all CRUD operations against that table. Now just to be clear, this was with vanilla NativeScript, before Angular was available. Some of it is good, some of it is bad, and some of it is out of date. What is EasyCaching? Join Richard Goforth for an in-depth discussion in this video, Populate a SQLite database, part of Using Entity Framework Core with Legacy Databases. Before we get started, let's download a SQLite Browser that we can use to view the new database. How is it possible? Can you provide After looking at the Xcode Core Data model editor which lets you build your Core Data environment graphically, it’s time to move to the code that implements it. Instead it has own C++ core and aims to provide a mobile-first alternative to SQLite. You can use sqlite3 CoreDataTabBarTutorial. You have a way to define models and relationships. Core Data is designed to be a black box. The goal of this article is to show how I am currently building a Core Data stack in Objective-C in 2015 The first thing to know about Core Data before diving in is that it is not a relational database, and although it uses SQLite as a backing engine, is not an ORM to a relational database either. 04/07/2017; 2 minutes to read Contributors. sqlite, That means you can’t just dispatch to a background queue and use the same Core Data stack. Initializing and Clearing Core Data If you have already made projects which using Core Data you must certainly remember that it requires a lot of boilerplate code to work it and especially during the initialization. When you write your PHP code for SQLite, today GYDataCenter is an alternative to Core Data for people who like using SQLite directly. Using an EF Core database for the IdentityServer4 configuration data December 30, 2017 · by damienbod · in Uncategorized · 3 Comments This article shows how to implement a database store for the IdentityServer4 configurations for the Client, ApiResource and IdentityResource settings using Entity Framework Core and SQLite. Net Core Web Api Integration testing using InMemory EntityFrameworkCore Sqlite and XUnit2 run in memory and mocks the Data Access Laywer while Integration The focus of my talks for 2015 is the Core Data stack. When you create File -> New Project, the 2nd screen looks like this: If you check I'm trying to implement a Core Data project which will have a database of locations. The database underneath is the same. A default data store should be created with Core Data APIs and exactly the same Core Data model file used in your app. PHP supports SQLite as an extension to This is a personal opinion, but I can't stand Core Data. When you do the mapping it creates the sqlite database with other fields than what you are mapping to. Integrating sqlite with Core Data and iCloud. Realm is built to be better and faster than his competitors SQLite and Core Data, easy to use and everything you need will be accomplished in just a couple of lines of code. The good thing about this library is, it’s build for . With Core Data, you create entities that resemble classes and objects to store data. The Core Data framework stack provides a flexible alternative to directly managing data using SQLite or other data storage mechanisms. sqlite, Learn to make a simple application that use the SQLite framework to store Data. I want to manage everything with Core data after I want to collect all data in sqlite database. I have my sqlite database and I want to fetch records from it using Core Data. Aug 3, 2013 I tried using FMDB as an alternative to Core Data, which works . I would like to include the sqlite db with core data but this is not possible due to Core Data's treatment of sqlite (It includes two extra tables prefixed by Z_ amongst other things). If this will never happen, we can safely include the user-generated data in the same data model and configuration. migrate Android tutorial about building a simple e-book app using realm database which is an alternative to sqlite and core data. I was learning Core Data and previously I have use SQLite in one of my project. The most common options for iOS databases are SQLite and Core Data and a relatively newer player called Realm. Simple saving. Chapter 31 Parsing CSV and Preloading a SQLite Database Using Core Data. In a way, they form a logical progression. You can use Predicates to build queries and build relationships between your Entities using Relationships. My understanding is that Core Data is a wrapper over SQLite, so it shouldn't be a problem except for data type conversions. The Core Data API allows developers to create and use a relational database, perform record validation, and perform queries using SQL-less conditions. Fast queries. The MvcMovieContext object handles the task of connecting to the database and mapping Movie objects to database records. SQLite vs Core Data Local Databases Battle It is possible to reverse engineer a core data sqlite file, but know that Apple may change how it works at any time. Could you In addition, we can use functional paradigms in Swift that we can’t use in Objective-C. SQLite. Now my question is in what scenario Core Data should be used and in wha - Search - when core data sqlite learning previously SQLie or Core Data? We're comparing this in this video. How to use SQLite Database in Swift. It is also a persistent technology, in that it can persist the state of the model objects to disk but the important point is that Core Data is much more than just a framework to load and save data. PHP supports SQLite as an extension to Core Data uses Entities to represent the tables in SQLite and Attributes to represent the columns. 0 Xcode 7. My suggestion for you is use Realm bro. Data. There are three major options: Property Lists, SQLite, and Core Data. It is widely used throughout the developer community and is known for being reliable and robust. These keywords A few of them: SQLite Professional, Core Data Editor, Core Data Pro, etc. We tell it to use the NSURL for the SQLite file we generated in Step 9, and most importantly, we pass in the options for Core Data. Answer Wiki. EF Core can now create SQLite databases using Entity Framework migrations which was not possible in previous versions. SQLite has an in-memory mode that allows you to use SQLite to write tests against a relational database, without the overhead of actual database operations. Now that the core method of our class has been implemented, we have only left to make use of it. Tools for Core Data. It is not clear if this is a bug or if there is something I am I was looking at the sqlite table that Core Data generates and noticed that all table columns start with 'Z'. In this article, you will learn how to use an open source library named EasyCaching to handle caching in ASP. The best way to compare Core Data and SQLite is to use the same data set when testing. You will need to use the various sqlite3 commands and SQL to see any values. Try Jira for free. 1 vs new Core Data with Xcode 8 beta to see if it has become any easier to use Core Data. Step 10: Register for Notifications when Core Data is Updated by iCloud Why we use core data for local storage in iOS not use the SQLite database? How do I use SQLite database instead of API in iOS? How do you use an SQLite database browser? I'm trying to implement a Core Data project which will have a database of locations. Now I've Support Spatial Data Types on SQL any additional code that can be shared between providers should be moved into a common assembly owned by the EF Core team Although SQLite is integrated tightly with PHP, Android, and iOS/OS X, the integration strategies differ somewhat. I realize this is an implementation detail, but I was curious as to why that's the case The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. For example you could use HTML5 local storage, Mozilla’s localForage library, or Ionic’s SQLite extension that is part of Ionic Native. 0. What makes one better than the other? I see many people using Core Data because its Apples new toy. Once you understand how data preloading works, I will show you how to use an existing SQLite database (again pre-filled with data) in your app. By providing an object oriented abstraction layer on top of the data the task of managing data storage is made significantly easier for the iOS application developer. Swift; Core Data, Seed Database, Swift; 6 Comments; Updated on September 23, 2015 – Swift 2. 6)? Which database should I use? SQLite and Core Data have been common choices for iOS database until the release of Realm. In React Native, where you are building a hybrid application, you can either use SQLite, or CouchDB for storage and then use Core Data to play with the object graphs. Sqlite library that is maintained by the ASP. Should I use Core Data or something else? If you are comfortable using SQLite already, it's not a bad idea to just use that. For developers unfamiliar with SQL and reluctant to learn it, an alternative method for storing data in a database involves the use of the Core Data framework. binary (. That accounts for compatibility and cross-platform. Core Data is a framework that you use to manage the model layer objects in your application. For the data definition as well as the data I just want to read and write data in my iPhone app. By far the best options (if it fits your app’s data needs) is Apple’s own Core Data which can use SQLite as it’s database store. Using SQLite and FMDB instead of Core Data allows for a ton of flexibility and makes room for clever solutions. Hi Iain, If I understand you correctly, what you're asking is what are the pros and cons of using Core Data versus using normal objects or SQLite. I have the data in a csv file and also as a sqlite db. Asp. Understanding Core Data on iOS. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects. F-Script's new Core Data browser lets you open up and query any Core Data database, an invaluable debugging tool. When used in conjunction with Core Data, Interface Builder facilitates setting up the controller logic to manage the data for any entity created in the data model. If we want to store it with Core Data, the next question is whether the use case might require updating the seed data set in the future by shipping an updated pre-populated SQLite file. The solution is simple: use Using SQLite My favourite thing about ASP. There is no difference. sqlite called DB. I ended up using two SQLite databases, one big one opened Using Entity Framework Core 2. The Core Data Framework stack provides a flexible alternative to directly managing data using SQLite or other data storage mechanisms. Swift + Core Data like a binary data store, SQLite store, or an in Here's a detailed look at how to use Core Data to create and use a simple database. First Chapter 9 Using sQLite/Core Data with swift (ios anD os X) 76 In most cases, the persistent store coordinator handles a single persistent store. Really you should never manually write to a SQLite Core Data database. First To apply the SQLite Wrapper functions, we have taken the SQLite ODBC driver written in C++ and wrapped into . This new player has advanced features that provide greater flexibility to developers in the creation of world class iOS applications. GYDataCenter is built on top of FMDB. iOS – checking to see if a word with blank letters is valid using NSSet, NSArray, Core Data and SQLite - Thomas Bibby Annoying Scrabble words like azo are even more annoying when you use a blank An interesting problem I had recently was to check to see if a string was valid word or not, comparing against a word list with over 170,000 entries. Core Data is a popular framework that developers can use to manage the persistence of data inside their applications. You can use SQLite with EF Core, or you can talk to a SQLite database directly using the Microsoft. 3. Not completely directly — I use FMDB , a lightweight Objective-C interface that works on Macs and iPhones. Today we will be focusing on a few important aspects of Core Data, namely, how to set I am looking for examples/ideas/tips for how to make a Core Data application multi-user. PHP supports SQLite as an extension to the language (no longer optional as of this writing). m file. Sqlite, sqlite-net, Portable Class Library for SQLite, SQLitePCL. Before we get started, it is important to understand why you might want to use Core Data with SQLite for storage over property lists, a custom XML format, or direct SQLite database access. That said, if you still want to migrate, you'll have to design a Core Data model and then write fully custom code to migrate from your existing SQLite file to Core Data. Realm store data in a universal, table-based format by a C++ core. The use of SQLite is an implementation detail and not one we are encouraged to worry about. for a backup) of a SQLite database file while it’s being used by Core Data is not trivial: You should use official Core Data APIs to make copies of your database. it's a great tool for using Core You probably already know this (but just in case), Core Data is based on SQLite. This article shows how to use SQLite with ASP. If your data needs are basic CoreData can seem like a great starting point. NET team. The only reason SurfJournalModel. You can’t do that without making a fateful choice. This use case is closely related to the data transfer format and data container use cases below. NET Core . Websites SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). Open the BlogDemoAppDelegate. Watch Queue Queue Introduction. Check out FMDB for sqlite. Motivation. I don't think you can port your current database to Core Data. I don’t know if Apple has official sample code for this task, but NSPersistent Store Coordinator. NET Core (only . As somebody who doesn't come from a web background, I prefer to use SQLite as storage for my iOS apps, although I use a wrapper on top of it (I used to use Core Data-on-SQLite, but ran into serious issues with it and switched to YapDatabase instead, which has been excellent). Apple can modify the underlying structure at any time. In this chapter we have looked at the basics of storing data on iOS using the SQLite database environment using the FMDB wrapper approach to using SQLite from within Swift code. This new player has advanced features that provide greater flexibility to developers in the creation of One tool is enough to track issues & release great software. Questions and answers database design for Core Data. Are SQLite and CORE DATA two different technologies? I was under the impression that a SQLite database is created in your app when you create a core data app, and that you use the core data api to access it? I am currently writing an ios app that uses a medium size pre-populated core data database. Felix Krause. ad by Atlassian. In this chapter we have looked at the basics of storing data on iOS using the SQLite database environment. There is a wealth of information on the internet about Core Data. 1 and an SQLite database, I get different behaviour from a LINQ GroupJoin if I use it after another Join. Having worked with mysql previously along side php and java I have to say that the way core data is implemented makes it very powerful and great to use for object persistence. Make a List App Using Core Data! (Swift 2 in Xcode) - Duration: 23:10. sqlite") do I was looking at the sqlite table that Core Data generates and noticed that all table columns start with 'Z'. SQLite, Mono. NET framework from my Mac using a lightweight editor like VS Code makes me very happy indeed. I have a Core Data macOS app with a facility to download a saved store (sqlite files etc. Core Data Queries Using Expressions I think some of the confusion comes from the fact the Core Data can use SQLite as the underlying object store but that is an Making a copy (e. You use SQLite database with Swift just like you do with Objective C. Binding Data Objects Using Core Data Interface Builder is the Xcode tool used to define a user interface for an iOS or Mac app. For the data definition as well as the data In this article we’ll show how to use Entity Framework Core and SQLite in a UWP app. Should I use Core Data or SQLite to have better App Size Hot Network Questions What are the pros and cons of having your own UPS attached to your own server hosted in a data center? Because Core Data can use SQLite as one, but only one of several, persistence methods, a lot of novices develop the idea that Core Data is just an object oriented wrapped for SQL and that therefore Core Data can be understood in terms of SQL e. For example, if we were using Sqlite it would look like this: Entity Framework Core and sqlite: database migration (using VS2017 macOS) and then run the last version an check if EF core kept the old data while adding the new column. You tell Core Data to use iCloud when you add Core Data is designed to be a black box. Apple’s Core Data framework, unlike SQLite, takes more of an object-oriented approach to storing user data. NET Core. Core Data applications use XML data stores by default, but you may want to use a SQLite or even a standard Binary data store. It looks like the changes in aspnet/Hosting #633 (announcement #157) undid the work to resolve aspnet/Microsoft. Designing an application’s UI can be difficult without actual data to present. First Adding Full Text Search to a Core Data App Using SQLite Full text search is one area where the base iOS SDK doesn't have a lot to offer. Founder of fastlane (SQLite) as alternative to Core Data. The database schema of the SQLite database used by Core Data is an implementation detail of the framework. With these options available, I get a lot of requests for information on Ionic’s In React Native, where you are building a hybrid application, you can either use SQLite, or CouchDB for storage and then use Core Data to play with the object graphs. sql or anything I've been thinking about this lately. SQLite, Core Data, or Realm? Can I really use Core Data for anything? If not, what kind of Core Data is essentially a framework that places a wrapper around the SQLite database (and other storage environments) enabling the developer to work with data in terms of Objective-C objects without requiring any knowledge of the underlying database technology. I am able to download the myProject. Core Data works directly with SQLite, the Using SQLite with Core Data (iOS and OS X) Authors; When you write your PHP code for SQLite, today’s best practice is to use the PHP data object (PDO) class Core Data and Database Browser for SQLite. For Core Data, the managed context is, well, the whole world of operations that happen both in the database and in memory, Core Data is saved on the device with sqlite. Entity Framework Core Entity Framework (EF) is an object-relational mapper that you can use to work with relational data by using domain-specific objects. Net Core, for example a console app) and you did not rely on IoC, you would have to provide a parameterless constructor and override a method called OnConfiguring. among the major I just want to read and write data in my iPhone app. Apple is free to change its underlining convention at anytime. You tell Core Data to use iCloud when you add If you were not using ASP. If you When you use a Migration Manager, Core Data will create a new database for you, and start copying the entities one by one from the old DB to the new one. NET Core, meaning you can develop and run applications on Windows and non-Windows platform (Mac, Linux) supporting . If you truly have a need to directly manipulate the SQLite database in a production application, you should forgo Core Data and use raw SQL access instead. Core Data interfaces directly with SQLite, Using Core Data the developer would drag their schema from the data designer in Xcode into an interface builder Using SQLite and FMDB instead of Core Data allows for a ton of flexibility and makes room for clever solutions. NET Core web application, using EntityFramework 7 ? I dived into ASP. ) from dropbox. It’s cool, but wouldn’t it be nice if you could view the contents of your SQLite database outside of the simulator? Core Data is essentially a framework that places a wrapper around the SQLite database (and other storage environments) enabling the developer to work with data in terms of Swift objects without requiring any knowledge of the underlying database technology. NET Core Data. How is it possible? Can you provide Although SQLite is integrated tightly with PHP, Android, and iOS/OS X, the integration strategies differ somewhat. This two-part SQLite tutorial series is going to cover one of those options: SQLite. When it comes to Ionic 2 there are many ways that you can store your data. Should I use Core Data or SQLite to have better App Size Hot Network Questions What are the pros and cons of having your own UPS attached to your own server hosted in a data center? We recommend that you use either the Entity Framework Core or the open-source SQLite library built by Microsoft. 0 · Share on Google+ Core Data doesn't attempt to be compatible with how you'd use SQLite if you were using SQLite on its own. Use and Make the core data compatible to iOS 8. Watch Queue Queue. XCode has project template for Core Data. A few of them: SQLite Professional, Core Data Editor, Core Data Pro, etc. Using aspnet core 1. As we are using journal_mode = WAL , there’s an additional file besides DB. So if we want to use SQLite in our application we might have to work with complicated C functions, data types and pointers Core Data is a framework that you use to manage the model layer objects in your application. migrate Integrating sqlite with Core Data and iCloud. If you want convenience like Core Data and more controll over implementation Core Data, NSPersistentContainer, Swift 0 Comments If you’ve been creating the Core Data Stack without NSPersistentContainer and you’re thinking about switching things up to use NSPersistentContainer , you need to think about your existing SQLite persistent store. And because Swift has handy Obj-C bridging, you can just use any of the existing 3rd party libraries with sqlite, mysql, mongodb. Common contract which is built on top of . 0 to current Version Core Data. Jared Davidson 44,002 views. NET Core the moment I heard about it and created my first web application, I suddenly had a bunch of data that I wanted to store and SQLite seemed like the obvious choice. Note: You should never write to the SQLite Core Data database directly. The importing process involves the following steps: Realm is not using SQLite as it’s engine. You have an existing SQLite database and have decided to import the data into a Core Data SQLite database. When working with Core Data, you may have asked these two questions: How can you preload existing data into the SQLite database? Why would you use Realm over Core Data? Update Cancel. raw, and more why create yet another one? The differentiating feature of Microsoft. Could someone please explain this. This is easily done. Quite a bit of time ago when I first started using NativeScript, I wrote a tutorial around using a SQLite database with it. Has there been any discussion about integrating sqlite with Apple's iCloud, either by using Apple's Core Data as the Virtual Machine's database engine (so Questions and answers database design for Core Data. SQLite is a simple and easy to use library that implements a simple database engine, treating Although SQLite is integrated tightly with PHP, Android, and iOS/OS X, the integration strategies differ somewhat. Being able to enjoy the richness of the . Core Data vs. tables, columns, rows, keys, joins etc. In this article. Could you In a next video, we'll copy over the data from our existing database with Entity Framework Core. That’s simple, as we just have to implement two new small, public methods: One for running select queries and loading data, and one for executing insert , update and delete queries. things in common to make it a reasonable thing to do and at the end of the day Core Data is backed by a SQLite database. By Rick Anderson. NET Core 2. Thus, there is not really any conflict between using Core Data or SQLite directly. Some time we need to use core data in application , for that we use in build core data provided by iOS but on the time of creation we select core data and default code attach to appdelegate class and its version is set to current , when we less the iOS version of application then the default code is not supported so SQLITE COREDATA ENCRYPTED INCREMENTAL STORE MIGRATION SUPPORT FOR IOS We are looking to implement model migration into encrypted-core-data project from github ( [url removed, login to view] ), Using SQLite with Core Data (iOS and OS X) When you write your PHP code for SQLite, today’s best practice is to use the PHP data object (PDO) class. 0 using Entity Framework Core. It provides object-oriented interfaces while still having the flexibility of using raw SQL. Now my question is in what scenario Core Data should be used and in wha - Search - when core data sqlite learning previously Core Data uses a sqlite database but you don't directly use sqlite methods like you are doing currently. Conversely, you should not rely on being able to read Core Data's SQLite data stores with other SQLite tools; the schema is an implementation detail that may change. Making an iOS application is all fun until you have to start maintaining offline user sessions and preferences on the app. Core Data is saved on the device with sqlite. NET Core, then you should not need this code since your database provider is configured outside of the context (in Startup When to use SQLite instead of CoreData on iOS. You can write a tool to do that but your app can be the tool if it already has the capability to maintain its data store. If you are using ASP. 0 the update-database command creates the database and correctly populates the schema Why we use core data for local storage in iOS not use the SQLite database? What are the most memory-efficient ways to migrate 200GB worth of XML to SQLite (using Python 3. How do you add and use an SQLite database in an ASP. Sqlite is that it implements the System. The idea would be for a common SQLite database to be accessed by the application from several different Well, I don’t think there is a real reason not to use Core Data for virtually any project of any size. In this article we’ll show how to use Entity Framework Core and SQLite in a UWP app. Chapter 8 Using sQLite with Core Data (ios anD os X) 63 Core Data descends from eoF, but it is very different in many ways. Sqlite #188. Making a copy (e. NET Core is that it's cross platform. NET Core MVC app. when to use core data and sqlite