Thank you, Nik. Actually, I'm trying to connect my Umbraco.sdf file with below code.

var dbFactory = new OrmLiteConnectionFactory(System.Configuration.ConfigurationManager.ConnectionStrings["umbracoDbDSN"].ConnectionString, SqlServerDialect.Provider);
        using (var db = dbFactory.Open())
        {
            db.CreateTableIfNotExists<Contact>();
            db.Insert(new Contact
            {
                FirstName = model.FirstName,
                LastName = model.LastName,
                Email = model.Email,
                HomePhone = model.HomePhone,
                MobilePhone = model.MobilePhone,
                ContactMenthod = model.ContactMenthod,
                Comments = model.Comments
            });
        }

But i'm unable to open connection with Umbraco.sdf. Can you please suggest some better approch.

Thank you Niels

Hi Niel,

I'm trying to connect my Umbraco.sdf file in the cloud. I get the error to open the connection as

System.Data.SqlServerCe.SqlCeException (0x80004005): The database file cannot be found. Check the path to the database. [ Data Source = C:\home\site\wwwroot\App_Data\Umbraco.sdf ] at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)

But its working good in my local solution. Here is my controller code...

   [HttpPost]
    public ActionResult ContactForm(Contact model)
    {
        var mainpage = Umbraco.TypedContentAtRoot().FirstOrDefault(n => n.DocumentTypeAlias == "home");
        var database = System.Web.HttpContext.Current.Server.MapPath("~\\App_Data\\Umbraco.sdf");
        using (var conn = new SqlCeConnection("Data Source=" + database))
        {
            conn.Open();
            try
            {
                string existsQuery = string.Format("SELECT COUNT(*) FROM information_schema.tables WHERE table_name = 'Contact'");
                SqlCeCommand command = new SqlCeCommand(existsQuery, conn);
                var count = Convert.ToInt32(command.ExecuteScalar());
                if (count == 0)
                {
                    string createQuery = "Create table [Contact]([FirstName] nvarchar(50), [LastName] nvarchar(50),[Email] nvarchar(50),[HomePhone] nvarchar(50),[MobilePhone] nvarchar(50),[ContactMenthod] nvarchar(50),[Comments] nvarchar(256))";
                    SqlCeCommand command1 = new SqlCeCommand(createQuery, conn);
                    command1.ExecuteNonQuery();
                }
                string insertQuery = "INSERT INTO [Contact] ([FirstName],[LastName],[Email],[HomePhone],[MobilePhone],[ContactMenthod],[Comments]) Values('" + model.FirstName + "','" + model.LastName + "','" + model.Email + "','" + model.HomePhone + "','" + model.MobilePhone + "','" + model.ContactMenthod + "','" + model.Comments + "')";
                SqlCeCommand command2 = new SqlCeCommand(insertQuery, conn);
                command2.ExecuteNonQuery();
                EmailSendContact(model);
                return RedirectToUmbracoPage(mainpage.Id);
            }
            catch (SqlCeException ex)
            {
                string _errorMsg = ex.Message;
                return CurrentUmbracoPage();
            }
            finally
            {
                if (conn.State == ConnectionState.Open) conn.Close();
            }
        }
    }

How can i get the Umbraco.sdf file path in the cloud.