15,946,342 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
The default search term operator is
OR
for a simple list of search terms.
Any selected filters such as document type, tags, categories, etc. are ANDed to the query in the search box.
You can use brackets,
AND
,
OR
, and
NOT
to improve your search. For example:
C# AND NOT(VB or SQL)
A query of a single
*
will return everything, filtered by any filters.
Filter examples:
Search by Author
author:"author name"
Filter by tag
tag:C#
or
tag:(C++ or Java)
Wildcard search
use "?" or "*" eg.
gr?d
or
gr*
2,428 Results
Filters
Articles
Technical Blogs
Tips & Tricks
Reference Articles
Projects
Assets
Questions
Answers
Forum Messages
News Items
Just My Stuff
My Bookmarks
Sort by
Relevance
Rating (Hi - Lo)
Rating (Lo - Hi)
Popularity (Hi - Lo)
Popularity (Lo - Hi)
Votes (Hi - Lo)
Votes (Lo - Hi)
Modified (New - Old)
Modified (Old - New)
Thread Modified (New - Old)
Thread Modified (Old - New)
Created (New - Old)
Created (Old - New)
Title (A - Z)
Title (Z - A)
Author (A - Z)
Author (Z - A)
Match
All Fields
Title
Description
Author(s)
Tags
Any Date
Last 12 hours
Last 24 hours
Last week
Last 2 weeks
Last month
Last 3 months
Last 6 months
Last year
January
February
March
April
May
June
July
August
September
October
November
December
Rating Range
All - Including Unrated
1.0 - 5.0
2.0 - 5.0
3.0 - 5.0
4.0 - 5.0
4.5 - 5.0
4.8 - 5.0
5.0
More Filters
Article Topics
All Topics
Artificial Intelligence
Internet of Things
DevOps
Containers
High Performance Computing
Hosted Services
Security
Web Development
Mobile Apps
Desktop Programming
Database Development
Productivity Apps and Services
Game Development
Multimedia
General Programming
Programming Languages
Article License
All Licenses
Ms-RL
Custom
CPOL
CDDL
Ms-PL
MPL
CPL
Eclipse
MIT
BSD
Apache
CC (ASA 2.5)
Zlib
Public Domain
CC (Attr 3U)
CC (ASA 3U)
CC (BY-ND 3.0)
LGPL3
GPL3
Forums
All Forums
Feature Forums
General Programming
Web Development
Mobile Development
Product Lifecycle
Database & SysAdmin
General Discussions
Page 1 of 243
Page Size:
10
·
25
·
50
Tag filtered by: DBA
❌
Using IDistributed Cache with EF Core
Please
Sign up or sign in
to vote.
10 Jul 2024
by
Bert O Neill
license:
CPOL
In this article, I provide a detailed overview of using IDistributed Cache to improve the performance of your EF Core queries, against On-Premise caching systems like Redis, NCache, SqlCache, MySqlCache, MongoDBCache and API Output caching.
Database Development
»
Redis
C#
SQL-Server
MySQL
MongoDB
Redis
Small function to replace characters with SQL Server
Please
Sign up or sign in
to vote.
13 May 2024
by
Wendelius
license:
CPOL
A small function utilizing CTE to replace undesired characters from a string
Programming Languages
»
Sql
SQL
SQL Table Dependency Diagram Generator (SSMS 18,19 & 20)
Please
Sign up or sign in
to vote.
29 Apr 2024
by
Bert O Neill
license:
CPOL
This article provides an overview for developers, on how to quickly generate a dependency Entity Relationship Diagram for a table and its immediately related tables, within SQL Server.
Database Development
»
Sql Server
SQL-Server
data
reporting
SSMS
Data-modeling
Automatic Missing Indexes Creation Statements
Please
Sign up or sign in
to vote.
30 Mar 2024
by
GabrieleTronchin
license:
Public Domain
Automatic creation of non clustered indexes using system SQL entities
Database Development
»
Sql Server
SQL
Windows
SQL-Server
DbSharpApplication (DAL Generator Tool on .
NET6, and released new version on .
NET8)
Please
Sign up or sign in
to vote.
17 Feb 2024
by
Higty
license:
CPOL
A DAL generator that generates StoredProcedure client class and creates Table and Record classes
Programming Languages
»
Sql
C#
SQL
ORM
CRUD
VS2022
IoT System for Data Acquisition with REDIS and GO Language
Please
Sign up or sign in
to vote.
30 Jan 2024
by
José Cintra
license:
CPOL
IoT architecture proposal for sensor data acquisition modules using the REDIS database and the GO language
Internet of Things
»
Arduino
Linux
Arduino
DevOps
Redis
Go
Writing a Lexical Analyzer for SQL in C#
Please
Sign up or sign in
to vote.
11 Jan 2024
by
Nicolas DESCARTES
license:
CPOL
How to write a lexical analyzer for SQL?
Programming Languages
»
Sql
C#
SQL
lexical
POCO Generator
Please
Sign up or sign in
to vote.
7 Jan 2024
by
yuvalsol
license:
CPOL
POCO generating application for SQL Server
Database Development
»
Sql Server
C#
SQL
.NET
SQL-Server
Visual Studio - Auto Generate SQL Server Table Dependency Diagram - User Guide
Please
Sign up or sign in
to vote.
30 Dec 2023
by
Bert O Neill
license:
CPOL
Visual Studio extension that auto-generates SQL Server ER diagrams based on a single table
Erd
Visual-Studio
ERD
How to Save Object Graph in Master-Detail Relationship with One Stored Procedure
Please
Sign up or sign in
to vote.
26 May 2023
by
Vadim Loboda
license:
CPOL
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
Database Development
C#
SQL
database
Page 1 of 243
1
2
3
4
5
6
7
8
9
10
First
·
Prev
·
Next
·
Last
Submit an article or tip