Posts by Mr. Mister • 378 points
18 posts
-
1
votes1
answer231
viewsA: Select Scale in PL/SQL - Oracle SQL Developer
For the cases of the above examples, I declare a variable using define, declare doesn’t work. Also, to be able to work with the variable in a select I should add && in front of the variable…
-
0
votes1
answer231
viewsQ: Select Scale in PL/SQL - Oracle SQL Developer
I come from a background of T-SQL (MS SQL Server) and have things that do not work equally in PL/SQL. I would like to know how to select scalars in PL/SQL. Examples in MS SQL Server Example 1:…
-
0
votes4
answers2146
viewsQ: SQL - Draw random lines
Given the table as an example: I want to draw, between the lines with the same order number, a single line, that is, one of order 1, one of order 2 and one of order 3, randomly. I need a generic…
-
2
votes2
answers308
viewsA: ASP.Net - Make Page.Uiculture return culture in "en-BR" format
I found a solution: Thread.CurrentThread.CurrentUICulture.Name This property returns me the language code in the format I want.
-
2
votes2
answers308
viewsQ: ASP.Net - Make Page.Uiculture return culture in "en-BR" format
Was defined in the Web.config globalization: <globalization requestEncoding="utf-8" responseEncoding="utf-8" culture="pt-BR" uiCulture="pt-BR"/> However, when I read the Page.UICulture get…
-
0
votes1
answer75
viewsQ: EF 6 - Migrations does not reflect changes in entities
I changed my entities and I turned the command Update-Database -Verbose -Script only to see in SQL what changes would be made. Generated the legal script with all changes. I closed the script window…
-
2
votes1
answer325
viewsA: Entity Framework 6 - Migrations - Add c column/ default value and name Constraint
Searching a little I found that EF6 does not support default constraints with custom names via Fluent API. But EF Core does!!! Diego Vega (Program Manager, Entity Framework) commented May 5, 2015…
-
1
votes1
answer325
viewsQ: Entity Framework 6 - Migrations - Add c column/ default value and name Constraint
I want to add a column like BIT to an existing table with a default value 1 via Migrations. The challenge is...we have in the company a standard for the name of constraints and it is not legal the…
-
3
votes1
answer1315
viewsQ: SQL - scope_identity() for INSERT SELECT
There is something similar to scope_identity() to return the ids created by giving a insert on the basis of a select? (insert of more than one line simultaneously). OBS: scope_identity() only one of…
-
1
votes1
answer545
viewsQ: ASP.NET - Access Dropdownlist item attribute in Code Behind
I have a DropDownList in which I add items as below: var item= new ListItem("Texto do Item", "Valor do Item"); item.Attributes.Add("NomeAtributo", "ValorAtributo"); The DropDownList is rendered on…
-
1
votes1
answer174
viewsA: ASP.NET - . aspx does not receive fields from the form post cross Omain
I found the problem. Pages . aspx are based on the "name" attribute to get the field value. So: <input type="text" id="meucampo" value="oi"/> If I give Ubmit this and in my . aspx look for:…
-
1
votes1
answer174
viewsQ: ASP.NET - . aspx does not receive fields from the form post cross Omain
I have a form template that I want the customer to use to paste on your page. The form points to a. aspx page on my server. At the Page_load event in mine. aspx I want to get the fields filled form…
-
3
votes1
answer69
viewsQ: How to identify the Entity that throws the error when saving?
In my application, with Entity Framework, I make a query in a Round entity: var lista = contexto.Rodada.Where(condições); Then I’ll go over that list with a foreach. During iteration "updates" and…
-
0
votes2
answers1210
viewsA: Query between two sqlite tables
Hi @Eloi, Try it this way: Select Produtos.Idprod , Produtos.Descricao From Produtos INNER JOIN Pedidos on Produtos.Idprod = Pedidos.Idprod Where Pedidos.IdCliente = 'id do cliente' The way you…
sqliteanswered Mr. Mister 378 -
3
votes3
answers1531
viewsA: Validate field after typing in ASP.NET MVC
You can use Partial View of ASP.Net MVC and Jquery Ajax. In your Controller create a method that returns a Partialview: public PartialViewResult CheckNickname(string nickname) { if…
-
3
votes1
answer447
viewsQ: How to keep MVC application running on IIS express (in Visual Studio) after debugging?
I’m doing a project on ASP.Net MVC. On the company machine I run the project once (F5), stop the debug and continue accessing the application pages normally. On my personal machine if I stop the…
-
1
votes0
answers329
viewsQ: Many-to-Many Relationship Entity Framework Code First Composite Primary Keys Repeat Column
in my application I have two entities with a relationship of many to many, namely, Activity and Skill: The EF (Code First) generates for me the junction table, but it is giving conflict if I create…
-
0
votes1
answer172
viewsQ: Is it right to create a viewmodel for registration (post) and another for consultation (get) of a User entity?
I am taking my first steps in Web API. I created a Viewmodel of the User entity, I will use it for user registration. Now, when returning the data, it has fields, like the password, which I don’t…