C#

var usersWithRoles = (from user in context.Users  
                                  select new  
                                  {  
                                      UserId = user.Id,                                        
                                      Username = user.UserName,  
                                      Email = user.Email,  
                                      RoleNames = (from userRole in user.Roles  
                                                   join role in context.Roles on userRole.RoleId   
                                                   equals role.Id  
                                                   select role.Name).ToList()  
                                  }).ToList().Select(p => new Users_in_Role_ViewModel()  
   
                                  {  
                                      UserId = p.UserId,  
                                      Username = p.Username,  
                                      Email = p.Email,  
                                      Role = string.Join(",", p.RoleNames)  
                                  });

Hey all,

So I'm coding on some random dungeon-gen, and up until now it's being going great.

I am getting the error Not all code paths return a value I looked into the error, tweaked my code a little and I'm still not making any progress. Let me post my code.

Quote:

using UnityEngine;
using System.Collections.Generic;

public class DTileMap
{
protected class DRoom
{
public int left;
public int top;
public int width;
public int height;

public int right {
get {return left + width - 1;} }

public int bottom {
get { return top + height - 1; }
}

public bool CollidesWith(DRoom other) {
if( left > other.right-1 )
return false;

if( top > other.bottom-1 )
return false;

if( right < other.left+1 )
return false;

if( bottom < other.top+1 )
return false;

return true;
}

}

int size_x;
int size_y;

int[,] map_data;

List<droom> rooms;

public DTileMap (int size_x, int size_y)
{
this.size_x = size_x;
this.size_y = size_y;

rooms = new List<droom> ();

map_data = new int[size_x, size_y];
for (int i=0; i < 30; i++) {
int rsx = Random.Range (4,8);
int rsy = Random.Range (4,8);

DRoom r = new DRoom();
r.left = Random.Range(0, size_x - rsx);
r.top = Random.Range(0, size_y-rsy);
r.width = rsx;
r.height = rsy;

if(!RoomCollides(r)){
rooms.Add (r);
MakeRoom(r);
}
}
}

bool RoomCollides(DRoom r)
{
foreach (DRoom r2 in rooms)
{
if(r.CollidesWith(r2))
{
return true;
}
}
}

public int GetTileAt(int x, int y){
return map_data [x, y];
}

void MakeRoom(DRoom r)
{
for (int x=0; x < r.width; x++)
{
for (int y=0; y < r.height; y++)
{
if(x==0 || x == r.width -1 || y==0 || y==r.height -1)
{
map_data[r.left+x, r.top+y] = 3;
}
else

{
map_data [r.left + x, r.top + y] = 1;
}
}
}
}
}

// Id's
// 0 = Void
// 1 = Floor
// 2 = Random
// 3 = Wall

Now, the error code is pointing towards line 69, but I check all of my value on lines 21 - 34.

If you need any extra information, let me know. I've tried to figure this out, but I'm stumped...

Thanks in advance!

* Microsoft Server Speech Platform runtime (x64)
* Microsoft Speech Platform SDK (x64) v11.0
* Microsoft Server Speeech Recognition Language - TELE (en - GB)
* Microsoft Server Speeech Recognition Language - TELE (en - US)
* Microsoft Server Speeech Recognition Language - TELE (sv - SE)

foreach (RecognizerInfo ri in SpeechRecognitionEngine.InstalledRecognizers())

using (SpeechRecognitionEngine recognizer = new SpeechRecognitionEngine())

recognizer.LoadGrammar(new DictationGrammar());

// SqlConnection cn1 = new SqlConnection();
 SqlDataAdapter dadapter = new SqlDataAdapter() { AcceptChangesDuringFill = false };
 dadapter.SelectCommand = new SqlCommand("SELECT X AS A, Y AS B FROM Tab1", cn1);
 DataTable dt = new DataTable();
 dadapter.Fill(dt);

//OracleCOnnection connOracle = new OracleCOnnection();
OracleDataAdapter da = new OracleDataAdapter("SELECT A, B from Tab2", connOracle)
                   {
                       AcceptChangesDuringFill = false
                   };

OracleCommandBuilder cb = new OracleCommandBuilder(da);
da.Update(dt);

da.InsertCommand = new OracleCommand("SELECT A, B from Tab2", connOracle);