Click here to Skip to main content
15,396,859 members

Articles by DiponRoy (Articles: 26, Tip/Tricks: 50)

Articles: 26, Tip/Tricks: 50

RSS Feed

Average article rating: 4.49

Database Development
28 Jul 2014   Updated: 28 Jul 2014   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 15,622     Bookmarked: 15   Downloaded: 35
Please Sign up or sign in to vote.
How to manage Entity Framework Code First in Real Time Projects
13 Aug 2014   Updated: 13 Aug 2014   Rating: 4.36/5    Votes: 12   Popularity: 4.70
Licence: CPOL    Views: 54,875     Bookmarked: 16   Downloaded: 501
Please Sign up or sign in to vote.
Here, we will see how to configure one to zero/one relation between two entities in Entity Framework Code First
3 Jul 2022   Updated: 3 Jul 2022   Rating: 1.00/5    Votes: 2   Popularity: 0.30
Licence: CPOL    Views: 2,420     Bookmarked: 2   Downloaded: 23
Please Sign up or sign in to vote.
Conditional filter query example in SQLAlchemy and Python
5 Jul 2022   Updated: 5 Jul 2022   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: CPOL    Views: 2,470     Bookmarked: 5   Downloaded: 25
Please Sign up or sign in to vote.
Example of Generic Repository Class with SQLAlchemy and Python
PostgreSQL
27 May 2019   Updated: 27 May 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 5,693     Bookmarked: 4   Downloaded: 81
Please Sign up or sign in to vote.
Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases
28 Jun 2022   Updated: 28 Jun 2022   Rating: 4.20/5    Votes: 3   Popularity: 2.00
Licence: CPOL    Views: 3,150     Bookmarked: 7   Downloaded: 62
Please Sign up or sign in to vote.
How to use MERGE statements in different databases
SQL Server
11 Apr 2020   Updated: 11 Apr 2020   Rating: 4.39/5    Votes: 6   Popularity: 3.42
Licence: CPOL    Views: 32,485     Bookmarked: 9   Downloaded: 756
Please Sign up or sign in to vote.
Store all data change history in a table using Entity Framework Core
15 Jul 2019   Updated: 15 Jul 2019   Rating: 4.68/5    Votes: 7   Popularity: 3.96
Licence: CPOL    Views: 8,295     Bookmarked: 19   Downloaded: 205
Please Sign up or sign in to vote.
Conditinal filter query example in SQL, Lambda Expression, C#
15 Sep 2014   Updated: 15 Sep 2014   Rating: 4.86/5    Votes: 49   Popularity: 8.08
Licence: CPOL    Views: 465,510     Bookmarked: 64   Downloaded: 2,173
Please Sign up or sign in to vote.
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
18 Aug 2014   Updated: 18 Aug 2014   Rating: 4.96/5    Votes: 15   Popularity: 5.53
Licence: CPOL    Views: 21,550     Bookmarked: 14   Downloaded: 126
Please Sign up or sign in to vote.
Here, we will see the basic differences or similarities between various joins of MS SQL Server.
4 Mar 2015   Updated: 4 Mar 2015   Rating: 4.83/5    Votes: 5   Popularity: 3.38
Licence: CPOL    Views: 17,953     Bookmarked: 7   Downloaded: 121
Please Sign up or sign in to vote.
Table Hierarchy or Generation Finder For Relational Database In SQL Server
2 Jul 2019   Updated: 2 Jul 2019   Rating: 4.55/5    Votes: 8   Popularity: 4.10
Licence: CPOL    Views: 10,704     Bookmarked: 14   Downloaded: 142
Please Sign up or sign in to vote.
Creating CLR in SQL Server
11 Jul 2019   Updated: 11 Jul 2019   Rating: 3.59/5    Votes: 8   Popularity: 3.24
Licence: CPOL    Views: 7,191     Bookmarked: 17   Downloaded: 132
Please Sign up or sign in to vote.
Populating DateTime range in SQL Server
3 Aug 2022   Updated: 3 Aug 2022   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: CPOL    Views: 1,941     Bookmarked: 4   Downloaded: 21
Please Sign up or sign in to vote.
Options to customize EF Core migration table
9 Aug 2022   Updated: 9 Aug 2022   Rating: 4.43/5    Votes: 5   Popularity: 3.10
Licence: CPOL    Views: 3,450     Bookmarked: 10   Downloaded: 63
Please Sign up or sign in to vote.
Run Raw SQL Query - Entity Framework Core 6
DevOps
Unit Testing
15 Aug 2022   Updated: 15 Aug 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 2,020     Bookmarked: 2   Downloaded: 14
Please Sign up or sign in to vote.
Programming Languages
Basic
2 Aug 2020   Updated: 2 Aug 2020   Rating: 4.27/5    Votes: 5   Popularity: 2.99
Licence: CPOL    Views: 12,533     Bookmarked: 4   Downloaded: 335
Please Sign up or sign in to vote.
Read a large CSV or any character separated values file chunk by chunk as DataTable and Entity List
C#
13 Jul 2014   Updated: 13 Jul 2014   Rating: 4.83/5    Votes: 11   Popularity: 4.83
Licence: CPOL    Views: 50,818     Bookmarked: 16   Downloaded: 454
Please Sign up or sign in to vote.
Log all the parameters passed to some method in C#
7 Jun 2014   Updated: 7 Jun 2014   Rating: 5.00/5    Votes: 10   Popularity: 4.52
Licence: CPOL    Views: 37,940     Bookmarked: 14   Downloaded: 147
Please Sign up or sign in to vote.
Enum with text value in C#
9 Jun 2014   Updated: 9 Jun 2014   Rating: 4.88/5    Votes: 34   Popularity: 7.42
Licence: CPOL    Views: 135,834     Bookmarked: 48   Downloaded: 2,394
Please Sign up or sign in to vote.
Conversion between DataTable and List in C#
17 Jun 2019   Updated: 17 Jun 2019   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 14,542     Bookmarked: 9   Downloaded: 139
Please Sign up or sign in to vote.
Range model class to manage range related operations for a specific data type
29 Jul 2022   Updated: 29 Jul 2022   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 4,440     Bookmarked: 6   Downloaded: 41
Please Sign up or sign in to vote.
Generate and store logs using middleware
Web Development
ASP.NET
30 Jul 2020   Updated: 30 Jul 2020   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 18,367     Bookmarked: 7   Downloaded: 1,060
Please Sign up or sign in to vote.
Making schedule jobs exe using Quartz scheduler
5 Apr 2020   Updated: 5 Apr 2020   Rating: 4.87/5    Votes: 6   Popularity: 3.79
Licence: CPOL    Views: 26,345     Bookmarked: 6   Downloaded: 251
Please Sign up or sign in to vote.
Select data as DataTable object for a database using Entity Framework
HTML
24 Jul 2014   Updated: 24 Jul 2014   Rating: 4.67/5    Votes: 35   Popularity: 7.15
Licence: CPOL    Views: 255,568     Bookmarked: 52   Downloaded: 6,813
Please Sign up or sign in to vote.
Do GET, POST, PUT, DELETE in ASP.NET MVC with Jquery Ajax
16 Jul 2014   Updated: 16 Jul 2014   Rating: 4.50/5    Votes: 11   Popularity: 4.50
Licence: CPOL    Views: 25,721     Bookmarked: 23   Downloaded: 377
Please Sign up or sign in to vote.
Exception log with request detail in ASP.NET MVC

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.49

