public List<Node> GetAllNode()
{
List<Node> nodes = new List<Node>();
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
var result = (from n in ctx.Nodes
join t in ctx.Tokens on n.NodeID equals t.NodeId
select new
{
NodeID = n.NodeID,
ConnectionString = n.ConnectionString,
Tokens = t.TokenKey
}).ToList();
foreach (var r in result.GroupBy(g => new { g.NodeID, g.ConnectionString }, g => g.Tokens))
{
List<Token> tokens = new List<Token>();
foreach (var value in r)
{
tokens.Add(new Token(value, r.Key.NodeID));
}
nodes.Add(new Node(r.Key.NodeID, r.Key.ConnectionString, tokens));
}
}
return nodes;
}
public List <Node> GetAllNode()
{
List <Node> nodes = new List <Node>();
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
var result = (from n in ctx.Nodes
join t in ctx.Tokens on n.NodeID equals t.NodeId
select new
{
NodeID = n.NodeID,
ConnectionString = n.ConnectionString,
Tokens = t.TokenKey
}).ToList();
foreach (var r in result.GroupBy(g => new { g.NodeID, g.ConnectionString }, g => g.Tokens))
{
List <Token> tokens = new List <Token>();
foreach (var value in r)
{
tokens.Add(new Token(value, r.Key.NodeID));
}
nodes.Add(new Node(r.Key.NodeID, r.Key.ConnectionString, tokens));
}
}
return(nodes);
}
public void AddToken(Node node)
{
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
ctx.Tokens.AddRange(node.Tokens);
ctx.SaveChanges();
}
}
public void AddNode(Node node)
{
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
ctx.Nodes.Add(node);
ctx.SaveChanges();
}
}
public void AddToken(Node node)
{
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
ctx.Tokens.AddRange(node.Tokens);
ctx.SaveChanges();
}
}
public void AddNode(Node node)
{
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
ctx.Nodes.Add(node);
ctx.SaveChanges();
}
}
public Node GetNode(Guid nodeId)
{
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
return (from n in ctx.Nodes
where n.NodeID == nodeId
select n).FirstOrDefault();
}
}
public Node GetNode(Guid nodeId)
{
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
return((from n in ctx.Nodes
where n.NodeID == nodeId
select n).FirstOrDefault());
}
}
public void RemoveNode(Node node)
{
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
ctx.Nodes.Attach(node);
ctx.Nodes.Remove(node);
ctx.SaveChanges();
}
}
public void RemoveNode(Node node)
{
using (var ctx = new ShardClusterDBContext(masterConnectionString))
{
ctx.Nodes.Attach(node);
ctx.Nodes.Remove(node);
ctx.SaveChanges();
}
}