Accessing directly a Sql Server Database in Xamarin.Forms

by

You cannot access directly an sql server from your pcl project in Xamarin.Forms because System.Data.SqlClient is not available on pcl.

But you can do it through a dependency service.

First in you PCL project declare you service

public interface IDbDataFetcher
    {
        string GetData(string conn);
    }

Then on you Android project implement the service interface

[assembly: Dependency(typeof(DbFetcher))]
namespace App.Droid.Services
{
    class DbFetcher : IDbDataFetcher
    {

        public List<string> GetData(string conn)
        {
            using (SqlConnection connection = new SqlConnection(conn))
            {

                SqlCommand command = new SqlCommand("select * from smuser", connection);
                try
                {
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        data.Add(reader[0].ToString());
                    }
                    reader.Close();
                }
                catch (Exception ex)
                {
                    //Console.WriteLine(ex.Message);
                }
            }
            return data;
        }
    }
}

Although it is a solution it is a bad one. Always consume web services for your mobile apps

More Related Contents:

  1. Check if string is null
  2. Insert 2 million rows into SQL Server quickly
  3. How can you restrict/control the navigation routes the user can visit based on login status/role?
  4. SQL WHERE clause matching values with trailing spaces
  5. How to implement INotifyPropertyChanged in Xamarin.Forms
  6. Creating a database programmatically in SQL Server
  7. SqlConnection.Close() inside using statement
  8. Xamarin project not running, assembly not found
  9. What is the difference between Xamarin.Form’s LayoutOptions, especially Fill and Expand?
  10. Received an invalid column length from the bcp client for colid 6
  11. Invalid column name sql error
  12. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?
  13. Xamarin – Requesting camera permissions in WebView
  14. How to use Push Notifications in Xamarin Forms
  15. The SSL connection could not be established
  16. How to use Font Awesome icons in project as an icon of ImageButton
  17. Horizontal ListView Xamarin.Forms
  18. Xamarin Forms Swipe Left/Swipe Right Gestures
  19. How do overlap in Xamarin forms?
  20. Is SqlConnection.Close() need inside a Using statement?
  21. Write device platform specific code in Xamarin.Forms
  22. summing values of a column based on id [closed]
  23. How to get last inserted id?
  24. MSSQL Error ‘The underlying provider failed on Open’
  25. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  26. C# with MySQL INSERT parameters
  27. ExecuteScalar vs ExecuteNonQuery when returning an identity value
  28. How to pass string array in SQL parameter to IN clause in SQL
  29. Horrible performance using SqlCommand Async methods with large data
  30. Accessing System Databases/Tables using LINQ to SQL?

Leave a Comment