Browse by Tags
All Tags »
Data Layer Focus »
Tips (
RSS)
I like this recommendation text I attached, about the way we should consider to handle our Dal exception/s because its very clear, simple and convincing. The following attach text is from a one of the architecture guide within the Microsoft architecture...
Here is a the store procedure implementation from "Custom Data Paging in ASP_NET - ASP_NET" article which located on CodeProject Similar code were added to one of the articles I 've just read in MSDN May Magazine. We can use it with a DataGrid custom...
SQL Server provides both datatypes to store character information. For the most part the two datatypes are identical in how you would work with them within SQL Server or from an application. The difference is that nvarchar is used to store unicode data...
Few highlights from ADO.NET advanced webcast I saw last week: In order to optimize your connection instances to your repository its highly recommended to set the connection pooling settings as part of the connection string The value should adjust carefully...
This week I started to experience lots of new stuff. One of them, which was new for me (I apologize for that - this should not happened) and I find it useful, is the work with DB reference in a .NET. DB reference is a DB project template in VS (we use...
When moving DataTables from tier to tier in our application we can use the DataTable ExtendedProperties as custom data holder at the user level or at the application level instead of moving these data in extra parameters. Fields like ReadOnly, timeSpan...
The inputs are: string xml, StreamReader schemaReader schemaReader: hold the XSD document with a stream reader XmlTextReader xmlReader = new XmlTextReader(new System.IO.StringReader(xml)); XmlValidatingReader reader = new XmlValidatingReader(xmlReader...
More Posts