Mixing
c# Nhibernate create query with dynamic parameters
2
using the folowing extention methods :
public static void SetParameters(this IQuery query, List<object> Parameters) {
for (int i = 0; i < Parameters.Count(); i++) {
query.SetParameter(i, Parameters[i]);
}
}
public static IQuery SetQuery(this ISession session, string Query, object Parameters) {
return session.CreateSQLQuery(Query + string.Empty + "(" + ParseExt(Parameters) + ")");
}
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
str.Add(":" + i);
}
return string.Join(",", str);
}
i'm creating a query :
public IEnumerable<T> Execute<T>(string Query, params dynamic Parameters) {
using (var _session = _transactionManager.GetSession()) {
var _cmd = _session.SetQuery(Query, Parameters);
if (Parameters != null) {
_cmd.SetParameters(Parameters.ToList());
}
return _cmd.List<T>();
}
}
throws the following error :
Remember that ordinal parameters are 1-based!
NOTE : i tried to change the index to start from 1
c# nhibernate
asked Nov 20 '18 at 16:04
buffbuff
132111
add a comment |
2
using the folowing extention methods :
public static void SetParameters(this IQuery query, List<object> Parameters) {
for (int i = 0; i < Parameters.Count(); i++) {
query.SetParameter(i, Parameters[i]);
}
}
public static IQuery SetQuery(this ISession session, string Query, object Parameters) {
return session.CreateSQLQuery(Query + string.Empty + "(" + ParseExt(Parameters) + ")");
}
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
str.Add(":" + i);
}
return string.Join(",", str);
}
i'm creating a query :
public IEnumerable<T> Execute<T>(string Query, params dynamic Parameters) {
using (var _session = _transactionManager.GetSession()) {
var _cmd = _session.SetQuery(Query, Parameters);
if (Parameters != null) {
_cmd.SetParameters(Parameters.ToList());
}
return _cmd.List<T>();
}
}
throws the following error :
Remember that ordinal parameters are 1-based!
NOTE : i tried to change the index to start from 1
c# nhibernate
asked Nov 20 '18 at 16:04
buffbuff
132111
@dasblinkenlightselect * from dbo.OctoGetProducts
– buff
Nov 20 '18 at 16:48
@dasblinkenlight its added after and parsed as follow :select * from dbo.OctoGetProducts(:0,:1,:2,:3,:4,:5,:6,:7)
– buff
Nov 20 '18 at 17:13
add a comment |
2
2
2
using the folowing extention methods :
public static void SetParameters(this IQuery query, List<object> Parameters) {
for (int i = 0; i < Parameters.Count(); i++) {
query.SetParameter(i, Parameters[i]);
}
}
public static IQuery SetQuery(this ISession session, string Query, object Parameters) {
return session.CreateSQLQuery(Query + string.Empty + "(" + ParseExt(Parameters) + ")");
}
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
str.Add(":" + i);
}
return string.Join(",", str);
}
i'm creating a query :
public IEnumerable<T> Execute<T>(string Query, params dynamic Parameters) {
using (var _session = _transactionManager.GetSession()) {
var _cmd = _session.SetQuery(Query, Parameters);
if (Parameters != null) {
_cmd.SetParameters(Parameters.ToList());
}
return _cmd.List<T>();
}
}
throws the following error :
Remember that ordinal parameters are 1-based!
NOTE : i tried to change the index to start from 1
c# nhibernate
asked Nov 20 '18 at 16:04
buffbuff
132111
using the folowing extention methods :
public static void SetParameters(this IQuery query, List<object> Parameters) {
for (int i = 0; i < Parameters.Count(); i++) {
query.SetParameter(i, Parameters[i]);
}
}
public static IQuery SetQuery(this ISession session, string Query, object Parameters) {
return session.CreateSQLQuery(Query + string.Empty + "(" + ParseExt(Parameters) + ")");
}
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
str.Add(":" + i);
}
return string.Join(",", str);
}
i'm creating a query :
public IEnumerable<T> Execute<T>(string Query, params dynamic Parameters) {
using (var _session = _transactionManager.GetSession()) {
var _cmd = _session.SetQuery(Query, Parameters);
if (Parameters != null) {
_cmd.SetParameters(Parameters.ToList());
}
return _cmd.List<T>();
}
}
throws the following error :
Remember that ordinal parameters are 1-based!
NOTE : i tried to change the index to start from 1
c# nhibernate
c# nhibernate
asked Nov 20 '18 at 16:04
buffbuff
132111
asked Nov 20 '18 at 16:04
buffbuff
132111
asked Nov 20 '18 at 16:04
buffbuff
132111
asked Nov 20 '18 at 16:04
buffbuff
132111
asked Nov 20 '18 at 16:04
buffbuff
132111
132111
@dasblinkenlightselect * from dbo.OctoGetProducts
– buff
Nov 20 '18 at 16:48
@dasblinkenlight its added after and parsed as follow :select * from dbo.OctoGetProducts(:0,:1,:2,:3,:4,:5,:6,:7)
– buff
Nov 20 '18 at 17:13
add a comment |
@dasblinkenlightselect * from dbo.OctoGetProducts
– buff
Nov 20 '18 at 16:48
@dasblinkenlight its added after and parsed as follow :select * from dbo.OctoGetProducts(:0,:1,:2,:3,:4,:5,:6,:7)
– buff
Nov 20 '18 at 17:13
@dasblinkenlight
select * from dbo.OctoGetProducts– buff
Nov 20 '18 at 16:48
@dasblinkenlight
select * from dbo.OctoGetProducts– buff
Nov 20 '18 at 16:48
@dasblinkenlight its added after and parsed as follow :
select * from dbo.OctoGetProducts(:0,:1,:2,:3,:4,:5,:6,:7)– buff
Nov 20 '18 at 17:13
@dasblinkenlight its added after and parsed as follow :
select * from dbo.OctoGetProducts(:0,:1,:2,:3,:4,:5,:6,:7)– buff
Nov 20 '18 at 17:13
add a comment |
1 Answer
1
active
oldest
votes
0
The symbol for position-parameter is not :xxx but ?.
This change will work
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
//str.Add(":" + i);
str.Add("?"); // + i);
}
return string.Join(",", str);
}
answered Nov 21 '18 at 8:31
Radim KöhlerRadim Köhler
106k31202271
add a comment |
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%2f53396982%2fc-sharp-nhibernate-create-query-with-dynamic-parameters%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
The symbol for position-parameter is not :xxx but ?.
This change will work
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
//str.Add(":" + i);
str.Add("?"); // + i);
}
return string.Join(",", str);
}
answered Nov 21 '18 at 8:31
Radim KöhlerRadim Köhler
106k31202271
add a comment |
0
The symbol for position-parameter is not :xxx but ?.
This change will work
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
//str.Add(":" + i);
str.Add("?"); // + i);
}
return string.Join(",", str);
}
answered Nov 21 '18 at 8:31
Radim KöhlerRadim Köhler
106k31202271
add a comment |
0
0
0
The symbol for position-parameter is not :xxx but ?.
This change will work
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
//str.Add(":" + i);
str.Add("?"); // + i);
}
return string.Join(",", str);
}
answered Nov 21 '18 at 8:31
Radim KöhlerRadim Köhler
106k31202271
The symbol for position-parameter is not :xxx but ?.
This change will work
private static string ParseExt(object Parameters) {
var str = new List<string>();
for (int i = 0; i < Parameters.Length; i++) {
//str.Add(":" + i);
str.Add("?"); // + i);
}
return string.Join(",", str);
}
answered Nov 21 '18 at 8:31
Radim KöhlerRadim Köhler
106k31202271
answered Nov 21 '18 at 8:31
Radim KöhlerRadim Köhler
106k31202271
answered Nov 21 '18 at 8:31
Radim KöhlerRadim Köhler
106k31202271
answered Nov 21 '18 at 8:31
Radim KöhlerRadim Köhler
106k31202271
106k31202271
add a comment |
add a comment |
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%2f53396982%2fc-sharp-nhibernate-create-query-with-dynamic-parameters%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
@dasblinkenlight
select * from dbo.OctoGetProducts– buff
Nov 20 '18 at 16:48
@dasblinkenlight its added after and parsed as follow :
select * from dbo.OctoGetProducts(:0,:1,:2,:3,:4,:5,:6,:7)– buff
Nov 20 '18 at 17:13