how to use repeated get data from table from one place by using general function take table name or any...
![Multi tool use Multi tool use](http://sgv.ssvwv.com/sg/ssvwvcomimagb.png)
Multi tool use
How to use repeated get data from table from one place by using general function take table name or any solution .
I get data from table reference but there different on table name selected
from this table .
so that i will use same get data statement on more controller
so that to prevent repeated get data i think to
put this on one place by general function or any concept prevent repeated
but i cannot do that .
on controller actione of employeecontroller
var result = await _context.ReferenceFiles.Where(r => r.TableName == "Employees").ToListAsync();
ViewBag.RefList = result;
on controller actione of Itemcontroller
var result = await _context.ReferenceFiles.Where(r => r.TableName == "Items").ToListAsync();
ViewBag.RefList = result;
on view
@foreach (var itemes in ViewBag.RefList)
{
<thead>
@itemes.FieldName
</thead>
}
Table Reference have 3 fields
code
FieldName
TableName
c# asp.net-mvc entity-framework-core asp.net-core-2.1
add a comment |
How to use repeated get data from table from one place by using general function take table name or any solution .
I get data from table reference but there different on table name selected
from this table .
so that i will use same get data statement on more controller
so that to prevent repeated get data i think to
put this on one place by general function or any concept prevent repeated
but i cannot do that .
on controller actione of employeecontroller
var result = await _context.ReferenceFiles.Where(r => r.TableName == "Employees").ToListAsync();
ViewBag.RefList = result;
on controller actione of Itemcontroller
var result = await _context.ReferenceFiles.Where(r => r.TableName == "Items").ToListAsync();
ViewBag.RefList = result;
on view
@foreach (var itemes in ViewBag.RefList)
{
<thead>
@itemes.FieldName
</thead>
}
Table Reference have 3 fields
code
FieldName
TableName
c# asp.net-mvc entity-framework-core asp.net-core-2.1
check out Repository pattern... for example, this document
– Hooman Bahreini
Dec 30 '18 at 2:54
Well, isn't that as simple as adding a parametertableName
to your action method?
– Gert Arnold
Dec 30 '18 at 16:21
add a comment |
How to use repeated get data from table from one place by using general function take table name or any solution .
I get data from table reference but there different on table name selected
from this table .
so that i will use same get data statement on more controller
so that to prevent repeated get data i think to
put this on one place by general function or any concept prevent repeated
but i cannot do that .
on controller actione of employeecontroller
var result = await _context.ReferenceFiles.Where(r => r.TableName == "Employees").ToListAsync();
ViewBag.RefList = result;
on controller actione of Itemcontroller
var result = await _context.ReferenceFiles.Where(r => r.TableName == "Items").ToListAsync();
ViewBag.RefList = result;
on view
@foreach (var itemes in ViewBag.RefList)
{
<thead>
@itemes.FieldName
</thead>
}
Table Reference have 3 fields
code
FieldName
TableName
c# asp.net-mvc entity-framework-core asp.net-core-2.1
How to use repeated get data from table from one place by using general function take table name or any solution .
I get data from table reference but there different on table name selected
from this table .
so that i will use same get data statement on more controller
so that to prevent repeated get data i think to
put this on one place by general function or any concept prevent repeated
but i cannot do that .
on controller actione of employeecontroller
var result = await _context.ReferenceFiles.Where(r => r.TableName == "Employees").ToListAsync();
ViewBag.RefList = result;
on controller actione of Itemcontroller
var result = await _context.ReferenceFiles.Where(r => r.TableName == "Items").ToListAsync();
ViewBag.RefList = result;
on view
@foreach (var itemes in ViewBag.RefList)
{
<thead>
@itemes.FieldName
</thead>
}
Table Reference have 3 fields
code
FieldName
TableName
c# asp.net-mvc entity-framework-core asp.net-core-2.1
c# asp.net-mvc entity-framework-core asp.net-core-2.1
asked Dec 30 '18 at 0:42
![](https://lh4.googleusercontent.com/-aJ0IMOrTZNQ/AAAAAAAAAAI/AAAAAAAAAAA/AAN31DUJy737GPIJTdNVkvR9NCNhVYaNyg/mo/photo.jpg?sz=32)
![](https://lh4.googleusercontent.com/-aJ0IMOrTZNQ/AAAAAAAAAAI/AAAAAAAAAAA/AAN31DUJy737GPIJTdNVkvR9NCNhVYaNyg/mo/photo.jpg?sz=32)
ahmed abedelazizahmed abedelaziz
113
113
check out Repository pattern... for example, this document
– Hooman Bahreini
Dec 30 '18 at 2:54
Well, isn't that as simple as adding a parametertableName
to your action method?
– Gert Arnold
Dec 30 '18 at 16:21
add a comment |
check out Repository pattern... for example, this document
– Hooman Bahreini
Dec 30 '18 at 2:54
Well, isn't that as simple as adding a parametertableName
to your action method?
– Gert Arnold
Dec 30 '18 at 16:21
check out Repository pattern... for example, this document
– Hooman Bahreini
Dec 30 '18 at 2:54
check out Repository pattern... for example, this document
– Hooman Bahreini
Dec 30 '18 at 2:54
Well, isn't that as simple as adding a parameter
tableName
to your action method?– Gert Arnold
Dec 30 '18 at 16:21
Well, isn't that as simple as adding a parameter
tableName
to your action method?– Gert Arnold
Dec 30 '18 at 16:21
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
});
}
});
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%2f53974448%2fhow-to-use-repeated-get-data-from-table-from-one-place-by-using-general-function%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
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.
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%2f53974448%2fhow-to-use-repeated-get-data-from-table-from-one-place-by-using-general-function%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
Pm3MMK 3PeCO3VkvI1Att00FUeP7ad18X ZH9SQ3jP86Zfbj2P
check out Repository pattern... for example, this document
– Hooman Bahreini
Dec 30 '18 at 2:54
Well, isn't that as simple as adding a parameter
tableName
to your action method?– Gert Arnold
Dec 30 '18 at 16:21