Skip to main content

Posts

Showing posts from June, 2011

Windows Phone 7 (Mango) Tutorial - 25 - Learn about Database Connection String

Last three days we learnt about the new feature of Windows Phone 7 (Mango) called "Local Database Support". Yesterday we discussed it in depth by building a small demo application. While working with the demo you might noticed that, we used a connection string to connect with the local database present in the Windows Phone storage.   In this post, we will discuss more on the connection string. After reading this post, you will be able to know what are the various types and parameters available for connection string.   Index - Windows Phone 7 (Mango) Tutorial   What is Connection String? A connection string is a settings to connect with the database file using a Windows Phone 7 application. Using this string parameter you ask your app to connect to an existing database or create a new one to do SQL operations.   By using the connection string you can specify the connection parameters like data source, password, buffer size, database...
Read More....

Executing SQL Query using LINQ to SQL

In this post, I will discuss how we can execute a SQL Query directly from LINQ.Explanation To execute SQL query there is a method in DataContext class called ExecuteQuery ExecuteQuery takes two input parameter 1. SQL Query as string 2. Parameters used in SQL query