Click here to Skip to main content
15,949,741 members

Articles by DiponRoy (Articles: 27, Tip/Tricks: 51)

Articles: 27, Tip/Tricks: 51

RSS Feed

Average article rating: 4.50

Database Development
28 Jul 2014   Updated: 28 Jul 2014   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: CPOL    Views: 18,447     Bookmarked: 16   Downloaded: 43
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: 63,326     Bookmarked: 16   Downloaded: 505
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.67/5    Votes: 3   Popularity: 0.80
Licence: CPOL    Views: 17,040     Bookmarked: 2   Downloaded: 49
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.27/5    Votes: 5   Popularity: 2.99
Licence: CPOL    Views: 13,541     Bookmarked: 7   Downloaded: 137
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: 8,443     Bookmarked: 4   Downloaded: 87
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: 6,241     Bookmarked: 10   Downloaded: 86
Please Sign up or sign in to vote.
How to use MERGE statements in different databases
SQL Server
15 Jul 2019   Updated: 15 Jul 2019   Rating: 4.68/5    Votes: 7   Popularity: 3.96
Licence: CPOL    Views: 10,386     Bookmarked: 20   Downloaded: 221
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: 50   Popularity: 8.08
Licence: CPOL    Views: 511,978     Bookmarked: 64   Downloaded: 2,225
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: 26,033     Bookmarked: 15   Downloaded: 131
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: 20,657     Bookmarked: 7   Downloaded: 129
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: 14,659     Bookmarked: 14   Downloaded: 150
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: 9,526     Bookmarked: 17   Downloaded: 137
Please Sign up or sign in to vote.
Populating DateTime range in SQL Server
11 Apr 2020   Updated: 11 Apr 2020   Rating: 4.39/5    Votes: 6   Popularity: 3.42
Licence: CPOL    Views: 42,886     Bookmarked: 9   Downloaded: 948
Please Sign up or sign in to vote.
Store all data change history in a table using Entity Framework Core
3 Aug 2022   Updated: 3 Aug 2022   Rating: 4.60/5    Votes: 3   Popularity: 2.19
Licence: CPOL    Views: 11,222     Bookmarked: 3   Downloaded: 56
Please Sign up or sign in to vote.
Options to customize EF Core migration table
9 Aug 2022   Updated: 9 Aug 2022   Rating: 4.64/5    Votes: 11   Popularity: 4.64
Licence: CPOL    Views: 81,543     Bookmarked: 19   Downloaded: 471
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: 3.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 24,441     Bookmarked: 7   Downloaded: 56
Please Sign up or sign in to vote.
How to delete all rows in EF Core 6 using alternate options
Programming Languages
Basic
2 Aug 2020   Updated: 2 Aug 2020   Rating: 4.27/5    Votes: 5   Popularity: 2.99
Licence: CPOL    Views: 19,100     Bookmarked: 4   Downloaded: 435
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.77/5    Votes: 12   Popularity: 4.97
Licence: CPOL    Views: 58,590     Bookmarked: 16   Downloaded: 465
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: 42,776     Bookmarked: 14   Downloaded: 154
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: 143,409     Bookmarked: 49   Downloaded: 2,452
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: 19,337     Bookmarked: 9   Downloaded: 156
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: 4   Popularity: 3.01
Licence: CPOL    Views: 45,499     Bookmarked: 7   Downloaded: 645
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: 30,827     Bookmarked: 10   Downloaded: 1,621
Please Sign up or sign in to vote.
Making schedule jobs exe using Quartz scheduler
5 Apr 2020   Updated: 5 Apr 2020   Rating: 4.90/5    Votes: 8   Popularity: 4.43
Licence: CPOL    Views: 43,518     Bookmarked: 9   Downloaded: 339
Please Sign up or sign in to vote.
Select data as DataTable object for a database using Entity Framework
29 Jun 2024   Updated: 29 Jun 2024   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: CPOL    Views: 6,450     Bookmarked: 6   Downloaded: 31
Please Sign up or sign in to vote.
Select data as DataSet object for a database using Entity Framework and map results them to entity lists
HTML
24 Jul 2014   Updated: 24 Jul 2014   Rating: 4.67/5    Votes: 35   Popularity: 7.15
Licence: CPOL    Views: 264,590     Bookmarked: 53   Downloaded: 6,833
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: 29,464     Bookmarked: 23   Downloaded: 395
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.42

