Cloud database instead of local xamarin

Question

0.00/5 (No votes)

See more:

, +

I create app and all work fine.
Need to replace string instead of local database to be cloud database
Data in table database is the same.

New string is:

Data Source=94.251.1.1,1433;Initial Catalog="BCC";User ID=admin;Password=admin

What I have tried:

My database data:

C#

SQLiteConnection con;
        public SQLiteConnection GetConnectionWithCreateDatabase()
        {
            string fileName = "sampleDatabase.db3";
            string documentPath = System.Environment.GetFolderPath
                   (System.Environment.SpecialFolder.Personal);
            string path = Path.Combine(documentPath, fileName);
            con = new SQLiteConnection(path);
            con.CreateTable<Employee>();
            return con;
        }

Posted 7-Sep-23 21:54pm

Stylus STYLUS

Updated 8-Sep-23 9:57am

Deeksha Shenoy

v3

Add a Solution

Comments

Richard Deeming 8-Sep-23 3:59am

I trust that's not your real publicly-accessible SQL Server connection string you've just posted to a public forum?

And if that's the real credentials, then you should change the password ASAP to something that wouldn't be guessed in the first 30 seconds. :)

Stylus STYLUS 8-Sep-23 4:08am

Data are fake. Just for example

CHill60 8-Sep-23 4:39am

What is your actual question?

Stylus STYLUS 8-Sep-23 4:51am

Instead local database need to replace cloud database
This is data
Data Source=94.251.1.1,1433;Initial Catalog="BCC";User ID=admin;Password=admin

Richard MacCutchan 8-Sep-23 5:31am

Yes, you already said that. So what is the actual problem you are having?

Stylus STYLUS 8-Sep-23 5:37am

I am new in mobile development
Need to put new string in app
I know how to do in visual studio c# Windows Forms
Mobile development don't now
I wan't to learn how to change conn string in xamarin
Existing work, how to replace existing sting for new?
Show me

Richard MacCutchan 8-Sep-23 5:58am

I have no idea what you are doing in your code, but a string is a string. So all you need to do is edit your connection string with the new information. What is difficult about that?

Stylus STYLUS 12-Sep-23 4:52am

I don't undestand conection parameters. Need update existing local db and replace with cloud db
Inetad this

SQLiteConnection con;
public SQLiteConnection GetConnectionWithCreateDatabase()
{
string fileName = "sampleDatabase.db3";
string documentPath = System.Environment.GetFolderPath
(System.Environment.SpecialFolder.Personal);
string path = Path.Combine(documentPath, fileName);
con = new SQLiteConnection(path);
con.CreateTable<employee>();
return con;
}

need to be

Data Source=94.251.1.1,1433;Initial Catalog="BCC";User ID=admin;Password=admin

Where to insert that paramteres?

Richard MacCutchan 12-Sep-23 6:14am

Look at the existing string that you create in yor code, and replace the server name with the remote address. You posted this question 4 days ago, did you try anything at all?

See Azure SQL Database connection strings - ConnectionStrings.com[^].

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2023-09-08T03:36:00

Solution 1

It's not clear at all why you are having a problem - if you could type in the original connection string then you can overtype it with your new one.

Perhaps one of these resources will help you Google for Xamarin edit connection string[^]

Posted 8-Sep-23 3:36am

CHill60