DZone
Mobile Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Mobile Zone > HowTo: Store and Retrieve Images in a SQL CE Database on Windows Phone Mango

HowTo: Store and Retrieve Images in a SQL CE Database on Windows Phone Mango

John Esposito user avatar by
John Esposito
·
Nov. 02, 11 · Mobile Zone · Interview
Like (0)
Save
Tweet
8.82K Views

Join the DZone community and get the full member experience.

Join For Free

Serious local database support is probably one of the coolest new features of Windows Phone 7.1(5).

For the Windows Phone developer, it's not hard to create a local database, or add some columns, indexes or tables.

But if you're using a SQL CE database then you are, after all, developing for a phone. And one of phones' most exciting powers isn't their hard drives -- it's their cameras.

And it turns out that Mango makes storing camera photos -- or any image data for that matter -- pretty easy.

To see how easy, look at this HowTo from Anton Swanevelder, posted a few days ago on his blog.

Anton breaks SQL CE image-storage into three steps (the CRU in CRUD), and every step takes less than 20 lines. For example, you can create a column to store image data like this:

[Column]
public byte[] ItemImage
{
get { return _ItemImage; }
set
{
if (_ItemImage != value)
{
_ItemImage = value;
NotifyPropertyChanging("ItemImage");
NotifyPropertyChanged("ItemImage");
}
}
}

The other two steps are more interesting (converting a camera stream to a storable byte array, then converting the byte array to a bitmap markup-able in XAML), but no more difficult.

Read the full post for the full implementation.

 

Database Windows Phone sql Mango (software)

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Servlets Listeners Introduction and Examples
  • Testing Schema Registry: Spring Boot and Apache Kafka With JSON Schema
  • Use Lambda Function URL To Write a Serverless App Backed by DynamoDB
  • CSS Position: Relative vs Position Absolute

Comments

Mobile Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo