|
|
jeremyh
jeremyh
 |
|
Stories kicked by jeremyh
|
|
published 1 year, 3 months ago, submitted by
 rstrahl
1 year, 3 months ago west-wind.com — LINQ to SQL is all about returning object from database queries, but sometimes it's actually useful to use good old DataReaders or DataTables - especially in ASP.NET applications that use DataBinding. Entities are objects and databinding requires Reflection which is very slow, compared to a DataReader. Luckily LINQ to SQL provides the abillity to retrieve a Sql Command object that can be used to return an alternate result set. read more...
add a comment
|
category:  Database | Views: 0
| 
|
| tag it
Everyones tags: | Your tags: | |
No tags
|
|
|
|
|
submitted by
 rprouse
1 year, 3 months ago alteridem.net — If you are ever rewriting an MFC/Win32 program in .NET, you need to be aware that you cannot convert directly between a COLORREF value and a .NET Color structure. The byte order is different and will need to be swapped. read more...
add a comment
|
category:  C# | Views: 8
| 
|
tags:
MFC, Win32, SQL, C#, .Net | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
adventurer
1 year, 3 months ago dotnetpulse.blogspot.com — SQLScheduler is a fully functional client/server application written in C# that allows administrators to schedule various SQL jobs for SQL Server Express and other versions of SQL Server.
read more...
add a comment
|
category: Database | Views: 1
| 
|
tags:
SQLExpress, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
rstrahl
1 year, 3 months ago west-wind.com — Several people have been flogging me for my LINQ and disconnected Entity post, so I thought I should follow up on the issues I've been having. First let me restate Entity issue I raised a couple of days ago, but let me present it in a simpler context with the Northwind database, so you can try... read more...
add a comment
|
category:  ADO.NET | Views: 1
| 
|
tags:
ADO.NET, SQL, LINQ | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 pinaldave
1 year, 3 months ago blog.sqlauthority.com — SQL Server 2005 has new datatype of VARCHAR(MAX), we decided to change all our TEXT datatype columns to VARCHAR(MAX). The reason to do that as TEXT datatype will be deprecated in future version of SQL Server and VARCHAR(MAX) is superior to TEXT datatype in features. We run following script to identify all the columns which are TEXT datatype and developer converts them to VARCHAR(MAX) ...see the script here read more...
add a comment
|
category: Database | Views: 0
| 
|
tags:
text, max, varchar, SQL, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
vermdivya
1 year, 3 months ago dotnetguts.blogspot.com — SQL Server FAQ Interview Questions
* SQL Queries FAQ
* FAQ on Indexes in SQL
* FAQ on Data Types in SQL Server
* FAQ on Joins in SQL Server
* FAQ on Stored Procedure in SQL Server
* FAQ on Trigger in SQL Server
* FAQ on Lock in SQL Server
* FAQ on View in SQL Server
* FAQ on Transaction in SQL Server
* SQL Server FAQ on Random Category
* FAQ on Tools in SQL Server
* FAQ on Permissions in SQL Server
* FAQ on Administration in SQL Server read more...
add a comment
|
category:  Other | Views: 9
| 
|
tags:
Interview, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 year, 3 months ago, submitted by
vermdivya
1 year, 3 months ago dotnetguts.blogspot.com — Tips and Tricks which should be used while dealing with SQL read more...
| 
|
tags:
Optimization, Tips, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
rstrahl
1 year, 3 months ago west-wind.com — Continuing my experiments with LINQ in the middle tier I ran into another problem: Inability to make LINQ run any dynamic operations that are not defined explicitly in the LINQ to SQL import. For building a generic business framework that doesn't have concrete type references (to say a PK field) but dynamically needs to create SQL to query data. Even relatively simple things like retrieve a single record by primary key where primary key is dynamic not explicit is not easily accomplished without getting real low level into Lambda expression creation. read more...
add a comment
|
category: ADO.NET | Views: 4
| 
|
tags:
SQL, LINQ | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
pinaldave
1 year, 3 months ago blog.sqlauthority.com — I received quite a good feedback about my post about SQL SERVER - Validate Field For DATE datatype using function ISDATE()
One of the most interesting comment I received from my reader from Canada. I was suggested just like ISDATE() to write about ISNUMERIC() which can be used to validate numeric values.
As per BOL:
ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type; otherwise it returns 0. ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($).
Now this is issue with ISNUMERIC() function. It even suggest variable as numeric when it is not. I use following function to validate instead of ISNUMERIC() to validate if number is numeric or not. read more...
add a comment
|
category: Database | Views: 5
| 
|
tags:
Database, SQL | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
rstrahl
1 year, 3 months ago west-wind.com — I have been experimenting with LINQ to SQL in the middle tier and have run into the apparently common issue of re-attaching entities to a DataContext in cross tier scenarios. Either the support re-attachment is not there or it is broken but either way it doesn't work which makes it pretty tough to use LINQ to SQL in the middle tier. read more...
add a comment
|
category: ADO.NET | Views: 0
| 
|
tags:
SQL, LINQ | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|