Tech-Today
As the title implies we will try to convert a native sql that group and counts the number of row. We will assume that you have a column quantity or number of items.
- Hibernate - Get Classes That Referenced A Given Entity
There are times when we want to list the entities that referenced (via foreign keys) a given entity x. For example, when deleting entity x that is being referenced, it will throw a generic ConstraintViolationException. Oftentimes, we need to display this...
- Hibernate Search Faceting
With the document available from Hibernate Search (https://docs.jboss.org/hibernate/stable/search/reference/en-US/html_single/#query-faceting), we should be able to implement a faceting example that returns the faceting field and its count. In the example...
- Mvc3 Dynamic Search Paging Using Pagedlist
Basically there's a great tutorial from this site: Unboxed solutions. -I've copied the codes and add some comments. I'll just try to add my own comments. 1.) First you need to install PagedList.Mvc from Nuget. a.) Go to Tools->Library Package...
- Mssql How To Update A Column Base On A Row Number
Just recently I was asked to normalized or divide a table into 2 tables. Unfortunately, the only column that linked them (email) allows multiple same values, even aggregate would not do (email, password, etc). This is because there's a field that...
- How To Add A Customize Product Admin Fields In Zencart By Editing/adding Extra Codes
Problem: How to add a product custom field named length. This to consider (modifications in): 1.) database 2.) scripts ----------------------------------- 1.) Database - a custom column should be add to the products table. Execute this line (for column...
Tech-Today
How to execute select count(*), field from table group by field in entity framework
As the title implies we will try to convert a native sql that group and counts the number of row. We will assume that you have a column quantity or number of items.
//native query
select count(*), field
from table
group by field
//entity framework
var query = model.GroupBy(p => p.Field).Select(o => new { o.Key, Count = o.Sum(p => p.Quantity) });
- Hibernate - Get Classes That Referenced A Given Entity
There are times when we want to list the entities that referenced (via foreign keys) a given entity x. For example, when deleting entity x that is being referenced, it will throw a generic ConstraintViolationException. Oftentimes, we need to display this...
- Hibernate Search Faceting
With the document available from Hibernate Search (https://docs.jboss.org/hibernate/stable/search/reference/en-US/html_single/#query-faceting), we should be able to implement a faceting example that returns the faceting field and its count. In the example...
- Mvc3 Dynamic Search Paging Using Pagedlist
Basically there's a great tutorial from this site: Unboxed solutions. -I've copied the codes and add some comments. I'll just try to add my own comments. 1.) First you need to install PagedList.Mvc from Nuget. a.) Go to Tools->Library Package...
- Mssql How To Update A Column Base On A Row Number
Just recently I was asked to normalized or divide a table into 2 tables. Unfortunately, the only column that linked them (email) allows multiple same values, even aggregate would not do (email, password, etc). This is because there's a field that...
- How To Add A Customize Product Admin Fields In Zencart By Editing/adding Extra Codes
Problem: How to add a product custom field named length. This to consider (modifications in): 1.) database 2.) scripts ----------------------------------- 1.) Database - a custom column should be add to the products table. Execute this line (for column...