Yukai technical blog recommends random indexing)

After a few years of blog writing, the middle part of my blog writing has been stopped, and some of the content has been written. In order to prevent the valuable stuff from sinking into the sea, I have made this index. Enjoy it.

 

ASP. NET Website optimization Series
ASP. NET Website optimization series database Optimization

ASP. NET Website optimization series database optimization table sharding

ASP. NET Website optimization database optimization measures INDEX OPTIMIZATION

ASP. NET Website optimization database optimization measures use master/Slave databases (on)

ASP. NET Website optimization database optimization measures use master/Slave databases (below)

ASP. NET Website performance optimization (top) buffer write data

 

New Features of ASP. NET 4.0

One of ASP. NET 4.0 new feature series starts with page tag <%>

ASP. NET 4.0 new features use custom outputcache provider

ASP. NET 4.0 Seo enhancement 1: Use metadegion, metakeywords, redirectpermanant, etc.

ASP. NET 4.0 Seo enhanced urlrouting

New Features of ASP. NET 4.0, outputs more pure HTML code clientidmode, viewstatemode, etc.

 

C # recommended Essays

C # syntax sugar (CSHARP syntactic sugar) Summary

C #4.0 new dynamic, optional parameters, and naming Parameters

C # checked unchecked keyword. Remember to use the two of them when necessary.

 

SQL Server 2005 Series

SQL Server insert execution secrets (Top, bottom)

SQL server2005 cross apply for T-SQL Enhancement

SQL Server partition Drill

SQL server2005 enhanced T-SQL GENERAL TABLE expression CTE

SQL server2005 top enhancement to T-SQL

SQL server2005 ranking function for enhanced T-SQL

The SQL Table value function splitids implemented by CLR

SQL server2005 enhanced T-SQL by using the over keyword after the Aggregate Function

Ms SQL Server database partition for high performance website construction

 

Notes on writing:

How to insert, modify, and delete data using LINQ to SQL

Use LINQ to SQL for simple queries

Use deferredloadingenabled in Series 3 of LINQ to SQL, and specify the loading option in dataloadoption.

Use Inner join and outer join

LINQ to SQL Series 5 grouping having

Techniques for optimizing the performance of the LINQ to SQL Series

 

SQLite related recommendations:

SQLite random n rows

Syntax differences between SQLite and SQL Server

SQLite multi-thread lock file write Solution

SQLite program inserts a flag field to obtain a new ID

C # sqlitehelper is similar to sqlhelper class to achieve SQLite Database Access

Use the SQLite database in the Asp.net web program

 

Client CSS + JS + html

JS skills you may not know

CSS skills you may not know

Implementation of the MSN-style popup Prompt window in JS + CSS

JS tips: JS finds comments in HTML, and JS allows the client to store another piece of text

 

. Net XML

1. Read and Write XML documents through xmldocument

2. Read XML using xmlreader and write XML using xmlwriter

3. Use LINQ to XML to access XML

4. Use xmlscheme to define a fixed-format XML document

5. XML serialization or deserialization class

6. Search for XML nodes through xpath

7. Convert XML format through XSLT

 

Additional recommendations

Application permission design, ideas, and implementation

High-performance website construction to reduce HTTP connections

Translate some cool. Net skills

Open and Close principles (OCP)

Do you really understand the tags of Web2.0? Can I use it well?

Please respect the work of the author, repost please keep the link to yukai technical blog

Quick technical suggestion

1. ASP. NET Website optimization Series
2. New Features of ASP. NET 4.0
3. C # recommended Essays
4. SQL Server 2005
5. Write-as-you-go
6. SQLite recommendations
7. Client CSS + JS + html
8. Use XML in. net
9. Additional recommendations

After a few years of blog writing, the middle part of my blog writing has been stopped, and some of the content has been written. In order to prevent the valuable stuff from sinking into the sea, I have made this index. Enjoy it.

 

ASP. NET Website optimization Series
ASP. NET Website optimization series database Optimization

ASP. NET Website optimization series database optimization table sharding

ASP. NET Website optimization database optimization measures INDEX OPTIMIZATION

ASP. NET Website optimization database optimization measures use master/Slave databases (on)

ASP. NET Website optimization database optimization measures use master/Slave databases (below)

ASP. NET Website performance optimization (top) buffer write data

 

New Features of ASP. NET 4.0

One of ASP. NET 4.0 new feature series starts with page tag <%>

ASP. NET 4.0 new features use custom outputcache provider

ASP. NET 4.0 Seo enhancement 1: Use metadegion, metakeywords, redirectpermanant, etc.

ASP. NET 4.0 Seo enhanced urlrouting

New Features of ASP. NET 4.0, outputs more pure HTML code clientidmode, viewstatemode, etc.

 

C # recommended Essays

C # syntax sugar (CSHARP syntactic sugar) Summary

C #4.0 new dynamic, optional parameters, and naming Parameters

C # checked unchecked keyword. Remember to use the two of them when necessary.

 

SQL Server 2005 Series

SQL Server insert execution secrets (Top, bottom)

SQL server2005 cross apply for T-SQL Enhancement

SQL Server partition Drill

SQL server2005 enhanced T-SQL GENERAL TABLE expression CTE

SQL server2005 top enhancement to T-SQL

SQL server2005 ranking function for enhanced T-SQL

The SQL Table value function splitids implemented by CLR

SQL server2005 enhanced T-SQL by using the over keyword after the Aggregate Function

Ms SQL Server database partition for high performance website construction

 

Notes on writing:

How to insert, modify, and delete data using LINQ to SQL

Use LINQ to SQL for simple queries

Use deferredloadingenabled in Series 3 of LINQ to SQL, and specify the loading option in dataloadoption.

Use Inner join and outer join

LINQ to SQL Series 5 grouping having

Techniques for optimizing the performance of the LINQ to SQL Series

 

SQLite related recommendations:

SQLite random n rows

Syntax differences between SQLite and SQL Server

SQLite multi-thread lock file write Solution

SQLite program inserts a flag field to obtain a new ID

C # sqlitehelper is similar to sqlhelper class to achieve SQLite Database Access

Use the SQLite database in the Asp.net web program

 

Client CSS + JS + html

JS skills you may not know

CSS skills you may not know

Implementation of the MSN-style popup Prompt window in JS + CSS

JS tips: JS finds comments in HTML, and JS allows the client to store another piece of text

 

. Net XML

1. Read and Write XML documents through xmldocument

2. Read XML using xmlreader and write XML using xmlwriter

3. Use LINQ to XML to access XML

4. Use xmlscheme to define a fixed-format XML document

5. XML serialization or deserialization class

6. Search for XML nodes through xpath

7. Convert XML format through XSLT

 

Additional recommendations

Application permission design, ideas, and implementation

High-performance website construction to reduce HTTP connections

Translate some cool. Net skills

Open and Close principles (OCP)

Do you really understand the tags of Web2.0? Can I use it well?