Mixing
Is there any ORM available which will create table on the fly and make insert for MySql/MariaDB
0
I can use below code which will insert a record in pre-defined table for MySql/MariaDB.
// Insert some data
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO data (some_field) VALUES (@p)";
cmd.Parameters.AddWithValue("p", "Hello world");
await cmd.ExecuteNonQueryAsync();
}
Is there any ORM or utility nuget available which will create the table on the fly and insert C# object without any INSERT, is ORM also available something like this,
foreach (var obj in Messages)
{
db.Insert(obj);
}
c# mysql mariadb
asked Jan 2 at 7:55
user584018user584018
1,80193149
add a comment |
0
I can use below code which will insert a record in pre-defined table for MySql/MariaDB.
// Insert some data
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO data (some_field) VALUES (@p)";
cmd.Parameters.AddWithValue("p", "Hello world");
await cmd.ExecuteNonQueryAsync();
}
Is there any ORM or utility nuget available which will create the table on the fly and insert C# object without any INSERT, is ORM also available something like this,
foreach (var obj in Messages)
{
db.Insert(obj);
}
c# mysql mariadb
asked Jan 2 at 7:55
user584018user584018
1,80193149
What you want is a migrator. FluentMigrator which is used on Serenity support MySQL, it can even create the database from scratch (so all you need to deploy is the .dll, on first run it will take care of creating the DB, updating the schema if necessary etc).
– Martheen
Jan 2 at 8:27
"Creating a table on the fly" is generally a misuse of RDBMS.
– Rick James
Jan 2 at 22:43
add a comment |
0
0
0
I can use below code which will insert a record in pre-defined table for MySql/MariaDB.
// Insert some data
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO data (some_field) VALUES (@p)";
cmd.Parameters.AddWithValue("p", "Hello world");
await cmd.ExecuteNonQueryAsync();
}
Is there any ORM or utility nuget available which will create the table on the fly and insert C# object without any INSERT, is ORM also available something like this,
foreach (var obj in Messages)
{
db.Insert(obj);
}
c# mysql mariadb
asked Jan 2 at 7:55
user584018user584018
1,80193149
I can use below code which will insert a record in pre-defined table for MySql/MariaDB.
// Insert some data
using (var cmd = new MySqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO data (some_field) VALUES (@p)";
cmd.Parameters.AddWithValue("p", "Hello world");
await cmd.ExecuteNonQueryAsync();
}
Is there any ORM or utility nuget available which will create the table on the fly and insert C# object without any INSERT, is ORM also available something like this,
foreach (var obj in Messages)
{
db.Insert(obj);
}
c# mysql mariadb
c# mysql mariadb
asked Jan 2 at 7:55
user584018user584018
1,80193149
asked Jan 2 at 7:55
user584018user584018
1,80193149
asked Jan 2 at 7:55
user584018user584018
1,80193149
asked Jan 2 at 7:55
user584018user584018
1,80193149
asked Jan 2 at 7:55
user584018user584018
1,80193149
1,80193149
What you want is a migrator. FluentMigrator which is used on Serenity support MySQL, it can even create the database from scratch (so all you need to deploy is the .dll, on first run it will take care of creating the DB, updating the schema if necessary etc).
– Martheen
Jan 2 at 8:27
"Creating a table on the fly" is generally a misuse of RDBMS.
– Rick James
Jan 2 at 22:43
add a comment |
What you want is a migrator. FluentMigrator which is used on Serenity support MySQL, it can even create the database from scratch (so all you need to deploy is the .dll, on first run it will take care of creating the DB, updating the schema if necessary etc).
– Martheen
Jan 2 at 8:27
"Creating a table on the fly" is generally a misuse of RDBMS.
– Rick James
Jan 2 at 22:43
What you want is a migrator. FluentMigrator which is used on Serenity support MySQL, it can even create the database from scratch (so all you need to deploy is the .dll, on first run it will take care of creating the DB, updating the schema if necessary etc).
– Martheen
Jan 2 at 8:27
What you want is a migrator. FluentMigrator which is used on Serenity support MySQL, it can even create the database from scratch (so all you need to deploy is the .dll, on first run it will take care of creating the DB, updating the schema if necessary etc).
– Martheen
Jan 2 at 8:27
"Creating a table on the fly" is generally a misuse of RDBMS.
– Rick James
Jan 2 at 22:43
"Creating a table on the fly" is generally a misuse of RDBMS.
– Rick James
Jan 2 at 22:43
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54002972%2fis-there-any-orm-available-which-will-create-table-on-the-fly-and-make-insert-fo%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54002972%2fis-there-any-orm-available-which-will-create-table-on-the-fly-and-make-insert-fo%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What you want is a migrator. FluentMigrator which is used on Serenity support MySQL, it can even create the database from scratch (so all you need to deploy is the .dll, on first run it will take care of creating the DB, updating the schema if necessary etc).
– Martheen
Jan 2 at 8:27
"Creating a table on the fly" is generally a misuse of RDBMS.
– Rick James
Jan 2 at 22:43