Pages

Wednesday, June 29, 2011

Windows Phone 7 (Mango) Tutorial - 24 - Local Database Support, CRUD operation with Demo

n the last two chapters of the tutorial series, we discussed about the local database support in Windows Phone 7 (Mango). We learnt how to create a DataContext class from existing SQL CE database and also we learnt about the issues that arises once we add the class file in the project to build. We learnt the steps to resolve those issues too.

 

In this article, we are going to discuss about the CRUD operations that we can do using the DataContext class with a small application. We will learn how to create and delete a database, we will also learn how to insert or fetch records. After reading this tutorial you will also be able to do other operations like edit, search etc.


Read More...

No comments:

Post a Comment

Labels

.NET (272) .NET 3.5 (1) .Net 4.0 (2) .Net 4.5 (1) .Net Framework 3.5 (1) .Net Framework 4.5 (1) .Net Keywords (1) .Net Tutorials (40) .NET4.5 (1) 3-Tier (1) Abstract XML Parser (1) Accessibility Techniques (1) ADO.NET (3) Adsense (2) Advanced (88) AJAX (6) AJAX Server Control (1) Amazon (1) Amazon SES (1) Anagrams (1) Android (22) Android Development (24) Android Hello World (1) Android in C# (1) Android on OS X (1) Android Resources (21) Android Sample Applications (1) Android Samples (20) Android SDK (4) Android Services (1) Android Tutorials (1) Animation (1) App Store (1) App Submitting (2) Apple (1) Application Architecture (1) Architect (210) Article (1) Articles (277) ASCII Art Editor (1) ASP.Net (34) Asp.Net Articles (1) ASP.Net Tutorials (3) Auto Layout (1) Auto Rotation in iOS (1) AutoMapper (1) BDD (2) Beginner (2) Behavior Driven Development (1) Beyondrelational (1) Bing Maps (1) Bluetooth (1) Bootstrap (1) Bulk OPerations (1) Busy Indicator (1) C (1) C# (268) C# 4.0 (1) C# 5.0 (1) C#4.0 (1) C++ (1) Canvas in Window Phone (1) CAPTCHA (1) Categories in Objective C (1) Chart (1) Chart Control (1) Chat Application (1) Checked keyword (1) Chrome (1) Co Variance Delegates (1) Cocoa (1) Cocoa Resources (1) Cocos2D (2) Cocos2D Templates (1) Code First (2) Code First Migration (1) Collapsable Table View (1) CommandBinding (1) Common Service Locator (1) Computer Softwares (1) Computer Tips and Tricks (22) Computer Tutorials (335) Computer TutorialsmWindow (1) Context Menu (1) Contra Variance Delegates (1) Control Templates (1) Copy Constructor (1) Core Data (2) Cross Plateform (1) Cryptography (1) CSL (1) CSS3 (1) Custom Membership Providers (1) Custom UISwitch (1) DAL (1) Dashboards (1) Data Binding (1) Data Conversion (1) Data Persistence (1) Database (12) Database Connectivity in Java Servlet (1) Database in iOS (1) Datepicker in JQuery (1) DateTime Picker (1) Debug (3) Debugging (2) Delegates (3) Dependency Injection (6) Dependency Injection in .Net (1) Dependency Injection with Ninject (1) Design (1) Design Patterns (2) Dev (3) Dev Tools (1) Dictionary (1) Dispatcher (1) DLL (1) Domainevents (1) Dot Net Interview Questions (8) DotNetRules (1) Download (1) Downloads (3) Drawing (1) Drawing in iOS (1) Dropbox (1) Duck Typing (1) Dynamic Programming (1) Earn Money Online (2) EDF (1) EDF Framework (2) EDM Framework (1) Eid Ul Azha (1) Email (1) Entity Data Model (1) Entity Framework (9) Entity Framework 5.0 (1) Example Code (1) Excel 2007 (20) Exceptions (1) Ext JS (1) ExtJS (1) Facebook (2) Facebook SDK (2) FAQ (1) File Manipulation (1) File Reading in iOS (1) File Reading in Objective C (1) File Upload Control (1) Firefox (1) Future Mocking (1) Game Development (3) GameKit (1) Games (1) Games Development (1) Garbage (1) Garbage Collector (1) Gesture Recognizer (2) GKPicker (1) GLKit (1) Globalization (1) GlobalizationResource in Asp.Net (1) Google (1) Google Adsense (2) Google Docs (1) GPUImage (2) GroundControl (1) HTML (5) HTML 5 (1) HTML5 (3) HTML5 Charts (1) HTTPPost (1) HTTPS (1) iAds (1) iCarousel (1) iCloud (1) IE9 (1) IIS (3) IIS Error (1) In App Purchase (3) Inner Join (4) Instruments (2) Interactive ToolTip (1) Intermediate (278) Internals (1) Internet/Web (7) Interview Questions (8) IOC (1) IOC Container (1) iOS (9) iOS OpenSource (1) iOS 6 (1) iOS Applications (1) iOS Consulting (1) iOS Developer Resources (10) iOS Fonts (1) iOS Grid View (1) iOS Libraries (1) iOS Localization (1) iOS MapKit (1) iOS Open Source (4) iOS Open Sources (3) iOS Photo App (1) iOS Photo Application (1) iOS Resources (10) iOS Sample Code (1) iOS Samples (8) iOS SDK (4) iOS Testing (1) iOS6 (2) iPad (139) iPad Applications (1) iPad Development (1) iPad Popovers (1) iPad Resources (1) iPad Samples (1) iPhone (143) iPhone 4 Dimensions (1) iPhone 4 Screens (1) iPhone 5 Dimensions (1) iPhone 5 Screen (1) iPhone Applications (1) iPhone Articles (116) iPhone Automated Testing (1) iPhone Coding (22) iPhone Controls (1) iPhone Crash Logs (1) iPhone Customization (1) iPhone Development (124) iPhone Distribution (1) iPhone Drawing Application (1) iPhone Game Development (13) iPhone Games (1) iPhone Open Source (4) iPhone Open Sources (1) iPhone OpenSource (1) iPhone Resources (120) iPhone Sample (1) iPhone Samples (6) iPhone Screens (1) iPhone Source (1) iPhone Testing (2) iPhone Turorial (134) iPhone Tutorials (1) iPhone XML (1) iPhone5 (1) iPhone5 Screen (1) Ipload Control (1) iSO Tabed Interface (1) Isolated Storage File (1) iTune Store (2) Java Script (3) Java Servlet (1) Java Tutorial (1) Javascript (4) Join (4) Joins (4) JQuery (10) jQuery For Mobile (1) jQuery Mobile (1) JSBasic (1) JSON (3) JSON Encoding (1) JustDecompile (1) Keyboard Shortcuts (1) Keywords in .Net (1) Keywords in C# (1) Knockout (1) Knockoutjs (1) Lamba Expression (3) Learning (1) LeveyPopListView (1) LINQ (26) LINQ Joins (1) LINQ Operator (1) LINQ Operators (5) Localization (1) MAC OS X (1) MAC OS X Software (1) MAC OS X Text Editors (1) Many to Many Relationship (1) Map Kit (1) MapKit (1) Math (1) MBProgressHUD (1) Media Player in iPhone (1) MembershipProvider (1) Metro Applications (1) Metro Style (1) Metro Style Applications (11) Metro Style ApplicationsWindows 8 (1) Microsoft (42) Microsoft Internet Explorer (1) Mobile Development (1) Mobile Development Tutorials (246) Mobile Developments (247) Mobile Games Development (1) Model View Controller (3) MVC (20) MVC 4 (1) MVC4 (3) MVP (2) MVVM (7) MVVM Pattern (1) N Tire Architecture (1) N-Tier (2) Navigation Bar (1) Navigations (1) Networking (2) News (1) Ninject (5) NLog (1) NSNotification (1) NuGet (1) NUI (1) Nullable (1) Nullable Type (1) NumericUpDown (1) NUnit (1) Object Collaboration Design (1) Object Oriented Programming (1) Objective C (136) Objective C Runtime (1) Objective C Test (1) Objective Literals (1) OData Services (1) Online Money Making (1) OOP (1) Open Source (3) Open Sources (2) Operating Systems (2) Outlook 2007 (5) Page Meta Properties (1) Paper Fold Style Navigation (1) Parallelism (1) Partial View (1) PassCode (1) PassKit (1) Path Mini Language (1) Patterns (1) PDF in iOS (1) PDF in iPhone (1) Phone Call (1) Phone Coding (1) Photoshop (1) PHP (1) Play Audio (1) Popular Design (1) Prism (1) Programming (1) Programming Tutorials (2) Push Notifications (2) Rad Notification (1) RadAutoComplete (1) RadCartesianChart (1) RadComboBox (1) RadControls (19) RadDataForm (1) RadDatePicker (1) RadNumericBox (1) RadPivotGrid (1) RadSlideHubTile (2) RadTimePicker (1) RadToolBar (1) Razor (1) ResourceDictionary (1) Resources (1) Rest Service (1) Reverse Operations (1) RRAutoLayout (1) Ruby Motion (1) Sample Code (3) Sandboxing (1) Scaffolding (1) Scenes (1) ScratchPadView (1) Screen Recording in iOS (1) Scripts (1) SDSegmentControl (1) Segues (1) Self Join (2) SEO (1) Service Location Pattern (1) Service Locator (1) Services (1) Sharepoint 2010 (1) Shelf View (1) SignalIR (1) SilverLight (18) Silverlight 5 (2) Silverlight Breakpoints (1) SilverLight Tutorial (6) Silverlight Tutorials (1) Simultan (1) Sinatra (1) Skip Operator (1) SLP (1) SOAP Service (1) Social (1) Sockets (1) Softwares Download (1) Source Code (1) SP (1) Specflow (2) Splash Screen (1) Split View Controller (1) Split View Controllers (1) Sprint Board in iOS (1) SQL (7) SQL Injection (1) SQL Joins (5) SQL Query (1) SQL Server (2) Sql Server 2005 (1) SQL Server 2008 (2) SQL Server 2012 (1) SQL Server Configuration Manager Trackback (1) SQLite (2) SSL (2) Stackpanel (1) State Machine (1) State Machine In Workflow (1) Store Procedures (1) StoryBoard in iOS (1) Strategy Pattern (1) String (2) String Comparison (1) Structural Design Patterns (1) Stubbing HTTP (1) Styles (1) SVGs (1) Tab View (1) Table View (2) Take Operator (1) Telerik (23) Telerik Upload Control (1) Thumb (1) TilePanel (1) Tips and Tricks (3) Tools of the Trade (1) Touch (1) Transactions (1) Transactions in ADO.Net (1) TransactionScope in ADO.NET (1) TransactionsScope (1) Transforms (1) Troubleshooting (1) Tutorials (99) Twitter (1) Twitter RSS (1) UICollectionView (1) UIKit (1) UISlider Control (1) UITableView (1) UIView (1) UIView in iPad (1) UnChecked Keywords (1) Unit Testing (2) Unity (1) Unity3d (1) Urdu (1) Validation in Java Servlet (1) View Engine (2) Virtual Device (1) Virtual Networking (1) Visual State Manager (1) Visual Studio (25) Visual Studio 2011 (1) Visual Studio 2012 (7) VS2010 (240) VS2012 (4) WCF (9) WCF Service (2) Web Development (13) Web Developments (1) Web Hosting (1) Web Services (2) WebParts (1) Win32 (1) Window (28) Window 8 (22) Window 8 Apps Store (1) Window 8 Push Notifications (2) Window Applications (2) Window Operating Systems (1) Window Phone Development (31) Window Phone Emulator (1) Window Phone Resources (1) Window Phone Samples (1) Window Phone Tutorials (85) Window Store (4) Windows (32) Windows 8 (20) Windows Vista (5) Windows XP (23) WinRT (1) Word 2007 (4) Workflow (1) Workflow Article (1) WP Marketplace (1) WP Sensors (1) WP7 (116) WP8 (115) WPF (27) WPF Controls (1) WPF Games (1) WrapPanel (1) XAML (24) XAML Binding (1) XAMLflix (1) xCode (7) xCode 4 (1) xCode 4.5.2 (2) xCode Formatting (1) XML (11) XML Layouts (1) ZipZap (1)
There was an error in this gadget

LinkWithin

Related Posts Plugin for WordPress, Blogger...