python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - sql-view

Scaffold-DbContext SQL database Views ? ASP NET CORE 6

I am new to .Net Core and I'd like to know scaffold EF support sql view like it supports sql table in .Net Core 6? If it supports which command will do? For tables,Scaffold-DbContext and is it same c...
test-img

JewelJJ

entity-framework

sql-view

asp.net-mvc-scaffolding

asp.net-core-6.0

Votes: 0

Answers: 2

Latest Answer

Scaffold-DbContext will scaffold both tables and views
test-img

ErikEJ

Question on best practice for creating views that are consumed by visualization tools like PowerBI or Tableau

I've tried searching around to see what the best practices are when designing a view that will be used for visualization going directly into PowerBI or Tableau. I don't know the best way to ask this b...
test-img

Kerry

sql

database

data-visualization

snowflake-cloud-data-platform

sql-view

Votes: 0

Answers: 1

Latest Answer

Wherever possible, you should be using the underlying database to do the work that databases are good at i.e. selecting/filtering/aggregating data. So your BI tools should be querying those tables rat...
test-img

NickW

Select with "default" value and specific overwrite value

maybe a silly question .. i would have to like one SQL table containing rows which should be used as default, and then rows for specific values .. example table A: ID; Filter; Class; Value 1 ; % ;...
test-img

Harald B.

sql

select

sql-view

Votes: 0

Answers: 0

List all table origin columns for all views in Oracle database

Let's assume I have following tables: TABLE_A (ID; NAME; ...) TABLE_B (ID; NAME; TABLE_A_FK; ...) And I expose the table data through this view: SELECT a.id, a.name, b.name FROM TABLE_A a JOIN TABLE_...
test-img

Higune

sql

oracle

view

sql-view

Votes: 0

Answers: 2

Latest Answer

you can use this query to get the column and table name select c.table_name, c.column_name, c.column_id from sys.all_tab_columns c inner join sys.all_views v on c.owner = v.owne...
test-img

Himanshu Kandpal

Posts

Questions

Blogs

Jobs