How to Change database name in Linq Vb.net

Question

I have a database Linq dbml I need to change the database name before creating

  Dim dt As New DataSchool()
  dt.Connection.Open()
  dt.CreateDatabase()

Do you have a connection string for L2S in the config file and/or on the Settings page of the project properties? If so, what is it? — jmcilhinney
– jmcilhinney, Commented Jul 4, 2020 at 3:47
"Data Source=LAPTOP-AJM33RB1\TESTSERVER;Integrated Security=True;" this is connectionstring — Moustafa Khazaal
– Moustafa Khazaal, Commented Jul 4, 2020 at 9:57
That's the connection string in the code. I asked you whether you had a connection in Settings or in the config file. Are you saying that you do and that it's the same, or did you not answer the question that I actually asked. — jmcilhinney
– jmcilhinney, Commented Jul 4, 2020 at 10:54
it's connection string in config file <add name="Hekma_School_Mangment_System.Settings.dtSchoolsConnectionString" connectionString="Data Source=LAPTOP-AJM33RB1\TESTSERVER;Integrated Security=True;" providerName="System.Data.SqlClient" /> — Moustafa Khazaal
– Moustafa Khazaal, Commented Jul 4, 2020 at 11:47

Moustafa Khazaal · Accepted Answer · 2020-08-18 17:52:37Z

Use This Method

Sub CreatesqldatabaseMSQL()
            Try
                Using connect As New DataSchool(GetSQLConnectionString(True))
                    connect.CreateDatabase()
                End Using
            Catch ex As Exception
               MessageBox.Show(ex.Message)
            End Try
        End Sub

GetSQLConnectionString This Function Return SQLconnection string

  Public Function GetSQLConnectionString(ByVal includeDatabase As Boolean) As String
        Dim builder As New SqlConnectionStringBuilder()
        'Build a connection string from the user input.'
        builder.DataSource = Msql.datasource
        builder.IntegratedSecurity = Msql.IntSec
        If builder.IntegratedSecurity = False Then
            builder.UserID = Msql.username
            builder.Password = Msql.password
        End If
        If includeDatabase Then
            builder.InitialCatalog = Msql.DatabaseName
        End If
        Return builder.ConnectionString
    End Function

Msql.Server, Msql.DatabaseName and etc this is Structure, You can change database name From here

 Public Structure Msql
        Shared datasource As String
        Shared IntSec As Boolean
        Shared username As String
        Shared password As String
        Shared DatabaseName As String
    End Structure

Collectives™ on Stack Overflow

How to Change database name in Linq Vb.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related