Containers
Docker
6 Jul 2022   Updated: 6 Jul 2022   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 18,828     Bookmarked: 14   Downloaded: 154
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: 9,609     Bookmarked: 6   Downloaded: 64
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: 13,833     Bookmarked: 5   Downloaded: 72
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: 9,741     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: 34,751     Bookmarked: 9   Downloaded: 115
Please Sign up or sign in to vote.
A utility class to send parameters for IN() operator in SQL using parameterized queries
10 Jul 2019   Updated: 10 Jul 2019   Rating: 3.68/5    Votes: 7   Popularity: 3.11
Licence: CPOL    Views: 65,663     Bookmarked: 13   Downloaded: 100
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: 20,003     Bookmarked: 7   Downloaded: 98
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
19 Feb 2019   Updated: 19 Feb 2019   Rating: 5.00/5    Votes: 8   Popularity: 4.52
Licence: CPOL    Views: 25,972     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: 6,761     Bookmarked: 3   Downloaded: 77
Please Sign up or sign in to vote.
A utility query to find table generations in SQL Server relational database
5 Jul 2022   Updated: 5 Jul 2022   Rating: 3.91/5    Votes: 8   Popularity: 3.53
Licence: CPOL    Views: 4,451     Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
Using CASE with variable/SET, SELECT/UPDATE statement, WHERE clause, JOIN & ON clause
1 Jul 2023   Updated: 1 Jul 2023   Rating: 1.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 9,044     Bookmarked: 2   Downloaded: 18
Please Sign up or sign in to vote.
Split date time ranges into days or possibly other ranges using CTE in SQL Server
Desktop Programming
8 Feb 2019   Updated: 8 Feb 2019   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 15,630     Bookmarked: 1   Downloaded: 206
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: 16,302     Bookmarked: 9   Downloaded: 99
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: 22,642     Bookmarked: 17   Downloaded: 217
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: 28,074     Bookmarked: 20   Downloaded: 750
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: 9,516     Bookmarked: 0   Downloaded: 92
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: 53,045     Bookmarked: 16   Downloaded: 387
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: 23,337     Bookmarked: 7   Downloaded: 314
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: 49,027     Bookmarked: 21   Downloaded: 232
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: 7,647     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: 14,545     Bookmarked: 6   Downloaded: 67
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: 8,101     Bookmarked: 5   Downloaded: 41
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: 14,304     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: 11,713     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: 13,246     Bookmarked: 5   Downloaded: 43
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: 84,124     Bookmarked: 12   Downloaded: 288
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: 28,950     Bookmarked: 9   Downloaded: 90
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: 7,002     Bookmarked: 3   Downloaded: 27
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: 15,386     Bookmarked: 1   Downloaded: 60
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: 39,962     Bookmarked: 11   Downloaded: 994
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: 36,698     Bookmarked: 12   Downloaded: 700
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: 12,525     Bookmarked: 6   Downloaded: 333
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: 31,055     Bookmarked: 17   Downloaded: 363
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: 73,567     Bookmarked: 7   Downloaded: 579
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: 8,399     Bookmarked: 1   Downloaded: 157
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.
28 Dec 2021   Updated: 28 Dec 2021   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: CPOL    Views: 37,039     Bookmarked: 3   Downloaded: 26
Please Sign up or sign in to vote.
Delete all the records from the table using EF
18 Jul 2022   Updated: 18 Jul 2022   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 10,599     Bookmarked: 11   Downloaded: 89
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: 15,376     Bookmarked: 8   Downloaded: 44
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: 8   Popularity: 4.52
Licence: CPOL    Views: 60,261     Bookmarked: 14   Downloaded: 213
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: 181,741     Bookmarked: 30   Downloaded: 2,856
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: 28,924     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: 29,186     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: 54,308     Bookmarked: 8   Downloaded: 1,217
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: 23,164     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: 16,242     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: 16,995     Bookmarked: 6   Downloaded: 112
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: 10,540     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: 26,558     Bookmarked: 3   Downloaded: 58
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: 15,894     Bookmarked: 8   Downloaded: 77
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: 35,097     Bookmarked: 8   Downloaded: 320
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: 100,385     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.
Bangladesh Bangladesh
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.