-
.NET MAUI & SQLite
31 Lessons-
StartWhat is SQLite?
-
StartCreating the solution and installing packages nuget
-
StartConfiguration of the connection constants
-
StartConfiguration of the database file path
-
StartCreating the Customer Model
-
StartMapping a class to a table through SQLite attributes
-
StartApplying SQLite attributes to a C# class
-
StartValid data types in SQLite
-
StartAlways open connection or not
-
StartCreating a database access class
-
StartThe CreateTable method
-
StartInserting a customer
-
StartSelecting Customers
-
StartExecuting SQL queries
-
StartUpdating a customer
-
StartDeleting a customer
-
StartControlling access to the database
-
StartDefining the main layout
-
StartAdding a new customer
-
StartUpdating a record
-
StartDeleting a record
-
StartMethods to make queries with Lambda expressions more flexible
-
StartCreating repositories to work with multiple tables
-
StartInstalling SQLite Extensions package
-
StartOne to One Relationships
-
StartCascade Insert
-
StartCascade Read
-
StartCascade Delete
-
StartOne to Many Relationship
-
StartMany to Many Relationship
-
StartSection Resources
-
-
Project: ProsperDaily
13 Lessons-
StartProject Overview
-
StartCreating and configuring the project
-
StartCreating the DashboardPage design
-
StartCreating the page to add a new transaction
-
StartCreating the statistics page
-
StartCreating the model
-
StartAdding functionality to insert transactions
-
StartAdding functionality to the Dashboard
-
StartAdding functionality to the Statistics page
-
StartJoining all the windows using Tabs
-
StartAdding formatting to transactions
-
StartFinal Adjustments
-
StartProsper Daily
-
.NET MAUI: Local Databases with SQLite
Integrate SQLite seamlessly into your .NET MAUI projects and build robust, data-driven mobile applications.
LEVEL
LEVEL
BEGINNER
CONTENT
VIDEOS + SOURCE CODE
DURATION
3+ HOURS
PRICE
$24.99 $14.99 USD
About this course
Are you looking to integrate a powerful, lightweight, and cross-platform database into your .NET MAUI applications? This course is designed to take you from the basics of SQLite to advanced database management techniques in .NET MAUI. With hands-on lessons, you'll learn how to set up, configure, and manipulate SQLite databases within your mobile applications, ensuring data integrity and optimal performance.
Throughout the course, you will build a comprehensive application—ProsperDaily—that tracks an individual's income and expenses. This practical project will solidify your understanding of SQLite integration, from setting up the initial project and configuring database connections to creating and managing data models and executing SQL queries. By the end of the course, you'll be equipped with the skills to develop data-driven applications that are both efficient and maintainable.
Whether you're a seasoned developer looking to expand your knowledge or a beginner eager to dive into mobile app development, this course provides step-by-step guidance to master SQLite in .NET MAUI. Join us and start building sophisticated, data-centric mobile applications today!
- Set up and configure SQLite in .NET MAUI applications.
- Create and manage database models using SQLite attributes.
- Implement CRUD operations (Create, Read, Update, Delete) in your mobile apps.
- Build a real-world application to track income and expenses with advanced data visualization.
Who is this course for?
- .NET MAUI developers aiming to enhance their applications with robust database functionalities.
- Mobile app developers looking to integrate SQLite for efficient local data storage.
- Beginners in .NET MAUI seeking comprehensive, hands-on experience with database integration.
- Software engineers interested in learning advanced techniques for building data-driven mobile apps.
Prerequisites to take the course
- Basic knowledge of C# programming.
- Familiarity with .NET MAUI application structure.
- Understanding of object-oriented programming concepts.
- Basic experience with SQL and relational databases is helpful but not required.
Course Curriculum
Meet the Instructor
Hello! My name is Hector Perez. I'm a Microsoft MVP, and software engineer with more than 10 years of experience. I have taught thousands of people to develop applications, or to become better professionals thanks to my courses from basic to advanced. I believe that developing applications should be fun and accessible to everyone.
Buy only this course with a single payment
Access to this course for life with a single payment
Gain access to this course and many others through our various offers
MASTER IN .NET MAUI
$99.99 USD
Single Payment, yours for life
- Access to all current and new courses of the Master in .NET MAUI
- Access to project source code
- Access to YouTube tutorials source code
MONTHLY SUBSCRIPTION
$14.99 USD
Access to all Academy courses plus bonuses for a small monthly fee.
- Access to the entire academy for one month
- Access to all current and new courses of the Master in .NET MAUI
- Access to XAML components
- Access to pre-created XAML templates
- Access to YouTube tutorials source code
Lifetime deal
$999.99 USD
Lifetime access to all current and future academy courses with a single payment.
- Lifetime access to all Academy courses
- Lifetime access to XAML components
- Lifetime access to pre-created XAML templates
- Lifetime access to YouTube tutorials source code
FREQUENTLY ASKED QUESTIONS
How long do I have access to the course?
This depends on the plan you choose. If you purchase the Course in the Single Payment plan, you will have it available for life. If you purchase it by subscription, you will have it available depending on the months you select.
Can I get a certificate at the end of the course?
Yes, a digital certificate will be provided upon successful completion of all lessons and course assignments.
How is the course structured?
The course is divided into several sections, each focusing on a specific topic. Each section includes video lessons, readings and assignments to reinforce your learning.
How much time will I need to complete the course?
This really depends on how much time you can devote to the course each week and the length of the course. There are courses that can be completed the same day they are taken, and courses that require an estimated 3 - 6 months to complete.
What if I can't keep up with the course material?
No problem. You can learn at your own pace and have access to the course material whenever you need it. There are no strict deadlines for assignments, so you can complete them at your convenience.
How can I access the course material?
All course material is available online through our learning platform. You can access it from any device with an Internet connection.
Can I share my account with others?
No. Each registration is for one user only. Sharing accounts would violate our terms and conditions and may result in account termination.
What is the refund policy?
We offer a 7-day money back guarantee. If you are not satisfied with the course for any reason, you can request a full refund within 30 days of your purchase.
How can I contact the instructor if I have questions?
Students can submit their questions directly through the learning platform.