Containers
Docker
6 Jul 2022   Updated: 6 Jul 2022   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 5,230     Bookmarked: 12   Downloaded: 91
Please Sign up or sign in to vote.
Quick start example to run DB and clients in docker
17 Jul 2022   Updated: 17 Jul 2022   Rating: 3.00/5    Votes: 3   Popularity: 1.43
Licence: CPOL    Views: 2,860     Bookmarked: 4   Downloaded: 40
Please Sign up or sign in to vote.
How to run FTP, SFTP, SMTP, Cache, LDAP, SSO and other servers in Docker
Database Development
19 May 2019   Updated: 19 May 2019   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 8,783     Bookmarked: 5   Downloaded: 70
Please Sign up or sign in to vote.
The aim of this helper class is to divide a large IEnumerable into multiple small list.
PostgreSQL
21 Jul 2019   Updated: 21 Jul 2019   Rating: 4.63/5    Votes: 4   Popularity: 2.78
Licence: CPOL    Views: 6,331     Bookmarked: 1   Downloaded: 41
Please Sign up or sign in to vote.
Select a default row for a query that returns no rows
SQL Server
14 Feb 2019   Updated: 14 Feb 2019   Rating: 4.67/5    Votes: 3   Popularity: 2.23
Licence: CPOL    Views: 23,305     Bookmarked: 9   Downloaded: 104
Please Sign up or sign in to vote.
A utility class to send parameters for IN() operator in SQL using parameterized queries
19 Feb 2019   Updated: 19 Feb 2019   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 17,875     Bookmarked: 7   Downloaded: 57
Please Sign up or sign in to vote.
How to do string split and join in SQL Server
29 May 2019   Updated: 29 May 2019   Rating: 2.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 4,572     Bookmarked: 3   Downloaded: 74
Please Sign up or sign in to vote.
A utility query to find table generations in SQL Server relational database.
10 Jul 2019   Updated: 10 Jul 2019   Rating: 3.68/5    Votes: 7   Popularity: 3.11
Licence: CPOL    Views: 40,378     Bookmarked: 13   Downloaded: 97
Please Sign up or sign in to vote.
Finding week start and end date time from a given date time
30 Jul 2014   Updated: 30 Jul 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 17,280     Bookmarked: 7   Downloaded: 94
Please Sign up or sign in to vote.
How to handle database scheme changes with normal SQL scripts, without migration in Entity Framework code first
28 Dec 2021   Updated: 28 Dec 2021   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: CPOL    Views: 10,350     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Delete all the records from the table using Entity Framework Core
5 Jul 2022   Updated: 5 Jul 2022   Rating: 3.91/5    Votes: 8   Popularity: 3.53
Licence: CPOL    Views: 3,320     Bookmarked: 10   Downloaded: 0
Please Sign up or sign in to vote.
Using CASE with variable/SET, SELECT/UPDATE statement, WHERE clause, JOIN & ON clause
Desktop Programming
8 Feb 2019   Updated: 8 Feb 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 10,353     Bookmarked: 1   Downloaded: 154
Please Sign up or sign in to vote.
Limit number of lines in a RichTextBox
DevOps
Load Testing
11 Jun 2014   Updated: 11 Jun 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 14,770     Bookmarked: 9   Downloaded: 97
Please Sign up or sign in to vote.
Custom Seed Serializer for Entity Framework Code First C#
General Programming
String
26 Jun 2019   Updated: 26 Jun 2019   Rating: 4.75/5    Votes: 4   Popularity: 2.86
Licence: CPOL    Views: 17,712     Bookmarked: 17   Downloaded: 206
Please Sign up or sign in to vote.
Create hash and compare
Productivity Apps and Services
Microsoft Office
5 Apr 2020   Updated: 5 Apr 2020   Rating: 3.19/5    Votes: 5   Popularity: 2.23
Licence: CPOL    Views: 18,041     Bookmarked: 19   Downloaded: 617
Please Sign up or sign in to vote.
Create a file like Excel, CSV, txt, etc. from a DataTable object using C#
Programming Languages
C#
5 Jun 2020   Updated: 5 Jun 2020   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 6,444     Bookmarked: 0   Downloaded: 76
Please Sign up or sign in to vote.
Use same EDMX file with different Oracle database schemas
2 Sep 2014   Updated: 2 Sep 2014   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 45,942     Bookmarked: 16   Downloaded: 381
Please Sign up or sign in to vote.
Let’s see how to make a simple model or Entity mapper using reflections in C#
19 May 2019   Updated: 19 May 2019   Rating: 4.64/5    Votes: 4   Popularity: 2.79
Licence: CPOL    Views: 17,894     Bookmarked: 7   Downloaded: 290
Please Sign up or sign in to vote.
The aim of this helper class is to divide a large datatable into multiple small datatables.
10 Sep 2014   Updated: 10 Sep 2014   Rating: 4.92/5    Votes: 11   Popularity: 5.13
Licence: CPOL    Views: 44,465     Bookmarked: 21   Downloaded: 228
Please Sign up or sign in to vote.
Let's make a lambda expression from a property name of a particular entity, and use it for OrderBy shorting
31 Jul 2019   Updated: 31 Jul 2019   Rating: 2.64/5    Votes: 4   Popularity: 1.59
Licence: CPOL    Views: 6,312     Bookmarked: 3   Downloaded: 88
Please Sign up or sign in to vote.
Calling an API which has a limit of calls per second
2 Jun 2019   Updated: 2 Jun 2019   Rating: 4.80/5    Votes: 7   Popularity: 4.06
Licence: CPOL    Views: 10,811     Bookmarked: 6   Downloaded: 65
Please Sign up or sign in to vote.
Utility class and model to manage range related operations
7 Aug 2022   Updated: 7 Aug 2022   Rating: 3.40/5    Votes: 2   Popularity: 1.02
Licence: CPOL    Views: 2,020     Bookmarked: 3   Downloaded: 10
Please Sign up or sign in to vote.
EF Core first publishing multiple DB contexts in same DB
Javascript
28 May 2014   Updated: 28 May 2014   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 12,331     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
This is a simple inheritance example in JavaScript
8 Jul 2014   Updated: 10 Jul 2014   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 10,100     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
How to change the functionality or behavior of a function in JavaScript
Python
7 Jul 2022   Updated: 7 Jul 2022   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 2,680     Bookmarked: 4   Downloaded: 23
Please Sign up or sign in to vote.
This example is to partially update data in FastAPI using SQLAlchemy and Python
SQL
23 Sep 2014   Updated: 23 Sep 2014   Rating: 4.73/5    Votes: 12   Popularity: 5.10
Licence: CPOL    Views: 70,824     Bookmarked: 12   Downloaded: 286
Please Sign up or sign in to vote.
Here we will see how to use PIVOT and JOIN together in SQL query
18 Feb 2019   Updated: 18 Feb 2019   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: CPOL    Views: 24,207     Bookmarked: 9   Downloaded: 89
Please Sign up or sign in to vote.
Selecting single row from a group of rows
Security
Identity
4 Jul 2022   Updated: 4 Jul 2022   Rating: 3.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 2,920     Bookmarked: 2   Downloaded: 20
Please Sign up or sign in to vote.
How to auto increment column options in databases
Web Development
ASP.NET
8 Feb 2019   Updated: 8 Feb 2019   Rating: 4.89/5    Votes: 2   Popularity: 1.47
Licence: CPOL    Views: 10,665     Bookmarked: 1   Downloaded: 53
Please Sign up or sign in to vote.
Configure JSON serialization settings
13 Jul 2020   Updated: 13 Jul 2020   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 23,460     Bookmarked: 10   Downloaded: 735
Please Sign up or sign in to vote.
Using SFTP/FTP in ASP.NET CORE projects
15 Jul 2020   Updated: 15 Jul 2020   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: CPOL    Views: 22,114     Bookmarked: 11   Downloaded: 445
Please Sign up or sign in to vote.
Username and password validation process from LDAP server in ASP.NET and ASP.NET Core
20 Jul 2020   Updated: 20 Jul 2020   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: CPOL    Views: 8,232     Bookmarked: 5   Downloaded: 266
Please Sign up or sign in to vote.
Using SFTP/FTP in ASP.NET projects
6 Jul 2014   Updated: 6 Jul 2014   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 27,285     Bookmarked: 17   Downloaded: 354
Please Sign up or sign in to vote.
Session Manager Utility for ASP.NET
13 Jul 2020   Updated: 13 Jul 2020   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 65,520     Bookmarked: 6   Downloaded: 448
Please Sign up or sign in to vote.
Deploy Web API and Angular from the same project to the same IIS port
14 Jun 2020   Updated: 14 Jun 2020   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 5,123     Bookmarked: 1   Downloaded: 109
Please Sign up or sign in to vote.
Upgrade a legacy ASP.NET project to use managed Oracle.ManagedDataAccess.Client instead of unmanaged Oracle.DataAccess.Client while using Entity Framework DB first or EDMX.
18 Jul 2022   Updated: 18 Jul 2022   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 3,550     Bookmarked: 10   Downloaded: 31
Please Sign up or sign in to vote.
Add execution time as a response header in ASP.NET Core
22 Jul 2022   Updated: 22 Jul 2022   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 4,850     Bookmarked: 7   Downloaded: 36
Please Sign up or sign in to vote.
Set a generated unique id to HttpContext.TraceIdentifier using middleware
26 Jul 2022   Updated: 26 Jul 2022   Rating: 5.00/5    Votes: 6   Popularity: 3.89
Licence: CPOL    Views: 7,240     Bookmarked: 9   Downloaded: 70
Please Sign up or sign in to vote.
Conversion of complex object to a list of objects
HTML
27 Jun 2014   Updated: 27 Jun 2014   Rating: 4.78/5    Votes: 28   Popularity: 6.76
Licence: CPOL    Views: 173,575     Bookmarked: 30   Downloaded: 2,847
Please Sign up or sign in to vote.
Session in ASP.NET MVC
13 Jul 2014   Updated: 13 Jul 2014   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 23,533     Bookmarked: 8   Downloaded: 219
Please Sign up or sign in to vote.
Knockout Validation Error Message & Bootstrap v3.2 input-group
16 Jul 2014   Updated: 16 Jul 2014   Rating: 4.20/5    Votes: 2   Popularity: 1.26
Licence: CPOL    Views: 27,016     Bookmarked: 3   Downloaded: 34
Please Sign up or sign in to vote.
Using $index in Knockout.js
30 May 2014   Updated: 30 May 2014   Rating: 4.82/5    Votes: 5   Popularity: 3.37
Licence: CPOL    Views: 50,954     Bookmarked: 8   Downloaded: 1,211
Please Sign up or sign in to vote.
Bootstrap datepicker and Knockout Model Binding
1 Jun 2014   Updated: 12 Jun 2014   Rating: 4.86/5    Votes: 4   Popularity: 2.92
Licence: CPOL    Views: 21,090     Bookmarked: 3   Downloaded: 39
Please Sign up or sign in to vote.
Trimmed value binding in knockout.js
3 Jul 2014   Updated: 3 Jul 2014   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 14,781     Bookmarked: 6   Downloaded: 126
Please Sign up or sign in to vote.
How to use Ajax validation in Knockout
4 Jul 2014   Updated: 4 Jul 2014   Rating: 4.64/5    Votes: 4   Popularity: 2.79
Licence: CPOL    Views: 15,853     Bookmarked: 6   Downloaded: 111
Please Sign up or sign in to vote.
Using Observable and Computed for validation in Knockout
21 Jul 2014   Updated: 22 Jul 2014   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: CPOL    Views: 9,730     Bookmarked: 3   Downloaded: 41
Please Sign up or sign in to vote.
How to post rowversion or timestamp of MsSQL using jquery
11 Jul 2014   Updated: 11 Jul 2014   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: CPOL    Views: 23,587     Bookmarked: 3   Downloaded: 57
Please Sign up or sign in to vote.
How to use trimming during object to JSON string serialization in JavaScript
13 Jul 2014   Updated: 13 Jul 2014   Rating: 4.22/5    Votes: 7   Popularity: 3.57
Licence: CPOL    Views: 12,970     Bookmarked: 8   Downloaded: 76
Please Sign up or sign in to vote.
Simple response object for ASP.NET
HTML5
15 Jun 2014   Updated: 15 Jun 2014   Rating: 4.67/5    Votes: 2   Popularity: 1.40
Licence: CPOL    Views: 30,244     Bookmarked: 8   Downloaded: 313
Please Sign up or sign in to vote.
Knockout Data-binding to Table with rowspan
IIS
29 Jan 2015   Updated: 29 Jan 2015   Rating: 4.93/5    Votes: 6   Popularity: 3.84
Licence: CPOL    Views: 86,881     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
How to restore IIS setups to its default, without uninstalling or repairing Windows

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
DiponRoy
Bangladesh Bangladesh
No Biography provided