misbaharefin

Stories submitted by misbaharefin

Don't Use SELECT *(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 3 years, 10 months ago

I've seen many developers actually using and abusing SELECT * FROM queries. SELECT * query not only returns unnecessary data, but it also can force clustered index scans for query plans because columns in the SELECT clause are also considered by the optimizer when it identifies indexes for execution plans. read more...

1 comment |category: |Views: 370

tags: another

Difference between LINQ to SQL and the Entity Framework(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 3 years, 10 months ago

LINQ to SQL and the Entity Framework have a lot in common, but each have features targeting different scenarios. read more...

add a comment |category: |Views: 489

tags: another

Dependency Injection: Factory vs Container - Unity(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 3 years, 10 months ago

As application size and complexity increase it becomes more and more difficult to reuse existing components and integrating these components to form an interconnected architecture because of the dependencies of the components. One way to reduce dependencies is by using Dependency Injection, which allows you to inject objects into a class, rather than relying on the class to create the object itself. read more...

add a comment |category: |Views: 223

tags: another

Preventing SQL injection attacks in ASP.NET(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 3 years, 11 months ago

SQL injection can occur when an application uses input to construct dynamic SQL statements or when it uses stored procedures to connect to the database. Conventional security measures, such as the use of SSL and IPSec, do not protect your application from SQL injection attacks. Successful SQL injection attacks enable malicious users to execute commands in an application's database. You should always be reviewing your code to find these or other security vulnerabilities; remember all type of attacks start with some input, and your first line of defense should be input validation using both client-side and server-side validation. read more...

add a comment |category: |Views: 19

tags: another

Create AJAX Validator Control(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

Imagine that you are creating a website registration form and you need to validate a Login ID or Email field. You want to make sure that the Login ID or Email entered does not already exist in the database... read more...

add a comment |category: |Views: 53

tags: another

Using Validation Application Block in ASP.NET(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

Any web page which requires input from the user simply cant allow just any data to be entered because the data might be too long, missing or incorrect. We need to validate the data entered by the users in a number of ways; for example, First Name and Last Name might be required fields and Date of Birth cannot be greater than the current date etc. We can very well use the client side validators provided by ASP.NET like RequiredFieldValidator, CompareValidator or RegularExpressionValidtor but is that really enough? What if JavaScript is disabled by the client? What if we need to validate our business objects? It is often important to validate data several times within the same application. For example, you may need to validate object instances that you: -Generate in separate tiers or components of your application -Retrieve from a cache, a repository, or a third-party data access layer -Receive from a Web Service as an object instance or a set of property values -Reconstruct from existing values, perhaps populating them by copying properties from a similar object or using values retrieved from a database Enter the Enterprise Library with its Validation Application Block. read more...

add a comment |category: |Views: 49

tags: another

Enterprise Library 4.0 - Just Released(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

Congratulations to the Enterprise Library Team for their release of Enterprise Library 4.0. A few enhancements and bug fixes in this release, but most importantly it comes with Unity IoC Integration. read more...

add a comment |category: |Views: 26

tags: another

Blog Interesting - 32 Ways to Keep Your Blog from Sucking (hanselman.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

What makes a blog, technical or otherwise, suck less. read more...

2 comments |category: |Views: 36

tags: another

Conditional INNER Joins(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

Recently on a newsgroup I found a question about conditional joins in TSQL. The OP was trying to get rid of dynamic SQL and was looking for a way to change the following example script... read more...

add a comment |category: |Views: 20

tags: another

Exception Handling - Do's and Dont's(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

Exceptions provide a consistent mechanism for identifying and responding to error conditions. Effective exception handling will make code more robust and easier to debug. Exceptions are a tremendous debugging aid because they help answer... read more...

add a comment |category: |Views: 71

tags: another

Table-Value Parameters in SQL Server 2008(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

One of the cool new data types added in SQL Server 2008 is Table-Value Parameters. You can use table value parameters to send multiple rows of data to a Transact-SQL statement, or to a routine such as a stored procedure or function. This can be done without creating a temporary table or many parameters. Table-value parameters are like parameter arrays in Object Linking and Embedding Database (OLE DB) and Open Database Connectivity (ODBC), but offer better flexibility and closer integration with Transact-SQL. Table-value parameters can participate in set-based operations. read more...

add a comment |category: |Views: 29

tags: another

GOTCHA - LINQtoSQL Paging Problem(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

A quick search for how to display paged records in ASP.NET will yield a ton of links and how to's ranging from as simple as automatic paging with the grid controls to custom paging and server side paging in SQL Server, but what about paging in LINQ? read more...

add a comment |category: |Views: 21

tags: another

CA1816 - Dispose Pattern(dotnethitman.spaces.live.com)

submitted by misbaharefinmisbaharefin(845) 4 years ago

Warning CA1816 : Microsoft.Usage : Change 'xxx.Dispose()' to call 'GC.SuppressFinalize(object)'. This will prevent unnecessary finalization of the object once it has been disposed and it has fallen out of scope. read more...

add a comment |category: |Views: 41

tags: another