Linq2db for MySQL [closed]
-2
I am using Linq2db for MySQL and i am getting this error when i try to edit
mydatabase.tt file->
Severity Code Description Project File Line Suppression State
Error Running transformation: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown table 'parameters' in information_schema
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
at LinqToDB.Data.CommandInfo.Query[T](Func`2 objectReader)
at LinqToDB.DataProvider.MySql.MySqlSchemaProvider.GetProcedureParameters(DataConnection dataConnection)
at LinqToDB.SchemaProvider.SchemaProviderBase.GetSchema(DataConnection dataConnection, GetSchemaOptions options)
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadServerMetadata(DataConnection dataConnection) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude:line 103
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadMetadata(DataConnection dataConnection) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude:line 414
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadMySqlMetadata(String server, String database, String uid, String password, Int32 port) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesLinqToDB.MySql.ttinclude:line 28
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.TransformText() in C:Usersdellsourcereposlinq2dblinq2dbDataModelssmartstudentanalysis.tt:line 41 Miscellaneous Files C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude 103
wpf linq2db
asked Nov 21 '18 at 11:14
Shubham Gandhi
42
closed as off-topic by ASh, greg-449, Rob, pirho, Mark Rotteveel Nov 21 '18 at 16:57
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – ASh, greg-449, Rob, pirho, Mark Rotteveel
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
-2
I am using Linq2db for MySQL and i am getting this error when i try to edit
mydatabase.tt file->
Severity Code Description Project File Line Suppression State
Error Running transformation: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown table 'parameters' in information_schema
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
at LinqToDB.Data.CommandInfo.Query[T](Func`2 objectReader)
at LinqToDB.DataProvider.MySql.MySqlSchemaProvider.GetProcedureParameters(DataConnection dataConnection)
at LinqToDB.SchemaProvider.SchemaProviderBase.GetSchema(DataConnection dataConnection, GetSchemaOptions options)
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadServerMetadata(DataConnection dataConnection) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude:line 103
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadMetadata(DataConnection dataConnection) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude:line 414
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadMySqlMetadata(String server, String database, String uid, String password, Int32 port) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesLinqToDB.MySql.ttinclude:line 28
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.TransformText() in C:Usersdellsourcereposlinq2dblinq2dbDataModelssmartstudentanalysis.tt:line 41 Miscellaneous Files C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude 103
wpf linq2db
asked Nov 21 '18 at 11:14
Shubham Gandhi
42
closed as off-topic by ASh, greg-449, Rob, pirho, Mark Rotteveel Nov 21 '18 at 16:57
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – ASh, greg-449, Rob, pirho, Mark Rotteveel
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
-2
-2
-2
I am using Linq2db for MySQL and i am getting this error when i try to edit
mydatabase.tt file->
Severity Code Description Project File Line Suppression State
Error Running transformation: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown table 'parameters' in information_schema
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
at LinqToDB.Data.CommandInfo.Query[T](Func`2 objectReader)
at LinqToDB.DataProvider.MySql.MySqlSchemaProvider.GetProcedureParameters(DataConnection dataConnection)
at LinqToDB.SchemaProvider.SchemaProviderBase.GetSchema(DataConnection dataConnection, GetSchemaOptions options)
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadServerMetadata(DataConnection dataConnection) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude:line 103
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadMetadata(DataConnection dataConnection) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude:line 414
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadMySqlMetadata(String server, String database, String uid, String password, Int32 port) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesLinqToDB.MySql.ttinclude:line 28
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.TransformText() in C:Usersdellsourcereposlinq2dblinq2dbDataModelssmartstudentanalysis.tt:line 41 Miscellaneous Files C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude 103
wpf linq2db
asked Nov 21 '18 at 11:14
Shubham Gandhi
42
I am using Linq2db for MySQL and i am getting this error when i try to edit
mydatabase.tt file->
Severity Code Description Project File Line Suppression State
Error Running transformation: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown table 'parameters' in information_schema
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
at LinqToDB.Data.CommandInfo.Query[T](Func`2 objectReader)
at LinqToDB.DataProvider.MySql.MySqlSchemaProvider.GetProcedureParameters(DataConnection dataConnection)
at LinqToDB.SchemaProvider.SchemaProviderBase.GetSchema(DataConnection dataConnection, GetSchemaOptions options)
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadServerMetadata(DataConnection dataConnection) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude:line 103
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadMetadata(DataConnection dataConnection) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude:line 414
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.LoadMySqlMetadata(String server, String database, String uid, String password, Int32 port) in C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesLinqToDB.MySql.ttinclude:line 28
at Microsoft.VisualStudio.TextTemplating1C8D25087E09D088F52217B8EAF40277DD5B77FA6EF545EC279B3B36B574D212884F1FD45CDD94CFD93CCE64E7E6818E71B0F2C9B1B2129AB70DD0D74B6074C9.GeneratedTextTransformation.TransformText() in C:Usersdellsourcereposlinq2dblinq2dbDataModelssmartstudentanalysis.tt:line 41 Miscellaneous Files C:Usersdellsourcereposlinq2dbpackageslinq2db.MySql.2.5.3build..contentFilesanyanyLinqToDB.TemplatesDataModel.ttinclude 103
wpf linq2db
wpf linq2db
asked Nov 21 '18 at 11:14
Shubham Gandhi
42
asked Nov 21 '18 at 11:14
Shubham Gandhi
42
edited Nov 22 '18 at 5:45
asked Nov 21 '18 at 11:14
Shubham Gandhi
42
asked Nov 21 '18 at 11:14
Shubham Gandhi
42
asked Nov 21 '18 at 11:14
Shubham Gandhi
42
42
closed as off-topic by ASh, greg-449, Rob, pirho, Mark Rotteveel Nov 21 '18 at 16:57
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – ASh, greg-449, Rob, pirho, Mark Rotteveel
If this question can be reworded to fit the rules in the help center, please edit the question.
closed as off-topic by ASh, greg-449, Rob, pirho, Mark Rotteveel Nov 21 '18 at 16:57
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions seeking debugging help ("why isn't this code working?") must include the desired behavior, a specific problem or error and the shortest code necessary to reproduce it in the question itself. Questions without a clear problem statement are not useful to other readers. See: How to create a Minimal, Complete, and Verifiable example." – ASh, greg-449, Rob, pirho, Mark Rotteveel
If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
1
You need to disable procedures schema loading in your tt file:
GetSchemaOptions.GetProcedures = false;
What version of MySQL you use that you don't have INFORMATION_SCHEMA.PARAMETERS table?
answered Nov 21 '18 at 12:06
DLuk
40238
If you have a question for the poster, do not ask it here within your answer. Ask in the comments section under the question.
– Rob
Nov 21 '18 at 14:18
problem already solved
– DLuk
Nov 21 '18 at 14:31
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
You need to disable procedures schema loading in your tt file:
GetSchemaOptions.GetProcedures = false;
What version of MySQL you use that you don't have INFORMATION_SCHEMA.PARAMETERS table?
answered Nov 21 '18 at 12:06
DLuk
40238
If you have a question for the poster, do not ask it here within your answer. Ask in the comments section under the question.
– Rob
Nov 21 '18 at 14:18
problem already solved
– DLuk
Nov 21 '18 at 14:31
add a comment |
1
You need to disable procedures schema loading in your tt file:
GetSchemaOptions.GetProcedures = false;
What version of MySQL you use that you don't have INFORMATION_SCHEMA.PARAMETERS table?
answered Nov 21 '18 at 12:06
DLuk
40238
If you have a question for the poster, do not ask it here within your answer. Ask in the comments section under the question.
– Rob
Nov 21 '18 at 14:18
problem already solved
– DLuk
Nov 21 '18 at 14:31
add a comment |
1
1
1
You need to disable procedures schema loading in your tt file:
GetSchemaOptions.GetProcedures = false;
What version of MySQL you use that you don't have INFORMATION_SCHEMA.PARAMETERS table?
answered Nov 21 '18 at 12:06
DLuk
40238
You need to disable procedures schema loading in your tt file:
GetSchemaOptions.GetProcedures = false;
What version of MySQL you use that you don't have INFORMATION_SCHEMA.PARAMETERS table?
answered Nov 21 '18 at 12:06
DLuk
40238
answered Nov 21 '18 at 12:06
DLuk
40238
answered Nov 21 '18 at 12:06
DLuk
40238
answered Nov 21 '18 at 12:06
DLuk
40238
40238
If you have a question for the poster, do not ask it here within your answer. Ask in the comments section under the question.
– Rob
Nov 21 '18 at 14:18
problem already solved
– DLuk
Nov 21 '18 at 14:31
add a comment |
If you have a question for the poster, do not ask it here within your answer. Ask in the comments section under the question.
– Rob
Nov 21 '18 at 14:18
problem already solved
– DLuk
Nov 21 '18 at 14:31
If you have a question for the poster, do not ask it here within your answer. Ask in the comments section under the question.
– Rob
Nov 21 '18 at 14:18
If you have a question for the poster, do not ask it here within your answer. Ask in the comments section under the question.
– Rob
Nov 21 '18 at 14:18
problem already solved
– DLuk
Nov 21 '18 at 14:31
problem already solved
– DLuk
Nov 21 '18 at 14:31
add a comment |
